Airtable
This page describes how to use Census with Airtable.
Last updated
This page describes how to use Census with Airtable.
Last updated
In this guide, we will show you how to connect Airtable to Census and create your first sync.
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.
Airtable support is pretty straight forward!
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).
Contact us via support@getcensus.com or start a conversation with us via the in-app chat.
Object Name
Supported?
Behaviors
Table
✅
Update Only, Update or Create, Mirror
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:
[ { "url": "http://path/to/attachment.png" } ]
The Rest
Census will give an informative error
message if rejected by Airtable