Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Timed Trigger with Conditions for Automations

Solved
Jump to Solution
230 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

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