Automations allow you to configure custom trigger-action workflows directly within your Airtable base. This will allow you and your team to save time by automating repetitive tasks, increasing communication efficiency, and reducing the overall margin of error.
Automations are scoped to individual bases and can be found next to the Share button in a base on desktop/browser versions of Airtable. Automations on our iOS and Android apps are unavailable at this time.
💡 Automations is in active development and more functionality is on the way. Automations is currently available on Pro and Enterprise plans. If you have any feedback to offer, feel free to share that with us here.
Automations can only be created/edited by individuals with Owner or Creator permissions. Collaborators with Editor level permissions and below will be able to view but not edit Automations.
An automation consists of a trigger followed by one or more actions.
A trigger is a specified event that initiates the automation. Available triggers include:
- When a record enters a view (Note: records that leave and re-enter a view will trigger again)
- When a record is created
An action is a step that performs a task such as sending an email. When the trigger fires and the subsequent actions are complete, the automation is said to be executed.
Currently, there are six actions available:
- Send an email
- Create record
- Update record
- Send a Slack message
- Send a Microsoft Teams message
- 🆕 Run a script (***Unavailable to customers on Pro-trial or Creator plans)
Tips to ensure proper setup
💡 It's important to know whether or not your base has any field or table editing permissions set up at the "Creators and up" level. You can think of Automations as having "Editor" level permissions. Therefore, if any fields or tables are restricted by higher permission levels, then your automations will not be able to effectively create, update, or read information from those records.
💡 Consider when you want the record trigger and subsequent action to occur. Is it when a record is created, a status is changed or when all fields in a record have been populated and the record is considered 'complete'? Some ideas include:
- A status field changed to 'Ready to send email' or other appropriate phrase for the particular action.
- A 'Created On' field using the created time field type. Set the view filter to only include records before today. This will create a delay on when records are sent.
- Use a form. By only using a form to create new records, all fields are added simultaneously upon submission. Ideal for automations that trigger when a record is created.
- For a simple way to mark a record as complete, add a checkbox field.
💡 Make sure the first record in the view has a value in all the fields needed in your automation. During creation, you will be prompted to test your automation with a real record. At the moment, usable fields are derived from the test result of the trigger. If a test field is blank, it will not be shown in the setup.
💡 Consider locking the view and adding a note that editing the view filters could cause unintended automations to run.
💡 When troubleshooting your setup, if you see a ”Received invalid inputs” error, try re-testing the trigger to get an updated snapshot.
- When you change your base, we don’t update the test record that’s being “saved” in the trigger, so testing later actions is using a “stale” record that doesn’t reflect your changes.
💡 Be aware of circular automations. This can occur when an automation re-triggers itself.
- Example: a trigger for 'When a record enters a view' followed by an action to 'Create record' in the same view. This trigger/action pair creates an infinite loop of automations.
💡 Having a grasp of record_ids within Airtable can be very useful for Automations.
- Enterprise plan: A limit of 500k monthly runs per workspace and 3 years of run history.
- Pro plan: A limit of 50k monthly runs per workspace and 1 year of run history
Our system counts an automation “run” each time a trigger is invoked. This means that both failed and successful automation attempts will count against a workspace’s monthly run allowance.
If you’d like, you can add up to 25 actions in one automation. Where applicable, an action can use outputs from previous actions in the same automation.
Most field types are supported to include in one step to another, however, certain fields are not currently available (Fields that cannot be selected will be greyed out):
- Linked record fields
- Lookup fields
- Multiple select fields
- Rollup fields that use just “values”
- Collaborator fields with “Allow adding multiple collaborators” toggled on