Triggering an automation that will trigger make au...

[Dennis_Yu]

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

[Justin_Barrett · Accepted solution]

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.