Hello,
Currently I utilize an audit log table which when viewing the form you see many sections which are divided by tables. Within each section, I have at least 3 fields:
[field_name old], [field_name new], [field_name updated].
Now one section (table) may have 8 fields that I want to track, which then requires me to create 24 fields. This is not practical, but it does work.
My question. Is there a way to create an audit log with only a handful of fields:
[field name]
, [table name]
, [old value]
, [new value]
, [updated value].
Then have a pipeline which triggers on specified fields when modified, and create a record for each* field modified.
So if I am trying to track 3 fields, and someone modifies those 3 fields. A pipeline is triggered and 3 records are created on this new simplified audit log.
Hope my vision makes sense. I've been told, and often say myself, if you can say it out loud, it can be done in Quickbase. This one though is a doozy.
Any suggestions?
