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?
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.