Hi all
I am trying to have AirTable send out a webhook at a specific time for records that meet specific conditions, but I realized the "At a scheduled time" trigger does not really allow me to go through conditions to search for specific records.
I was considering to work around this by changing the trigger to "When record matches conditions" and set one of the triggers to a formula field with DATETIME_FORMAT(NOW(), 'LT'.
But I realized the system does not update the NOW() field in real time (seems to be around every 10min or so?)
Is there another workaround within AirTable itself? Or do I have to use make.com/zapier to make this work?
Just for reference, I simply want AirTable to send out a message to my team members at a specific time if there's a record that specifically meets the conditions.
Thanks in advance
Page 1 / 1
Aside from the NOW() formula limitation, one of the few options remaining directly within Airtable is to trigger on a specific time, and then search using the "Find records" action with conditions set appropriately. If needed, you could also use conditional action groups in the automation design.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.