Activate the change tracker in any database to monitor modifications made to the database itself or its records.
The change tracker logs changes for up to 15 days, including modifications made to the database or its records within the DATA MANAGEMENT tab by an author, in a data view by an end user, via a module, or a public API.
Note that admins can configure a shorter data retention period, which will impact the duration for which changes are logged.
The change tracker logs the following data and displays it in a table view:
- The
TIMESTAMP
of when the change was performed, - the
EVENT
associated with the change, includingCREATE
,UPDATE
,DELETE
, andDELETE_ALL
(triggered when using the Erase all function within Data Management), - the
RECORD ID
, - the
CHANGES
that took place. Clicking the Open change details button allows you to view the changes in detail, and -
USER NAME
andUSER EMAIL
of the person who performed the change.- If the change was performed in the DATA MANAGEMENT tab, the user name will display as
Authoring User
. In case of a public module or data view or API, it will showAnonymous User
. In either scenario, the USER EMAIL column will remain empty.
- If the change was performed in the DATA MANAGEMENT tab, the user name will display as
How to activate the change tracker for your database
If you want to monitor database (record) modifications, follow these steps:
- In your application, navigate to the Database section on your Build page and open a database.
- Go to the CHANGE TRACKER tab in the top right corner.
- Activate the change tracker.
Note that the change tracker is specific to each environment, and it needs to be activated separately for each environment. Additionally, it logs changes separately for each environment.
Known limitations
- Once activated, the change tracker cannot be deactivated.
- Since the change tracker only shows modifications made in the past 15 days and their current values, you may not be able to trace back to the original or previous values.
- Modifications made to the database before enabling the change tracker are not logged and will not be available. This includes any records created when setting up a database from an MS Excel file.