Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago

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 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
------------------------------
Pipelines
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------