Learning FileMaker Pro 15 – Volume 2

Course Curriculum

Chapter 1: 0900 – Writing Scripts

Lecture 1: 0901 – Scripting

Lecture 2: 0902 – Intro to Script Workspace

Lecture 3: 0903 – Workspace Keyboard Shortcuts

Lecture 4: 0904 – Set fields vs. Copy, Paste

Lecture 5: 0905 – Set fields & Context

Lecture 6: 0906 – Buttons run one Command

Lecture 7: 0907 – Navigation

Lecture 8: 0908 – IF…THEN…decisions

Lecture 9: 0909 – Variables vs. Globals

Lecture 10: 0910 – Performing Finds

Lecture 11: 0911 – Basic Error Capture

Lecture 12: 0912 – Calling Subscripts – Script Parameters

Lecture 13: 0913 – Advanced Script Parameters & Script Results

Lecture 14: 0914 – Looping Scripts

Lecture 15: 0917 – Preserving User Context when running a Script

Lecture 16: 0920a – Script Debugger – Part 1

Lecture 17: 0920b – Script Debugger – Part 1

Lecture 18: 0921 – Script Debugger – Part 2

Lecture 19: 0924 – Data Viewer

Lecture 20: 0930 – HiJacking Containers in FM Starting Point

Lecture 21: 0931 – When Container Storage goes Bad… Recovery Plan…

Lecture 22: 0932 – UI Indicators for Database Activity

Lecture 23: 0940- Database Performance Optimization Overview

Lecture 24: 0941- Making Scalable Databases

Lecture 25: 0943a – Perform Script on Server – PSOS

Lecture 26: 0943b – Perform Script on Server – PSOS

Lecture 27: 0945 – PSOS in FMSP

Lecture 28: 0946 – Testing for PSOS Availability

Lecture 29: 0947 – SASE

Lecture 30: 0948 – Case Statement

Lecture 31: 0950 – Deduplicating Records, the Plan

Lecture 32: 0951 – Replace Command – A Tiger Loose at the Zoo

Lecture 33: 0952 – Relookup Command – Updating One Time Relationships

Lecture 34: 0953 – Landmines in FileMaker

Lecture 35: 0955 – Testing to Make Sure Your Script has Access to a Record

Lecture 36: 0957 – Testing to See if a Field or variable contains ONLY a number / Trim Funct

Lecture 37: 0965 – One Use Loop Technique

Chapter 2: 1000 – Calculations

Lecture 1: 1001 – Calculation Engine & New Work Space

Lecture 2: 1002 – Calculation Engine & New Work Space Part 2

Lecture 3: 1010 – Parsing Text with Calcs – Part 1

Lecture 4: 1011 – Parsing Text with Calcs – Part 2

Lecture 5: 1012 – Detecting Window Mode and Filter Function

Lecture 6: 1013 – Date Calcs

Lecture 7: 1014 – Detecting Device & Platform Types

Lecture 8: 1020 – Get Functions Walkthrough – Part 1

Lecture 9: 1021 – Get Functions Walkthrough – Part 2

Lecture 10: 1022 – Get Functions Walkthrough – Part 3

Lecture 11: 1023 – Get Functions Walkthrough – Part 4

Lecture 12: 1024 – GetLayoutAttribute

Lecture 13: 1025 – GetContainerAttribute

Lecture 14: 1026 – Get(UUID) and Get(PersistentID)

Lecture 15: 1040 – List Function, Summary List, and GetValue

Lecture 16: 1041 – Get (ScriptName) – Understand Timing Issues…

Lecture 17: 1045 – Parsing XML

Chapter 3: 1100 – Relationships

Lecture 1: 1101 – What is a Relationship?

Lecture 2: 1102 – Table Occurrences Basics

Lecture 3: 1103 – Relationship Graph & ERDs

Lecture 4: 1104 – What is a Portal… and a One to Many Relationship?

Lecture 5: 1105 – Multi-Predicate Relationships

Lecture 6: 1106 – Multi-Key Relationships

Lecture 7: 1107 – Cascading Adds

Lecture 8: 1108 – Cascading Deletes

Lecture 9: 1111 – Portal Dialog Options

Lecture 10: 1112 – Portal Summary Sum Totals

Lecture 11: 1114 – Filtering Portals – Radio Buttons

Lecture 12: 1115 – Filtering Portals – Dynamic Search – Script Trigger

Lecture 13: 1120 – Lookup Values

Lecture 14: 1130 – Anchor Buoy Design Methodology Part 1

Lecture 15: 1131 – Anchor Buoy Design Methodology Part 2

Lecture 16: 1132 – Many to Many Relationships

Lecture 17: 1135 – Preference Table in your Solution

Chapter 4: 1200 – Security

Lecture 1: 1201 – Security in FileMaker Overview

Lecture 2: 1202 – Accounts and Privileges

Lecture 3: 1203 – Extended Privledges…the Basics

Lecture 4: 1204 – Encryption at Rest (EAR)

Lecture 5: 1205a – Point to Point Encryption – SSL Certificates

Lecture 6: 1205b – Point to Point Encryption – SSL Certificates

Lecture 7: 1205c – Point to Point Encryption – SSL Certificates

Lecture 8: 1207 – Audit Trails – Part 1 – Overview

Lecture 9: 1208 – Audit Trails – Part 2 – Technical

Lecture 10: 1209 – Audit Trails – Audits in FMSP Part 1

Lecture 11: 1210 – Audit Trails – Audits in FMSP Part 2

Lecture 12: 1211 – Audit Trails – Logging Records viewed – HIPAA

Lecture 13: 1213 – Security through Obscurity

Lecture 14: 1214 – Record Level Security

Lecture 15: 1215 – Layout and Process Access Controls – Restricting Staff

Lecture 16: 1216 – Hacking a FileMaker File… and Protecting It

Chapter 5: 1300 – FileMaker Server

Lecture 1: 1301 – Deployment & Sharing

Lecture 2: 1302 – FMS Admin Walkthrough

Lecture 3: 1303 – Scheduling Backups

Lecture 4: 1304 – Progressive Backups

Lecture 5: 1305 – Restoring from a Crash

Lecture 6: 1306a – Server Performance Improvements 14 – Nick Lightbody

Lecture 7: 1306b – Server Performance Improvements 14 – Nick Lightbody

Lecture 8: 1306c – Server Performance Improvements 14 – Nick Lightbody