Hello everyone! I’m having significant challenges with getting an automation to run on a schedule.
Airtable says:
" Can I set up a script to run on a schedule using Automations?
- At the moment, there isn’t a built-in way to set up a script that runs on a regular time-based schedule (e.g. every day at 9am). A workaround is to use a time-based filter on a view."
However, the time filter doesn’t seem to work very well for more frequent than daily. I was able to get ~ every minutes, but I was hoping to get something more real-time. To test the concept, I made a table where the first column is the “age” of the record using the following formula:
DATETIME_DIFF(NOW(),CREATED_TIME(),"seconds")
I then set up the automation to trigger when a record enters a view which filters all records newer than 10 seconds. The automation adds a new record to the same table. In theory, the automation should be running every 10 seconds continuously.
But, that formula only updates every 5 minutes or so. I’m not 100% certain on the time interval, but refreshing the base does not cause it to update.
Any thoughts on how to run a script more often than every 5 minutes?
p.s. This is to automate back-linking to prevent misinformation when records aren’t back-linked properly.