That is correct. Unfortunately, Airtable only updates the time every 10-15 minutes.
Hey @Zion_Brock!
So, it isn’t actually a bug.
When it comes to formulas, Airtable does not keep minute-to-minute, up-to-date time/date values.
When the base is active, it updates in fifteen-minute intervals.
I’m actually in the middle of talking to someone at Airtable internally about this since it has historically caused me some issues. If I get more context from the product side, I’ll definitely provide it to everyone here.
The workaround that I have implemented might not be viable for your use case, but it’s worth highlighting.
I have a time interval-based automation that runs every minute during business hours.
From there, I have a script that queries for records that meet a given criterion. Primarily, it looks for records that have hit a minute-sensitive SLA and escalates records that do not satisfy the condition.
To give a sense of the scale of this solution, the automation catches between 40-70 records per run.
Hey @Zion_Brock!
So, it isn’t actually a bug.
When it comes to formulas, Airtable does not keep minute-to-minute, up-to-date time/date values.
When the base is active, it updates in fifteen-minute intervals.
I’m actually in the middle of talking to someone at Airtable internally about this since it has historically caused me some issues. If I get more context from the product side, I’ll definitely provide it to everyone here.
The workaround that I have implemented might not be viable for your use case, but it’s worth highlighting.
I have a time interval-based automation that runs every minute during business hours.
From there, I have a script that queries for records that meet a given criterion. Primarily, it looks for records that have hit a minute-sensitive SLA and escalates records that do not satisfy the condition.
To give a sense of the scale of this solution, the automation catches between 40-70 records per run.
Awesome, thanks so much for your input and suggestion!
@Zion_Brock Just an FYI: I keep trying to wean myself & my clients away from Make.com, but it’s just not 100% possible yet. Make.com is an external automation platform that is low-code/no-code. It costs extra money per month, but it has advanced scheduling capabilities that you can schedule down to every 60 seconds.