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