Jun 29, 2022 02:47 AM
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?
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.
Jun 29, 2022 10:21 AM
This group is empty–no actions will run when triggered
Have I put the condition in the right place?
Jun 29, 2022 10:28 AM
You have your trigger set to run when certain conditions are met. Put the Calculation = 7 there.
Jun 29, 2022 10:42 AM
Ah like this?
Jun 29, 2022 10:44 AM
Yep, though I would use “greater than or equal to”