How do we set this up?

How do we set this up?

Setup is simple. Just create tables with the following names and field names. All fields are text unless otherwise specified.

ab data changes - to record record creations, updates and deletions

• table id
• table
• action
• record id (whole number field)
• saved data
• field id
• field

ab logins - shows the date, time and details of each login

• ip address
• browser
• operating system
• provider
• country
• details

ab authentication changes - records important changes such as user privilege changes, password updates etc.

• table id
• table
• action
• details

ab view access - shows every time that a user looks at a view, or filters is

• view id
• view
• details

ab table changes - all schema changes made to tables, e.g. fields added or removed

• table id
• table
• action
• details

ab view changes - similarly, all changes to views, such as field, filter or calculation modifications

• view id
• view
• action
• details

The eagle eyed may notice that a couple of fields are missing from each of those tables, which are the user who made the change and the time it was made. That data is actually stored in the standard ‘system’ fields ‘created by [auto]’ and ‘creation time [auto]’. Those fields can be made visible in views created from the tables.