FileMaker Platform 2020 Icon

Video Training Course for
the FileMaker® 19 Platform

Welcome to the most comprehensive FileMaker Video Course for the 19 release. This video course includes topics for beginner, intermediate, and advanced FileMaker users. You will learn to build relationships, write calculations, generate emails, design layouts, and improve the performance of your FileMaker custom app. The course is designed explicitly to NOT bore you to death, while teaching you valuable skills. (Enjoy our 60 hour video course!)

See complete list of topics covered during this training course

    Introductions - Overview

  • Welcome!!! Introduction Video
  • Course Organization
  • FMSP, Samples, and Work Files
  • The FileMaker Platform - Summary
  • Product Positioning
  • 90 Second Overview - FileMaker Cloud
  • What kind of Solutions can be made with FMSP?
  • Top 10 Need-To-Know Items in FileMaker 19
  • Upgrading 12, 13, 14, 15, 16, 17 or 18 Solutions to FileMaker 19
  • Requirements for Using FileMaker 19
  • FM Starting Point Walkthrough

  • Quick Overview of FMSP's use in this course
  • 3 New Data Entry UI Choices FMSP 7
  • FMSP Device Support & Layout Organization
  • FMSP Walkthrough - Intro
  • FMSP Settings & Prefs
  • FMSP Complexity Theory
  • Script Numbering and Organization
  • FMSP Account & Contacts Walkthrough
  • FMSP Invoice Walkthrough
  • FMSP Contacts Email Template Walkthrough
  • FMSP Sales Followups
  • FMSP Invoice - New Line Items - Advanced
  • FMSP Estimate to Invoice Transfer Button
  • FMSP Calculating Margin and Markup in Invoices
  • Google Maps Walkthrough in FMSP
  • Google Maps API Pricing Walkthrough
  • Tab Controls with Calculations
  • Super New Action Calendar
  • Calendar Under the Hood
  • Dashboard Charts Part 1
  • Dashboard Charts Part 2 - Scripting
  • Dashboard Charts Part 3 - Performance
  • Default Tax Rates in FileMaker Invoices - Auto Enter Values
  • Migrating Data to a New Copy of FMSP - Using the FDMT
  • Old FM Starting Point Videos

  • What's new in FMSP 5?
  • What's new in FMSP 6?
  • Startup Bug in FMSP - FM 16 Warning... 5.0.1 - 5.0.8a
  • What's New in FMSP 7?
  • Fundamentals & Basics

  • Opening Files - for New Users
  • What is a Database - Part 1
  • What is a Database - Part 2
  • Modes in FileMaker
  • Browse Mode, and the Delete menu item
  • Defining Fields in FileMaker & Jumping to Layout Mode
  • Saving Data
  • Converting from .fp7 to .fmp12 file formats
  • Converting from .fp5 to .fp7 file formats
  • How to make a Copy of a FM Database
  • What is a Relationship? (Very Basic Video)
  • Deployment or Sharing Options - Overview
  • Basics of Sharing a Database using FMS or Cloud 1
  • Basics of Sharing a Database using Cloud 2
  • Performing Finds & Sorts

  • Finding Records - Basics
  • Finding - Multiple Requests
  • Finding Ranges of Dates
  • Finds with Special Operators
  • Finds and Indexing and Performance, Stored Calcs
  • Finds Constrain and Extend
  • Sorting Records
  • Custom Sort Orders
  • Working on Fields & Layouts

  • Layouts - Available tools
  • Tour of the Inspector Pane - Right Side
  • Tour of the Left Pane - Field & Objects Panels
  • Left Pane - Add-On's Panles
  • Adding Number Fields and Formatting Currency
  • Added Calc fields and Hiding Objects
  • Creating a Survey, Tab Panels, & Value Lists
  • Value Lists - Under the hood
  • Hiding Objects & Conditional Formatting
  • Text fields with User Specified Formatting
  • Merge Fields
  • Stored Vs Unstored Calculations
  • 3 Types of Buttons and One Glyph - Icon
  • Button Bar as New Data Input Control Style
  • Inline Field Labels
  • Auto-Enter Options for Fields
  • Introduction to Single-User vs. Multi-User Databases
  • Record Locking Basics
  • Global Fields
  • Tooltips
  • Object Flags, or Badges
  • Object Alignment tools
  • Creating a new iOS Layout from Scratch - Stencils
  • Field Validation Options
  • Repeating Fields
  • Layout Badge Tooltips
  • Custom Currency in FMSP
  • Formatting Currency - When it goes into a Text Field
  • Remove Layout Parts, Without Removing Layout Objects
  • Button Bar as New Data Input control Style
  • Container Fields & Document Management

  • Container Field Introduction
  • Why Select Secure Storage?
  • Thumbnailing - Under the Hood
  • Interactive Containers
  • Fixing Interactive Containers - which are not Interactive
  • Containers in FMSP
  • When Container Storage goes Bad - Recovery Plan
  • Importing Multiple Images
  • Dynamic Window Control - Work Flow Control

  • Intro of Dynamic Window Control
  • Overview - Using Mulitple Windows on Pro to Display Information
  • Overview - Other Window Control Tools
  • Popovers & New Window Command (Deep Dive)
  • Tabs vs. Slide Controls (Deep Dive)
  • Hamburger Menus
  • Making a Drawer with a Slide Control (Awesome Hack)
  • Advanced Layout Techniques

  • Making Layouts load 200% faster - Performance
  • 200% faster Part 2 - Performance
  • 200% faster Part 3 - Performance
  • Grouping with Slide Panels to Hide Objects
  • Get Object Attribute for Hidden Objects
  • What is a Virtual List? *** Advanced ***
  • Virtual Lists - Hierarchical Portal
  • Vitual Lists - Pivot Table
  • FileMaker 14 SVG Icon Helper Tool
  • Web Viewers

  • Web Viewers - Overview
  • URL Protocols
  • Two Way Communication with Web Viewers
  • Calculations

  • Calculation Engine & Work Space
  • Intro to Date and Time Calculations
  • Parsing Text with Calcs - Part 1
  • Parsing Text with Calcs - Part 2
  • Detecting Window Mode and Filter Function
  • Date Calcs
  • Detecting Device & Platform Types
  • Get Functions Walkthrough - Part 1
  • Get Functions Walkthrough - Part 2
  • Get Functions Walkthrough - Part 3
  • Get Functions Walkthrough - Part 4
  • GetLayoutAttribute
  • GetContainerAttribute
  • Get(UUID) and Get(PersistentID)
  • List Function, Summary List, and GetValue
  • SortValues and UniqueValues
  • Get (ScriptName) - Understand Timing Issues
  • While Function with Nick Hunter
  • Writing Scripts

  • Scripting
  • Intro to Script Workspace
  • How Scripts can be activated
  • Understanding Context
  • My First Script - Set Field Command
  • Buttons run one Command
  • Navigation
  • IF...THEN...decisons
  • Variables vs. Globals
  • Performing Finds
  • Basic Error Capture
  • Calling Subscripts - Script Parameters
  • Advanced Script Parameters & Script Results
  • Looping Scripts
  • New Window - Script Step
  • Preserving User Context when running a Script
  • Script Debugger - Part 1
  • Script Debugger - Part 2
  • Data Viewer
  • UI Indicators for Database Activity
  • Perform Script on Server - PSOS
  • PSOS in FMSP
  • Testing for PSOS Availability
  • Case Statement
  • Deduplicating Records, the Plan
  • Replace Command - A Tiger Loose at the Zoo
  • Landmines in FileMaker
  • Error Trapping - Record Locking Advanced
  • Testing to See if a Field or variable contains ONLY a number / Trim Function
  • One Use Loop Technique
  • Go To Object
  • Go To Related Record - GTRR
  • File Control Script Steps
  • Distinct Command with Nick Hunter
  • EFDAPI - Execute Data API

    Script Triggers

  • Script Triggers - Intro
  • Script Triggers - Layout Specific
  • Script Triggers - Object Specific
  • Script Triggers - Field Validations
  • Script Triggers - More Layout Controls
  • Performance Optimization

  • Database Performance Optimization - Overview
  • Making Scalable Databases - Part 1
  • Making Scalable Databases - Part 2
  • Server Evidence - Slow Performance - Slow Scripts
  • Testing FileMaker Network Performance Part 1
  • Testing FileMaker Network Performance Part 2
  • FileMaker's 3 Engines with Nick Hunter
  • Performance Optimization - OLD

  • Performance Improvements with the 16 Platform
  • Performance Improvements with the 15 Platform
  • Performance Improvements with the 14 Platform
  • Database Performance Tuning with Nick Lightbody
  • Relationships

  • What is a Relationship?
  • Table Occurrences Basics
  • Relationship Graph & ERDs
  • What is a Portal... and a One to Many Relationship?
  • Multi-Predicate Relationships
  • Multi-Key Relationships
  • Cascading Adds
  • Cascading Deletes
  • Portal Dialog Options
  • Portal Dialog - Add-On Tables - Still Here?
  • Portal Summary Sum Totals
  • Filtering Portals - Radio Buttons
  • Filtering Portals - Dynamic Search - Script Trigger
  • Lookup Values
  • Relookup Command - Updating One Time Relationships
  • Anchor Buoy Design Methodology Part 1
  • Anchor Buoy Design Methodology Part 2
  • Master Detail Portals - New Feature
  • Master Detail Portals - Build one in 60 seconds
  • Many to Many Relationships
  • Preference Table in your Solution
  • Calculating and Primary Key with the current Year
  • Multiple Page Invoices - Portal Management - Part 1
  • Multiple Page Invoices - Portal Management - Part 2
  • Security

  • Security in FileMaker Overview
  • Accounts and Privileges
  • Extended Privledges...the Basics
  • Extended Privledges...Recent Changes
  • Encryption at Rest (EAR)
  • Point to Point Encryption - SSL Certificates
  • Security through Obscurity
  • Record Level Security
  • Layout and Process Access Controls - Restricting Staff
  • Hacking a FileMaker File... and Protecting It
  • CryptAuthCode Security Functions
  • Baby Administrators / Team Manager
  • Audit Trails

  • Audit Trails - Part 1 - Overview
  • New Audit Trails - Walkthrough
  • New Audit Trails - Under the Hood
  • New Audit Trails - Implementation
  • Old Video - Audit Trails - Logging Records viewed - HIPAA
  • Old Video - Audit Trails - Part 2 - Technical
  • Old Video - Audit Trails - Audits in FMSP - Part 1
  • Old Video - Audit Trails - Audits in FMSP - Part 2
  • Printing & Report Creation

  • What is a Report?
  • Structuring your data so it is reportable
  • Table View for Ad-Hoc Reporting
  • Layout Parts on List View - for Beginners
  • FileMaker Report Wizard - Very Cool
  • Printing & Reporting on Government Forms
  • Subsummaries in Detail
  • Built-in Charting Calvin & Richard LiveStream
  • State of Charting in FileMaker
  • Built-in Charting Overview
  • Google Charts
  • Fusion Charts
  • MultiPage Append to PDF
  • Custom Functions

  • Top 10 FileMaker Custom Functions (For Senior Developers)
  • Richard Carlton's Top 5 FileMaker Custom Functions
  • Parsing XML - Custom Function
  • Emailing, Imports and Exports - Basic Integration

  • Introduction to FileMaker Integration
  • Importing Data
  • New Import Dialog Introduced in FileMaker 18
  • Exporting Data
  • Scripting Import & Exports – Basics
  • Automating Imports or Exports - Robots and Servers
  • Send Email Script Step
  • Finding Your SMTP Settings
  • FMSP - Automating outbound emails
  • Spamming with FileMaker
  • Automating Emailing of Exports, Like a PDF
  • Multi-Table Imports - Complex Imports
  • Updating data in a FileMaker table from an Excel File
  • Barcodes - Basic Integration

  • Bar Code Deployment Planning & Options
  • Installing the Barcode Creator into FMSP
  • Scanning Items into Invoices with Barcodes
  • Under-the-hood with Scanner Barcodes In FMSP Part 1
  • Under-the-hood with Scanner Barcodes In FMSP Part 2
  • Under-the-hood with Scanner Barcodes In FMSP Part 3
  • USB Barcodes Gun We're Using
  • Setup Up Printer Labels & Users Scanning the Wrong Barcode
  • Viewer Questions & trouble shooting Barcodes
  • Infinite Peripherals Barcode Hardware for iPhone & iPad
  • Intermediate Integration

  • Intermediate Integration Overview
  • What is a FileMaker Robot?
  • Using 360Works Email Plugin to Send HTML Emails
  • Intro to Sending HTML emails and SMS messages
  • Building a Progress Bar in FileMaker
  • Validating Emails with a Service
  • Syncing to iPad or Syncing 2 databases
  • Clustering and Replication - MirrorSync 3
  • 360Works MirrorSync 4
  • LaTeX Demo with JRay (Overview)
  • Getting Driving Distance from Google
  • Getting your own Google API Key
  • Google Maps API Pricing Walkthrough
  • Cropping Images
  • Sending SMS with Twilio
  • US Postal Address Verification in FileMaker
  • Advanced Integration - PHP & REST

  • What is REST and Section Overview
  • What is OAuth?
  • Integration with PayPal - Short Overview
  • Integration with PayPal - Workflow Planning
  • Integration with PayPal - Setup Website
  • Integration with PayPal - Under-the-hood Walkthrough
  • Newbie Introduction to API Training #1
  • Newbie Introduction to API Training #2
  • Newbie Introduction to API Training #3
  • Newbie Introduction to API Training #4
  • Google Street Under the Hood - Nick Hunter
  • Custom Web Publishing #1 - Overview
  • Custom Web Publishing #2 - Technical Process Walkthrough
  • Custom Web Publishing #3 - Overview Moving from PHP 5 to PHP 7
  • Custom Web Publishing #4 - Airmoi Library for conversion to PHP 7
  • Custom Web Publishing #5 - Overview from PHP
  • Custom Web Publishing #6 - Technical Walkthrough of API Gateway
  • FileMaker's Certification Test

  • Introduction to the Certification Test
  • Previous Introduction to the Certification Test
  • Who takes the FileMaker Certification test?
  • If it's not Canon, it doesn't exist
  • What is FMI's Official Study List Part #1
  • What is FMI's Official Study List Part #2
  • Final Test Taking Tips
  • Data Migration

  • Modern Ways of Migrating Data & Patching FileMaker Files
  • Available Tools for Data - The DMT and SOUP Tool
  • Data Migration Tool (FDMT)- Intro
  • Data Migration Tool (FDMT)- Rules of the Road
  • FDMT - CLI Test Drive
  • FDMT - Free Wrapper App - Productive Computing
  • FDMT - Paid Wrapper App - 360Works Deploy
  • WebDirect

  • WebDirect - Android Client for FileMaker - Introduction
  • Overview WebDirect - Android Client for FileMaker - Part 1
  • Overview WebDirect - Android Client for FileMaker - Part 2
  • Overview WebDirect - Android Client for FileMaker - Part 3
  • Overview WebDirect - Android Client for FileMaker - Part 4
  • Creating PDF's and Emailing from WebDirect
  • Serialized FileMaker Code & Add-On Modules

  • Add-On Tables and the Future
  • Misc Topics

  • Duplicate Module in FMSP Part 1
  • Duplicate Module in FMSP Part 2
  • Duplicate Module in FMSP Part 3
  • Duplicate Module in FMSP Part 4
  • FileMaker Developer Subscription - FDS
  • Final Sign Off

  • Final Sign Off

Learn to customize FMSP, write scripts, and understand FileMaker… It's a lot of learning to do, but this video course will take you there! If you want to learn how to customize FM Starting point, this is the definitive video training course from the creators of FM Starting Point.

Course Goals

On top of the 60 hours of excellent FileMaker Pro Training videos, purchasers will receive tons of extra bonus items, including extra sample files, work files, and demo files! Purchasers are also welcome to attend special live training events to be held in the future!

Most FileMaker training doesn't cover important topics like email integration or barcode connectivity. This 60 hour course is divided up in 7-12 minute videos on separate topics, including: Working with 360Works Email Plug In, Security Concerns with FileMaker Server, Learning how to keep someone from hacking a FileMaker File, using the FileMaker Data Migration Tool, and Setting up your FileMaker server the proper way.

Richard Carlton, CEO of RC Consulting, Inc.

One of the main goals of the training is to not only teach you about FileMaker Pro but also teach you the skills to keep yourself out of trouble. I tried to keep the training entertaining, and NOT boring, but I also made sure to pass on some of the hard lessons I have learned over the years in my consulting business. I hope you can learn from the mistakes that I have made.