Hi David, and welcome to the community.
Hypothetically, there is now a way to do this and more. I haven’t actually done it, but it goes something like this:
- For any table you want to track revisions on, create a condition that causes modified records to appear in a “revisions” view.
- Create a script action that is performed on any records in that view; the script action simply creates a revision log (internally as another table or externally in another system). It should contain the record ID, dates/times, with other meta data as desired.
- Create a reporting process (API or otherwise) to export the log data.
Optionally, such a process could send the entire changed record to another system, thus negating the need to export at all.
Hypothetical, non-trivial effort, possibly achievable with Zapier and Integromat, but likely to work.
