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------------------------------
Original Message:
Sent: 06-24-2020 13:38
From: Michael Sargent
Subject: Tracking Changes
I've seen different variations of the "change log". I saw the post about onload techniques using JS to track changes. I tried that and unfortunately it's not working and I can't make contact with the member who posted the original information. I am using Actions now, but there is a limitation of 10 actions per table and i have way more than 10 fields. Perhaps I need to go the route of automation or pipeline to accomplish what i need.
------------------------------
Michael Sargent
Original Message:
Sent: 05-08-2020 07:59
From: Paul Peterson
Subject: Tracking Changes
Are you just looking to track changes? If so, a change log is an easy solution.
------------------------------
Paul Peterson
Original Message:
Sent: 05-07-2020 13:09
From: Michael Sargent
Subject: Tracking Changes
I searched prior discussions before posting this, so I apologize if it's a duplication. If it is just refer me to the prior article. Anyhow, I have a table with 45 fields, any of which could change. I'd like to keep an audit trail of changes to records for any of the previously mentioned fields.
How would I set it up so I can bring awareness to which field changed and perhaps what the old value was and now the new value? I want my clients to be able to pull reports of any changes based on a particular record ID.
Thanks,
------------------------------
Michael Sargent
------------------------------