Product Logo

CNS Audit

An Audit Trail Plug-in for FileMaker Pro.

Functions

CNSAudit_RecordChange

NameCNSAudit_RecordChange
Description

This is the main logging function. This records all changes made to the fields in the database. The CNSAudit_RecordChange function is used within an Auto-Enter Text field named “CNS Audit Trigger”. The last parameter is optional for single-file database solutions, but in multi-file database solutions (such as solutions based on the Data Separation Model), you must provide the name of the table this CNS Audit Trigger field is in.

Return TypeText
FormatCNSAudit_RecordChange ( CNS Audit Timestamp ; CNS Audit Trigger ; Third Parameter )
Required Parameters
CNS Audit Timestamp

The CNS Audit Timestamp field from the table.

CNS Audit Trigger

The CNS Audit Trigger field from the table.

Optional Parameters
Third Parameter

In Multi-File and/or Data Separation Solutions, use this paremter to specify any Table Occurrence of this Base Table (FMP 7 through 10) or the Base Table Name (FMP 11).