In this chapter, we will add auditing of changes to data in our app.

Audit manual data changes

Add auditing of manual data changes to your app. To recap the steps in the video:

• Open the configuration form for the stream Contacts
• Tick Audit Manual Changes
• Add attributes to the stream:
  • UpdateAction
  • UpdatedByName
  • UpdatedTime - you must make this a Datetime field

Go into app mode, and make some changes to your contacts data.

Now create a new view to show all history:

• Create a new dashboard Contacts All History
• Drag the stream Contacts onto this dashboard, add all attributes to the view
• Hide the UID attribute
• Open the view configuration form
• Update the Name to Contacts All History
• Tick Include History Records
• Save your changes

In the new view, you should be able to see full details of the changes you just made to the contacts data.

Add a menu item to the Contacts app to provide a link from the Contacts dashboard to the Contacts Full History dashboard.

• When you have updated the view configuration to add the menu item, you will need to close and re-open the Contacts dashboard to see it

Audit analysis data changes

Add auditing of analysis data changes to your app. To recap the steps in the video:

• Open the configuration form for the stream Contacts
• Update stream attribute expressions:

  • UpdateAction: "IMPORT"

  • UpdatedByName: _user.name

  • UpdatedTime: now()

Go into app mode. Import the test file: Contact Import 3.xlsx

You should see a new contact imported. Apply an update to this contact.

Now open the full history for contacts. You should see two records for this contact - one for the import of the contact; one for the manual update you have just applied.