FileMaker Audit Log

Name: FileMaker Audit Log
Rating: 4.5 (15 reviews)

Creating an Audit Log in FileMaker

Created byJohn Mark Osborne

Last updated 4/2019

English

What you'll learn

How to create an audit log in FileMaker
Scripting
Calculations
Set Field: Push and Pull
Auto-Enter Calculations
Housekeeping fields
Calculated field tracking
Scripted field tracking
New window techniques
Set Variable
Support for multiple audited tables
Abstraction
fmDataGuard plug-in
Roll-Back
Roll-Forward
Migrating data from a single field to a table

Course content

7 sections • 47 lectures • 5h 18m total length

About John Mark Osborne3:41
Learn from John Mark Osborne, a FileMaker Pro expert certified across versions 7 to 17, who shares decades of scripting, calculations, relational design, and native feature knowledge.
About this Tutorial4:26
What is an Audit Log?2:27
What is Covered?4:12
The Example File1:35

Fields and Data4:20
Housekeeping Fields9:16
Calculated Field Tracking13:26
Scripted Field Tracking8:49
Technique Comparison2:54
Script Triggers Revisited!6:15
Learn to implement adaptive set field by name triggers in FileMaker to track fields with one script, reducing clutter while ensuring accurate, fully qualified field references.
Single Field Tracking11:18
Get(ModifiedFields)7:41
Removing the Tracking Field12:33
Hallelujah!3:17

The Beginning4:23
Demonstrates a FileMaker audit log that tracks field modifications, showing how current date, time, and a case statement capture old and new values via log and match fields.
The Evolution3:17
From Scratch14:05
Fully Abstracted Log6:03
Modifying the Log Field6:10
Explore strategies to prevent editing the log field in FileMaker by switching to view only, using privilege sets, or creating a calculation field to display the log without allowing changes.
Migrating to a Table9:34
Analyzing the Formula3:52
Finishing the Migration Script9:53
Multiple Records & More8:42
Highlighting the Migrated Rows3:46

Available Plug-Ins3:28
Use a plug-in to create an audit log in FileMaker, extending capabilities via an API to track edits, deletes, imports, and other events.
Installing fmDataGuard2:24
Install fmDataGuard as an application-level plugin in FileMaker by quitting the app, placing the plugin in the extensions folder, and enabling it in preferences; launch and verify.
fmDataGuard Setup4:39
PostEdit12:56
Excluding Fields8:56
PostDelete & PostView5:00
Roll-Back3:35
Roll-Back Multiple5:10

Requirements

Students should be at or close to an intermediate level of FileMaker programming including familiarity with layout mode, scripting, relational design and calculations
The course is taught using FileMaker 17 but can be taken by any with FileMaker 13 or later

Description

Audit logs track field and record modifications so changes can be rolled-back or forward. In FileMaker, changes can be tracked many ways, each with it's own advantages and disadvantages. We'll walk you through every technique out there in the FileMaker world and talk about when to use each solution. By the time you're done, you'll have learned tons about scripting, calculations and relational design. Before starting this course, make sure you are at an intermediate programming level for FileMaker which includes familiarity with scripting, calculations and relational design.

Who this course is for:

Students will learn how to design a complete solution from the ground up including layout design, scripting, calculations and relational design
This is an intermediate/advanced course with some beginner and some expert material

FileMaker Audit Log

What you'll learn

Explore related topics

Course content

About this Tutorial5 lectures • 16min

The Basics10 lectures • 1hr 20min

Audit Table9 lectures • 1hr 12min

Single Field Log10 lectures • 1hr 10min

Plug-ins8 lectures • 46min

Scripted Roll-Backs?!?4 lectures • 26min

More from John Mark Osborne1 lecture • 8min

Requirements

Description

Who this course is for: