Pipeline to create a change log

Question

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 record the value before and after the change along with who made the change and when the change was made. I am new to tinkering with pipelines and would like some guidance to avoid spinning me wheels for a few hours.

------------------------------
Paul Peterson
------------------------------

MarkShnierYou · Answer

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

Sign up

Login to the community