Airtable automation trigger: When record matches conditions

Automations allow you to perform an action whenever a record fires the trigger for that automation. When building an automation, the first step is to the choose the trigger that will start that automation. The "When a record matches conditions" trigger will run when a record matches the conditions you define in your particular configuration. 

Select the trigger

After you add an automation, the first step is to select the trigger you want to use. In this example, we'll use the "When a record matches conditions" trigger.

Select your data

After choosing the trigger, you need to select the table that you want to setup your filter conditions for. Then, add in the filter criteria you want to use to trigger the automation. In the example below, we've configured the automation to trigger every time a project in our "Video Tracker" table has it's "Project Status" field equal to the exact value, "Ready to Publish". You'll then want to test your trigger to make sure it works.

Add an action

After you’ve configured and tested the trigger, it’s time to add an action. In the example below, we’ll use the “Send Email" action to send a message to the person who requested this project initially, populating the message with information from the record that triggered this automation:

Once you've setup the action, run a test on the action to make sure it's configured correctly. Lastly, make sure to turn your automation on. You can then view information on any past automation occurrences in that automation's run history.

FAQs

Why aren't the date, or time-based, conditions in my "When a record matches conditions" trigger evaluating correctly?

Automations run on GMT since that is the default timezone that Airtable operates on behind the scenes. When setting up time-based conditions in Automations you may need to adjust times manually or create a formula to auto-adjust times so that the conditions evaluate according to your timezone.

Why aren't all of the records currently matching the conditions I've set triggering the automation to run?

Triggers do not work retroactively. Records that matched the conditions before the automation was configured and turned on will not cause the trigger to run. The record will need to change states for the trigger to recognize the conditions being matched. As a workaround, you could clear out the data from multiple records (just one of the fields related to conditions you've set will need to be cleared) and then press CtrlZ (undo). This will cause the record to change states, thus triggering the automation to run. Using this workaround, it's important to think about how clearing data out might affect other automations or workflows. Be cautious when using this method. Alternatively, if you find yourself needing to update existing data in your tables we recommend checking out the Batch update extension.