AnsweredAssumed Answered

Update a field based on another field's timestamp

Question asked by Stu412 on Jan 4, 2017
Latest reply on Jan 4, 2017 by erolst

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?

 

Thanks

Outcomes