AnsweredAssumed Answered

Elapsed Time Field - how to trigger recalculation

Question asked by mchancevet@gmail.com on May 5, 2016
Latest reply on May 5, 2016 by kurt.bleicken

Hello,

I have two similar fields in two tables

Item::ElapsedTime

Order::ElapsedTime

 

They are calculations

 

Basically

 

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?

 

Thanks,

Morgan

Outcomes