The Audit Trail Manager enables you to keep track of every modification that's made to your data. You can view the edit details (what was changed, when, and who made the change) and revert a modification to its original state. (Administrator privileges required!)
The Audit Trail is an optional way for you to keep track of every change that's made to your data: who made it, when, and exactly what was changed. It keeps track of the original and new values, so you can see what something was change from and to.
To turn the Audit Trail feature on:
All Tables/Selected Tables: If All Tables is selected, CatBase will create an Audit Trail record whenever anything is changed in ANY of your data tables. If Selected Tables is selected, you will be able to choose which data tables to maintain an Audit Trail on.
Track records added to the database: Creates an Audit Trail record whenever a new record is added and saved.
Track records modified: Creates an Audit Trail record whenever an existing record is changed.
Track records deleted: Creates an Audit Trail record whenever a record is deleted.
Track Memos: Creates an Audit Trail record whenever a Memo is created or modified.
Click the Save button when you're happy with your selections.
If you selected the Selected Tables option, you can choose the tables you want to keep track of:
Note: if the checkbox isn't selected, but you chose the All Tables option in the Audit Trail setup, the Audit Trail will be active for that table.
You don't need to do anything! Once the Audit Trail option has been turned on, CatBase will automatically create an Audit Trail entry every time a record is saved or deleted.
A modification can be reverted to its previous value using the Rollback feature. For example, suppose you look at the Audit Trail entry shown above and realise that the price should not have been changed from 12.50 to 24.95. You could search for that record and edit it manually, or you can do it the easy way: