FileMaker Audit Log
4.5 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
27 students enrolled

FileMaker Audit Log

Creating an Audit Log in FileMaker
4.5 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
27 students enrolled
Created by John Mark Osborne
Last updated 4/2019
English
English [Auto]
Price: $54.99
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 47 lectures 05:18:21
+ The Basics
10 lectures 01:19:49
Fields and Data
04:20
Calculated Field Tracking
13:26
Scripted Field Tracking
08:49
Technique Comparison
02:54
Script Triggers Revisited!
06:15
Single Field Tracking
11:18
Get(ModifiedFields)
07:41
Removing the Tracking Field
12:33
Hallelujah!
03:17
+ Audit Table
9 lectures 01:12:13
A New Table
09:11
New Window Solution
05:05
Which Trigger?
03:54
Push Method
09:39
Preserving the Original Data
07:01
Multiple Tables
12:25
Serial Number Differentiation
03:50
Variables to the Rescue!
14:18
+ Single Field Log
10 lectures 01:09:45
The Beginning
04:23
The Evolution
03:17
Fully Abstracted Log
06:03
Modifying the Log Field
06:10
Migrating to a Table
09:34
Analyzing the Formula
03:52
Finishing the Migration Script
09:53
Multiple Records & More
08:42
Highlighting the Migrated Rows
03:46
+ Plug-ins
8 lectures 46:08
Available Plug-Ins
03:28
Installing fmDataGuard
02:24
fmDataGuard Setup
04:39
Excluding Fields
08:56
PostDelete & PostView
05:00
Roll-Back
03:35
Roll-Back Multiple
05:10
+ Scripted Roll-Backs?!?
4 lectures 25:52
Roll-Back without a Plug-In
07:04
Transaction ID
05:50
Roll-Back a Transaction
07:46
Clean Up
05:12
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