I seem to be missing something simple, hopefully someone can help me out!
I have an automation I am setting up. To put it simply, the automation should do:
The automation seems to work in test runs. However, in actual execution, it fails every time. I have entries where the last submitted change was made two weeks ago but nothing happens. Can someone either offer some insight as to what I’m doing wrong, or help me figure out how to set the automation up so that it functions?
That should work, although I don’t think it will trigger until 48 hours have passed, because Airtable would consider a record to be “1 day ago” until it is “2 days ago”.
If that still doesn’t work — or if you want it to trigger exactly at 24 hours — you would need to create a formula field that calculates the difference in hours between “last submitted change” and
Then, you would trigger your automation when that formula field is greater than or equal to 24.