Pipeline to create a change log

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
[email protected]
------------------------------