To echo what Blake has said above, that is the way I do it as well. I choose to say the five or 10 most important field to track and have an automation which has say 6 actions For the five fields being tracked. The first five steps write out an audit trail record into a table which includes the name of the field, the old value the new value and the last modified by so we know who did the audit. Obviously it already will know the timestamp because every record and Quickbase has an automatic timestamp. Then the last step of the automation can be to delete where the old value and the new value are the same.
If I plan to have an audit trail and multiple tables, then I include the table name as one of the fields being written to the audit trail.
You should also record the record ID of the record that was being changed and then put a report link on the table being audited to show an embedded report link of the audit trail.
Actually works very well as long as you don't have a ridiculous number of different fields to audit.
Fortunately, you can copy action steps in an automation so once you get the first action step working for One field it is fairly quick to copy that step to do additional fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
