Video Training Course for FileMaker ® Pro 13
and FM Starting Point

Experience Richard's dynamic and exciting teaching format, while learning basic, intermediate, and advanced FileMaker development skills. A long time speaker at FileMaker's Developer Conference, with 26 years of FileMaker experience, Richard will teach you all the ins and outs of building FileMaker Solutions, including how to customize your own FREE copy of FM Starting Point! The course is 25 hours of video content! Take advantage of our limited time offer: One time purchase of $39.99.

See complete list of topics covered during this training course

    Introductions - Overview

  • FMP Training with Emphasis on FM Starting Point
  • The FileMaker Platform - Summary
  • What kind of Solutions can be made with FMSP?
  • Installing FileMaker and FMSP
  • Product Positioning
  • Basics of Sharing a Database
  • FM Pro Vs. Pro Advanced
  • Concurrency Licenses for access to FMS
  • FM Starting Point Walkthrough

  • FMSP Walkthru - Intro
  • Device Support & Layout Organization
  • Script Numbering and Organization
  • FMSP Complexity Theory
  • Account & Contacts Walkthrough
  • Invoice Walkthrough
  • FMSP Contacts Email Template Walk Through
  • FMSP Sales Followups
  • FMSP Invoice - New Line Items – Advanced
  • Fundamentals & Basics

  • What is a Database - Part 1
  • What is a Database - Part 2
  • Modes in FileMaker
  • Browse Mode, and the Delete menu item
  • Saving Data
  • Converting from .fp7 to .fmp12 file formats
  • Converting from .fp5 to .fp7 file formats
  • Performing Finds & Sorts

  • Finding Records - Basics
  • Finding - Multiple Requests
  • Finding Ranges of Dates
  • Finds with Special Operators
  • Finds and Indexing and Performance
  • Finds Constrain and Extend
  • Sorting Records
  • Emailing, Imports and Exports

  • Sharing Data Intro
  • Importing Data
  • Exporting Data
  • Scripting Import & Exports – Basics
  • Automating Imports or Exports - Robots and Servers
  • Send Email Script Step
  • Finding Your SMTP Settings
  • Automating outbound emails
  • Spamming with FileMaker
  • Automating Emailing of Exports, Like a PDF
  • Scripting FileMaker to Delete a File
  • Multi-Table Imports... Complex Imports
  • Upgrading Copies of FMSP
  • Using 360Works Email Plug in to Send HTML Emails
  • Integration

  • Bar Code Deployment Planning & Options
  • Installing the Barcode Generator 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
  • Getting FileMaker Server to Generate PDFs
  • What is a FileMaker Robot?
  • Intro to Sending HTML emails and SMS messages
  • Building a Progress Bar in FileMaker
  • Validating Emails with a Service
  • Printing & Report Creation

  • Printing and PDF Generation
  • 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
  • Advanced Layout Techniques

  • Making Layouts load 200% faster in FM 13
  • 200% faster Part 2
  • 200% faster Part 3
  • Grouping with Slide Panels to Hide Objects
  • Get Object Attribute for Hidden Objects
  • Hiding Stuff off the Right Side of the Screen
  • Script Triggers - Intro
  • Script Triggers - Layout Specific
  • Script Triggers - Object Specific
  • Script Triggers - Field Validations
  • Script Triggers - More Layouts controls
  • What is a Virtual List? *** Advanced ***
  • Hierarchical Portal for Navigation *** Advanced ***
  • Go to Related Record - GTRR
  • FileMaker Server

  • Deployment & Sharing
  • FMS Admin Walkthrough
  • Scheduling Backups
  • Progressive Backups
  • Restoring from a Crash

    Working on Fields & Layouts

  • Layouts - Available tools
  • Tour of the Inspector
  • Intro to Adding Fields to Database
  • Added Calc fields and Hiding Objects
  • Creating a Survey & Value Lists
  • Value Lists- Under the hood
  • Hiding Objects & Conditional Formatting
  • Text fields & User Formatting Issues
  • Merge Fields
  • Tabs vs. Slide Controls
  • Popovers and New Window Command
  • Auto Enter Options for Fields
  • Container Field Introduction
  • Advanced Container Field Kung-Fu
  • Containers in FMSP
  • Introduction to Single-User vs. Multi-User Databases
  • Global Fields
  • Tooltips
  • Object Flags, or Badges
  • Object Alignment tools
  • Creating a Basic New Layout from Scratch
  • Field Validation Options
  • Repeating Fields
  • Writing Scripts

  • Scripting
  • Set fields vs. Copy, Paste
  • Set field & Context
  • 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
  • Script Debugger - Part 1
  • Script Debugger - Part 2
  • Data Viewer
  • HiJacking Containers in FM Starting Point
  • Database Performance Optimization Overview
  • Making Scalable Database
  • Perform Script on Server - PSOS
  • PSOS in FMSP
  • Testing for PSOS Availability
  • SASE
  • Case Statement
  • Deduplicating Records, the Plan
  • Calculations
  • Calculation Engine
  • Parsing Text with Calcs - Part 1
  • Parsing Text with Calcs - Part 2
  • Detecting Device & Platform Types
  • Detecting Window Mode and Filter Function
  • Date Calcs
  • Get Functions Walkthrough - Part 1
  • Get Functions Walkthrough - Part 2
  • Get Functions Walkthrough - Part 3
  • GetLayoutAttribute
  • GetContainerAttribute
  • 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 Summary Sum Totals
  • Filtering Portals - Radio Buttons
  • Filtering Portals - Dynamic Search - Script Trigger
  • Looked Up Values
  • Anchor Buoy Design Methodology Part 1
  • Anchor Buoy Design Methodology Part 2
  • Preference Table in your Solution
  • Security

  • Security in FileMaker Overview
  • Accounts and Privileges
  • Extended Privledges...the Basics
  • Encryption at Rest (EAR)
  • Point to Point Encryption
  • Audit Trails - Part 1 - Overview
  • Audit Trails Part 2 - Technical
  • Audit Trails - Audits in FMSP Part 1
  • Audit Trails - Audits in FMSP Part 2
  • Security through Obscurity
  • Restricting Access to Layout with Get(LayoutAccess)
  • Restricting Access to Layout with Extended Privledges

Learn to customize FMSP, write scripts, and understand FileMaker… There is a lot to learn, 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.

In addition to the 25 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 announced!

Most FileMaker training doesn't cover important topics like email integration or barcode connectivity. This 25 hours course is divided into 7-12 minute videos on separate topics, including subjects often skipped over in other courses, including Working with 360Works Email Plug In, Security Concerns with FileMaker Server, How to Keep Someone from Hacking a FileMaker File, and The Proper Way to Set Up Your FileMaker Server.

One of the main goals of the training is not only to teach you about FileMaker Pro but also to teach you the skills to keep yourself out of trouble. I made sure to pass on some of the hard lessons I have learned over the years in my consulting business. You can should learn from the mistake that I have made.
- Richard Carlton, CEO

© Richard Carlton Consulting - Nevada, LLC. All rights reserved.

FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. FileMaker Go and the file folder logo are trademarks of FileMaker, Inc. Richard Carlton Consulting - Nevada, LLC is an independent entity and this training course has not been approved by FileMaker, Inc.

Apple, the Apple logo, iPad, iPhone, iPod, iPod touch, iTunes, the iTunes logo, Mac, and QuickTime are trademarks of Apple Inc., registered in the U.S. and other countries. Multi-Touch is a trademark of Apple Inc. App Store is a service mark of Apple Inc. IOS is a trademark or registered trademark of Cisco in the U.S. and other countries and is used under license.

Contact Us:

Email Us Website