Help

Automation trouble

Topic Labels: Automations
1109 2
cancel
Showing results for 
Search instead for 
Did you mean: 
johnpatrickfray
4 - Data Explorer
4 - Data Explorer

Hi!

I'm trying to create an automation that is applied when a particular field contains today's date.  However, when I apply this condition, it can no longer find any relevant records.  All other conditions are working correctly, my specified field does indeed contain today's date when I check my table, and my Airtable calendar is correctly synched.  Any suggestions out there?

Cheers!!

John

2 Replies 2

@johnpatrickfray you would have to share a bit more details - maybe some screenshots? 

What I suspect is something related to the precision of the dates - something that looks like "today's date" can be actually multiple different date & time values, since in Airtable date always contains time element to it.

You can also take a look at the answer here: https://community.airtable.com/t5/formulas/today-cannot-read-date-from-created-time-field-correctly/... 

TheTimeSavingCo
18 - Pluto
18 - Pluto

In addition to Greg's answer, automations don't work on conditions that already exist when the automation is turned on.

i.e. if your condition is "checkbox marked", and you have 5 records in your table with the checkbox marked before your automation turns on, when you turn on the automation it will not run on those 5 records; you'd have to uncheck and then re-check those 5 records if you wanted the automation to run on them