2 Replies Latest reply on May 5, 2016 4:58 AM by kurt.bleicken

    Elapsed Time Field - how to trigger recalculation

    mchancevet@gmail.com

      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