Discussions

  • 1.  Create a Day Counter Since a Field Change

    Posted 23 days ago

    Hello,

    Is there a way for a day counter to reflect how long since a field has been altered? 

    I have a STATUS field for a table and I want it to count days since the last time the status has changed. This is not to be confused with the process to count days since the item in the table was last altered, but that field specifically.

    Thank you so much for your support!



    ------------------------------
    Anthony Wong
    ------------------------------


  • 2.  RE: Create a Day Counter Since a Field Change

    Posted 23 days ago
    If your data entry is always on forms,  and never Grid Edit, you can make a field called [Date / Time Status Last Changed] and have a Form Rule that says

    When the record is saved
    and
    Status has changed

    Change the value of the field  [Date / Time Status Last Changed] to the current date/time.

    But if the data entry might be by Grid Edit, then you will need to use an Automation or Pipeline to record the date/time when the status was changed.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------