Create a Day Counter Since a Field Change

Question

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!

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community