I have a parent table with a bunch of linked children.
On the parent table, I need to be able to click a check box, which will give the user a 30-minute grace period before the record is “Frozen” (it will move out of an interface section and into another one). The children will then move into a view that will sync it to another base, where automation will create a CSV and upload it to a server somewhere.
My thinking was to have a last modified filed field keep track on when the check box was clicked and then add 30 min to that and then let that determine the rest.
However I’ve now been looking into the NOW() and it seems quite unreliable for things to do with precision and filtering records into a view to be synced to another base, is also an issue as the date time will only allow me to filter days, but not use time.
I can see how this could potentially be solved with a fairly expensive automation setup, where automation constantly looks for updates when the user clicks the check box. I would really like to avoid this. So, I wonder if anyone has any other ideas for making this a bit more ‘elegant’. Any points will be hugely appreciated.
