The fact that Ragic keeps a history of changes made to each record is great! And I also love the ability to view and download changes to sheets via the adminstrator’s Data Management tool, Recent Changes.
However, as far as I know, none of those options give the user the ability to download the history of ALL records in a given sheet / data table.
Feature Request
Please give administrators the ability to download history data for all records in a sheet as a single CSV.
Additional Considerations: It would be nice if that download included the history of deleted records (if possible)
Including history on deleted records may present technical challenges, so if full record history on deleted records is not possible, then please at least have information such as the record name, date deleted, and user who deleted it.
The goal of being able to download the history data is to be able to run reports such as:
- All records touched/deleted/created by a particular user in the past week
- All records that have been edited at a particular Date/Time.
- All records that have been renamed to a name containing {Input Naming Mistake}
(regEx expressions useful here)
Use Cases
As can be guessed from the above example reports, the biggest use cases for me arise when I am scanning through records and notice an error/discrepancy that has signs that it could be an error that was done more than once by a particular user during his entries on a particular day.
- For such a scenario, a report showing all records changed on date X at time Y by a particular user would be useful.
Also, sometimes business gets heavy and time constraints require many urgent ad-hoc changes to records in the database. After things slow down, admin staff should have a change to go back and clean up each haphazardly edited entry. However, unless they write down all records that need to be proofed (an easy thing to forget to do), one record will inevitably be forgotten about, and time will eventually mature the error into an unpleasant surprise.
- Again, for the above reason, it would be amazing to be able to generate a list of all records modified by a particular User on a certain Date.