Airtable
This page describes how to use Census with Airtable.
🏃♀️ Getting Started
In this guide, we will show you how to connect Airtable to Census and create your first sync.
1. Add an Airtable Connection
Navigate to the Destinations page.
Click the New Destination button and select Airtable from the list.
Complete the OAuth flow to connect your Airtable account to Census. As part of the OAuth flow, you'll be able to select the specific workspaces and/or bases you'd like to connect to Census. You can always add more workspaces and/or bases later by clicking the Reauth button on the destination in Census.
Note: Census's permissions will be the same as the Airtable user you used during OAuth. If you think this Airtable user's permissions may change or the account is removed, you may want to create a special Airtable account just for Census to use.
You should now have a connection to Airtable! Let's start syncing data.
🗄 Supported Objects and Behaviors
Airtable support is pretty straight forward!
Object Name | Supported? | Behaviors |
Table | ✅ | Update Only, Update or Create, Mirror |
Learn more about all of our sync behaviors on our Core Concepts page.
Airtable needs a primary key that is a short text field for Census to be able to join from a source table (though the source can be a numerical type).
Column types
Airtable Field Types | Source SQL |
Short Text | String Numeric |
Single Select | String Numeric |
Checkbox | Boolean Numeric (nonzero = checked, 0 = unchecked) |
Attachments | A structured column of the following structure:
|
The Rest | Census will give an informative error message if rejected by Airtable |
🚑 Need help connecting to Airtable?
Contact us via support@getcensus.com or start a conversation with us via the in-app chat.
Last updated