I have to do this next week for a client. My plan to to use an Automation which can have 50 Actions. Each action can record the field name, the old value and the new value in a log table. Most of the time the old and new will be the same.
You can use an Automation each night to remove the unnecessary records, but if there are more than 1,000 per night, then the Automation will fail. So my plan is to use a Pipeline with 1 Step to call API_Purge Records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------