Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 years ago

Pipelines: How to generate list of fields that were modified in "record modified" trigger

I am creating a changelog that multiple tables use. I would like it to report which field was changed, the old value and the new value. If multiple records were changed, multiple changelog records wou...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
What I have done in the past for this logging is to record the old and new value for each field I want logged.  But with a single trigger that the record was edited.  of course this means that most of the fields will have the old and new value the same. 

So I filter those audit log records off the reports and have a nightly process to delete them.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------