Looking to add Airtable to your workflow? Here's what you can expect from our integration.
What does this article cover?
- Which fields can be synced in Airtable?
- How to generate an API key in Airtable
- How to add a Last modified time field
- Limitations and things to keep in mind
Which fields can be synced in Airtable?
Here are the fields you can currently sync with Airtable, whether they can be used in two-way flows, as well as whether you can use them in rules or not.
Most fields can be synced both ways. This means changes in one tool will affect the other and vice-versa. You can also edit a flow (or a specific field mapping) so that changes only go from one tool to the other and not back.
| Airtable Field | One-way? | Two-way? | Rules? |
| Single-line text | ✔ | ✔ | ✔ |
| Multi-line text | ✔ | ✔ | ✔ |
| Dropdown (single-select) | ✔ | ✔ | ✔ |
| Dropdown (multi-slect) | ✔ | ✔ | ✔ |
| Date | ✔ | ✔ | ✔ |
| Date time | ✔ | ✔ | ✔ |
| Checkbox | ✔ | ✔ | ✔ |
| Phone number | ✔ | ✔ | ✔ |
| ✔ | ✔ | ✔ | |
| URL | ✔ | ✔ | ✔ |
| Number | ✔ | ✔ | ✔ |
| Currency | ✔ | ✔ | ✔ |
| Percent | ✔ | ✔ | ✔ |
| Barcode | ✔ | ✔ | ✔ |
| Collaborators | ✔ | ✔ | ✔ |
| Attachments | ✔ | ✔ | |
| Rating | ✔ | ✔ | |
| Multiple lookup values | ✔ | ||
| Count | ✔ | ✔ | |
| Duration | ✔ | ✔ | |
| Created time | ✔ | ||
| Auto number | ✔ | ||
| Formula | ✔ | ✔ |
What counts as an item in sync?
For Airtable, Unito counts every synced record as an item in sync.
How to generate an API key in Airtable
When connecting your Airtable account to Unito, you'll need to generate an API key or copy an existing one. Just go into Airtable, click on your avatar in the top right corner of your screen.
Click on Account in the dropdown, and scroll down to the API header. Generate (or copy) your API key here.
Then, when you go to connect Airtable with Unito, just paste your API key when prompted. It's that simple. Note: If you've already generated an API key, don't generate a new one, or you'll create problems with any other integrations you're using. Just use the key you already have.
How to add a Last modified time field
Make sure to add the Last Modified Time column to bases you want to sync. Unito workflows need this bit of data in order to work properly. You can always hide this column if you don't need to see it, but make sure you don't delete it.- From your Airtable base, click + to add a column.
- Scroll down the list and look for Last Modified Time. Not to be confused with Last Modified By. They're different fields with similar sounding names, so don't mix them up.
- You can give it a name, or not, but this field won't be mapped by Unito. It is required, however, for your flow to function as intended.
Limitations and things to keep in mind
We’re constantly looking to better support Airtable’s growing list of features, fields, and use cases. Here are a few things you can't do yet:
-
Signing up to Unito with your Airtable account
-
Creating a table from Unito
-
Syncing comments
In addition, there are some specific things you need to keep in mind if you want to add Airtable to your workflows.
-
Usually, Unito will automatically map similar fields across tools. In Airtable, that isn't always possible, since you can use Airtable fields for just about anything. With that in mind, make sure you create a Title column in Airtable using a Single-line text field, and map it to a similar field in your other tool. Otherwise, you might end up with a bunch of work items with no titles!
-
If you want to sync a dropdown list (like Status), make sure it's in the base you're building your workflow around. Otherwise, you won't be able to select it when you customize your mappings.