Pipeline to create a change log
I recall seeing a post during a recent search but am not able to locate it this morning. My question, is it possible to use a pipeline to track the changes to a set of fields in a table? I want to r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYes, you can make a child table to the table being tracked called say Audit Trail. One record has many Audit Trails.
Then you can have a Pipeline which triggers on the change of certain fields and write the value of the field name, the old value and the new value, and the Last Modified by (ie the person who did the change) and the Record ID# of the Record.
This of course will result in many records being written out where there was no change to a particular field. Those can be filtered off any reports and then you can have an overnight process to delete any audit trail records were the old value and the new value was the same.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then you can have a Pipeline which triggers on the change of certain fields and write the value of the field name, the old value and the new value, and the Last Modified by (ie the person who did the change) and the Record ID# of the Record.
This of course will result in many records being written out where there was no change to a particular field. Those can be filtered off any reports and then you can have an overnight process to delete any audit trail records were the old value and the new value was the same.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I'm good with the overall process, but not sure how to capture the value before the change?
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
- MarkShnier__Yousorry, I left that important part out of my response.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=657fdac9-9fd0-4a73-9a40-05c46e8fab09&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
Drag the field to the box and then hand edit it to insert the "$prev"
so Drag this
{{a.est_start_date}}
and hand edit it to be this
{{a.$prev.est_start_date}}
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you. I'll work on this later today!
------------------------------
Paul Peterson
------------------------------