- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 02:47 AM
Hi,
I’d like to have my automation that is currently triggered by a When record matches condition
to only run once per day. It seems the only way to have an automation run at set times is to set the trigger as At a scheduled time
. However switching the trigger to be time dependent means I can’t have a When record matches condition
rule.
Any suggestions on how to make my automation time dependent so that it only run once per day?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 10:06 AM
Add a formula field that returns the time of “today”. HOUR(NOW())
will work.
Then add as a condition to your automation that the Formula field >= 7 or something to have it run at 7am GMT. Adjust the number for your preferred time and timezone.
Note that relying on exact timing with NOW() is iffy at best. The automation will fire anywhere from 5 mins to a few hours after the value hits “7” because Airtable only recalculates NOW (and TODAY) frequently when you have the base open, and otherwise recalculates every hour or so. See the note on this help article.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 10:21 AM
Thank you.
It says This group is empty–no actions will run when triggered
Have I put the condition in the right place?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 10:28 AM
You have your trigger set to run when certain conditions are met. Put the Calculation = 7 there.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 10:42 AM
Ah like this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 10:44 AM
Yep, though I would use “greater than or equal to”