I have two similar fields in two tables
They are calculations
If (Item::ThresholdValue < x; get (current timestamp) - Item::CreateTimestamp; Item::ThresholdTimestamp - Item::CreateTimestamp)
So if the threshold is not reached it gives the time elapsed since the record was created otherwise it gives the elapsed time between the record creation and the threshold being reached.
How to keep the calculation refreshed though so elapsed time is dynamic and actually representing the time elapsed if the threshold has not been reached.
I thought about having the get(current timestamp) as a field and updating it (set field) scripturally.
Any other ideas?