BobWolff
2 years agoQrew Member
Changelog / Timestamps
Hi all - I'm trying to create a changelog that shows timestamps when a record's status has changed (i.e. pending, in progress, completed, etc.) I was able to create timestamps for all the different statuses that seem to work correctly. The issue is with the changelog where I'm trying to log and show not only the time/date the status was changed, but also the user who changed it. I created 2 fields:
1) Track Changes: This is a simple text formula like: "Status="&[Status]
2) Changelog: A text field to capture the changes (field setting are also checked to capture the user who made the change)
I have form rules that update the timestamp fields as the status' are changed, and one last one that basically says when the record is saved to copy Track Changes into the Changelog field.
So it almost works, the changelog tracks the time/date, user and status - however the status seems to be a save behind. For instance if the status was Pending and a I change to In Progress and save it, the changelog shows Pending. If I reopen and save again then it will say In Progress. Not sure what I'm missing here, I used this method in the past and it seemed to work but I must be missing a step somewhere...
------------------------------
Bob Wolff
------------------------------
1) Track Changes: This is a simple text formula like: "Status="&[Status]
2) Changelog: A text field to capture the changes (field setting are also checked to capture the user who made the change)
I have form rules that update the timestamp fields as the status' are changed, and one last one that basically says when the record is saved to copy Track Changes into the Changelog field.
So it almost works, the changelog tracks the time/date, user and status - however the status seems to be a save behind. For instance if the status was Pending and a I change to In Progress and save it, the changelog shows Pending. If I reopen and save again then it will say In Progress. Not sure what I'm missing here, I used this method in the past and it seemed to work but I must be missing a step somewhere...
------------------------------
Bob Wolff
------------------------------