As of a few days ago, you can now schedule automations and your automations can search for records (up to a maximum of 100 records). So I would play with those new options to see if those easily solve your dilemma! :slightly_smiling_face:
Thanks for the answer. I am using both of those but in order to do what I want, I need to determine the time of the run and compare it against the records “Prefered Hour” field.
The only way I can think of determining the time the Schedule runs is to have a Now() formula in a field that compares. I’m just unsure if the filed with Now() in updates regular and so I’m not sure it’s reliable.
So I’m looking for a better method or clarification on how a field with a now() formula updates, seems irregular.
If you’re logged into Airtable, NOW() updates every 15 minutes or so.
If you’re not logged into Airtable, it updates every hour or so.
It’s imprecise & approximate.
If you need precise scheduling that takes place at the very second that you automate it to be scheduled, then you would be best served by Integromat, which is a professional automation tool with professional scheduling capabilities.
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.).
I am using Integromat to do this at the minute and it works, but it uses a lot of operations. I was hoping the new Airtable Automation Schedule and Search would allow me to use Airtable instead and save some credits.