Creating a FileMaker Audit Log
Track Changes to Fields and Records in a Separate Table
This intermediary/advanced course for FileMaker 17 covers the creation of an Audit Log solution from scratch. Audit logs track changes to fields and records and store them in a separate table, providing a history. Every nut and bolt will be shown to foster a better learning experience. However, anyone with FileMaker 12 through 17 will be able to use this tutorial to improve their FileMaker skills. Topics include tables, fields, scripting, calculations, plug-ins, security and much more!
John Mark Osborne
Fields and Data
Housekeeping Fields
FREE PREVIEWCalculated Field Tracking
Scripted Field Tracking
Technique Comparison
Script Triggers Revisited!
Single Field Tracking
Get(ModifiedFields)
Removing the Tracking Field
Hallelujah!
Chapter 2 Quiz
Example File for Chapter 2
Sample Data
A New Table
Scripting Record Adds
FREE PREVIEWNew Window Solution
Which Trigger?
Push Method
Preserving the Original Data
Multiple Tables
Serial Number Differentiation
Variables to the Rescue!
Chapter 3 Quiz
Example File for Chapter 3
The Beginning
FREE PREVIEWThe Evolution
From Scratch
Fully Abstracted Log
Modifying the Log Field
Migrating to a Table
Analyzing the Formula
Finishing the Migration Script
Multiple Records & More
Highlighting the Migrated Rows
Chapter 4 Quiz
Example File for Chapter 4
Available Plug-Ins
FREE PREVIEWfmDataGuard Demo
Installing fmDataGuard
fmDataGuard Setup
PostEdit
Excluding Fields
PostDelete & PostView
Roll-back
Roll-back Multiple
Chapter 5 Quiz
Example File for Chapter 5
Roll-Back without a Plug-In
Transaction ID
Roll-Back a Transaction
Clean Up
Example File for Chapter 6