I wanted to share what I figured out looking for a way to run an automation at a scheduled time.
First, create a helper table named Automation Trigger with 3 columns:
- Name (type: Single line text)
- Run At (type: Date, with time field included)
- Record (type: Formula, expression:
For each automation you want to schedule:
- Add a row with a unique descriptive name
- Add a view with a filter matching only the one record added above (Name is …)
Add an automation:
- Choose trigger: When record updated
- Select table: Automation Trigger
- Select view: the one matching your automation intent
- Select the Run At field.
- Run test
- Add an action according to your needs
Finally, the scheduling piece. You’ll need Integromat or Zapier. Zapier allows to schedule a task only at a selected hour. Whereas Integromat is much more flexible. For example, you can schedule an action at regular intervals.
- Connect Integromat to your Airtable account
- Select Update a record action
- Select your base and the Automation Trigger table
- Copy a Record Id from the row in the Automation Trigger table that is matching your automation intent
- In the Run At field, add a formula
That’s it. Integromat will update the record in the Automation Trigger table at the specified schedule what in turn will trigger your automation in Airtable.
I’m looking forward to your feedback. Is there a way to simplify this solution?