Happy new year everybody....
I'm working on a very basic ticketing system just for myself and want the system to automatically change the status of a ticket from 'Cooling Down' to 'Closed' exactly one day after I've set it to cool down.
I've set a script trigger which runs when I change the status to 'Cooling Down' to set a timestamp field+86400 (dClosingDate) seconds which is one day in the future.
The issue I'm having now is how to get FM to automatically change the Status field from 'Cooling Down' to 'Closed' when the timestamp field = Get(CurrentTimestamp), ie, sometime tomorrow.
I've tried an auto enter by calculation on the text field for status with the following formula, but after waiting a few seconds...nothing happened!:
If ( dClosingDate = Get(CurrentTimestamp) ; "Closed" )
What am I missing here please?