Airtable
Authenticate
When you are setting up your first workflow with Airtable, you'll need to connect your Airtable account with MESA.
Click on the Connect with Airtable button to begin the process.
On the prompted modal, click on + Add a base and select All current and future bases in all current and future workspaces.
This base access is recommended because it will allow you to easily link any base from any workspace you create in your Airtable to your MESA workflow. If you choose another selection for this access, you may need to create a new credential for workflows going forward.
Click on Grant access once you are done.
Afterwards, you can re-use the newly created credential and select it for your future workflows!
Configuration
Retrieve fields from your Airtable Table
In certain Airtable actions, we can automatically detect the fields in your Airtable Base and add them to MESA using the Retrieve Table Fields button.
Your fields will display in the order that they were defined when you set up your Airtable Table. If you are viewing your table's data in an Airtable View, the order of the columns may be different.
Send data with different field types
Airtable provides a variety of field types that lets you store data in each record. Learn more about field types.
When using MESA's Variables feature, you will want to make sure that the data (that represents each variable) matches Airtable's expected format. When the data does not match Airtable's expectations, your workflow will fail.
I don't see my Airtable workflow activating when I update something in Airtable?
MESA workflows that contain Airtable triggers (such as Record Updated and Record Created) will run on a polling system. This means on every hour or whatever the selected frequency is selected, MESA will look for any recent activity in Airtable. As a result, you may not see immediate activity in your MESA workflow until the frequency hits.
Once the frequency hits, MESA will process every single task that has accrued within the previous timeframe. To change the default frequency, you can click the More options button from the Configure menu of the Airtable trigger and select the Schedule.
Please note that available frequencies will differ depending on your MESA billing plan.
Why did my workflow run so many times when I updated my field type?
When you update the field type of a column in your linked table from your Airtable base, Airtable will run an update on all records associated with that column based on the change. Unless you decline to be notified, Airtable will prompt you with messaging alluding to this update before converting:
Even if the records are not altered, Airtable will consider this an update to all records when this action is performed. As a result, if you are using an Airtable Record Updated trigger in your workflow, this will create an automation run for each of the records and will count towards your usage.
Potential Use Cases
Jumpstart your automation journey with one of our pre-made templates that you can install directly to the MESA dashboard.
Last updated
