The Complete Learning FileMaker®Subscription
Annual Software and Training Bundle

This annual subscription is the complete package for building FileMaker applications. With this bundle, you will receive a FULL copy of FileMaker Pro Advanced, over 70 hours of video training, PLUS exclusive Video Content! That's over a $500 value, all for the introductory price of $299! (annual renewal of $249)

This Bundle includes:
  • One Copy of FileMaker Pro Advanced 18
  • FM Starting Point Enhanced
  • Calendar Add-On Kit ($49 value)
  • 60 hour FileMaker 18 Video Course ($79 value)
  • 10 hour FileMaker Go 18 Video Course ($39 value)
  • 2-3 hour FileMaker UI Design Video Course (Bundle Exclusive, not available elsewhere)
  • 6 hour FileMaker for Startups and Entrepreneurs Video Course ($99.99 value)

Detailed list of courses included in kit

FileMaker Pro Training

    Introductions - Overview

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

  • Quick Overview of FMSP's use in this course
  • What's new in FMSP 7?
  • 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
  • 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
  • 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)
  • Basics of Sharing a Database
  • 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 Inspector Pane - Left Side
  • 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
  • Tabs vs. Slide Controls
  • Popovers and New Window Command
  • Auto-Enter Options for Fields
  • Introduction to Single-User vs. Multi-User Databases
  • (New) - 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
  • Hamburger Menus
  • 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
  • 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 ***
  • Hierarchical Portal for Navigation *** Advanced ***
  • FileMaker 14 SVG Icon Helper Tool
  • 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
  • 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
  • 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
  • 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
  • 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 - Part21
  • 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
  • Audit Trails - Part 1 - Overview
  • Audit Trails Part 2 - Technical
  • Audit Trails - Audits in FMSP Part 1
  • Audit Trails - Audits in FMSP Part 2
  • Audit Trails - Logging Records viewed - HIPAA
  • 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
  • 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
  • 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
  • FileMaker Server (On Premise Server)

  • Deployment & Sharing - Terminology
  • Deployment & Sharing - Intro
  • Controlling FileMaker Server
  • FMS Install with William
  • Walkthrough of FMS Admin Console (Web Interface)
  • Finding the Server Logs
  • Scheduling Backups - The Basics
  • Hard Linking
  • Progressive Backups
  • FMS - Command Line Interface (CLI)
  • FMS - SSL Install
  • FMS - Admin API
  • PLL / Startup Restoration Overview
  • Turning On/OFF PLL / Startup Restoration
  • Restoring from a Crash with Startup Restoration
  • Restoring from a Crash w/o Startup Restoration
  • PCI FMS Admin Tool
  • Claus Lavendt Missing Admin Tool
  • FMS - Offsite Backups
  • Disconnecting Idle Users
  • SASE
  • Remote Monitoring - Zabbix
  • FileMaker Cloud for AWS

  • 90 Second Overview - FileMaker Cloud
  • Detailed Comparison with Regular FileMaker Server
  • Is FileMaker Cloud Right for you?
  • Brain Dump for Experienced FileMaker Developers
  • How to Buy FileMaker Cloud - Direct from AWS - New Users
  • How to Buy FileMaker Cloud - BYOL - Annual Licenses
  • Uploading files to FileMaker Cloud
  • Picking the right size of Amazon server
  • Understanding Amazon's Total Cost
  • How to Save 50% to 75% on Amazon Instance
  • FMI Hourly Costs with AWS - Switch to Annual
  • Restoring from a Backup (New Process)
  • Robot DB & Notifications
  • Automated Maintenance
  • EBS & Backups
  • Supersize my Server!
  • Detecting When a File is running on FileMaker Cloud
  • Instance Refresh & Emergency Procedures Part 1
  • Offboarding FileMkaer Cloud
  • Intro T2 Burstable Instances, Performance, CPU Credits
  • CPU Credit and Baselines for T2.Small, T2.Medium, and T2.Large
  • Standard Usage Scenario
  • Testing T2.Small with 5 users
  • 5 WebDirect users at once with T2.Small
  • Cloud Melt Summary
  • FileMaker Cloud 2

    Emailing, Imports and Exports - Basic Integration

  • Introduction to FileMaker Integration
  • 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
  • Multi-Table Imports... Complex Imports
  • Updating data in a FileMaker table from an Excel File
  • Intermediate Integration

  • Intermediate Integration Overview
  • 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
  • Getting FileMaker Server to Generate PDFs (PSOC)/li>
  • 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
  • Getting Driving Distance from Google
  • Getting your own Google API Key
  • URL Protocols
  • URL Protocol Malfunctions
  • Sending SMS with Twilio
  • Syncing to iPad or Syncing 2 databases
  • Clustering and Replication - MirrorSync 3
  • 360Works MirrorSync 4
  • US Postal Address Verification in FileMaker
  • LaTeX Demo with JRay (Overview)
  • 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
  • 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

  • Data Migration Intro
  • Add-On Tables and the Future
  • Data Migration Tool - Intro
  • Data Migration Tool - 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
  • 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

FileMaker Course for Startups and Entrepreneurs

    Introductions - Overview

  • Introduction
  • The Elevator Pitch
  • FileMaker's Extended Elevator Pitch Part 1
  • FileMaker's Extended Elevator Pitch Part 2
  • FileMaker's Extended Elevator Pitch Part 3
  • Planning

  • So you have an idea for an App.
  • Picking the Technology, and Deployment to your Users
  • What is FileMaker? How do you define what it is?
  • Free Pre-Canned Solutions...FM Starting Point
  • Deployment: WebDirect versus FileMaker Go
  • FileMaker Apps cannot be sold on Apple or Google App Stores
  • Planning your App...Sketch Pictures
  • UI vs UX
  • Deployment: FileMaker Licensing Costs and PHP vs. WebDirect & Scalability
  • Misc Marketing

  • Selling on a Subscription
  • Outside Help & Contractors
  • Hiring the Right Consultant/Developer
  • Off Shoring your Dev Work

    Budgeting

  • Estimating Development Costs
  • Fixed Cost Projects, and Agile Development
  • Bugs
  • Commercializing an app your already have.
  • Budgeting - Getting a Grip on a Startup Killer
  • How we produce Videos
  • Mechanics of producing Videos
  • Interviews with Successful Vertical Market App Developers

  • Interview with VetFM - Part 1
  • Interview with VetFM - Part 2
  • Interview with VetFM - Part 3
  • Interview with VetFM - Part 4
  • Interview with Bumperman Franchise - Part 1
  • Interview with Bumperman Franchise - Part 1
  • Conclusion & Bonus Videos

  • Conclusion

FileMaker iOS App SDK

    Introductions - Overview

  • Course introduction
  • Terminology...What is FIAS?
  • FIAS Behaviors
  • How Much is FIAS?
  • Who needs FIAS?
  • Preppig and Planning

  • What is your Strategery? Part 1
  • What is your Strategery? Part 2
  • FileMaker's Developer Program
  • Apple iOS Registered Developer
  • Xcode & TestFlight

  • Install Xcode... basics
  • Itunes Connect Versus Member Center
  • Certificates - Development & Distribution
  • Provisioning Profile..FYI
  • Registering iOS devices for testing
  • Apple's "App Service"
  • Testing with TestFlight... Overview

    Cutting our App (Compile in XCode)

  • Quick Overview of App Build Process
  • Building Your First App.... Step by Step - Part 1
  • Building Your First App.... Step by Step - Part 2
  • Compiling Strategies... thing you need to know...
  • App Id & Available Apple Services
  • Creating Images
  • Apple's App Submission process

  • Delivering Your App to Apple
  • Registering an App with Apple - iTunes Connect
  • Apple's App Submission Guidelines
  • If your are Rejected... what next?

UI Design Course

  • Course introduction
  • General Design Concepts - Sentence
  • General Design Concepts - Expression and Function
  • General Design Concepts - Grocery Store
  • General Design Concepts - All Together
  • Primary Navigation Design Patterns
  • Visual Hierarchy Design Patterns Part 1
  • Visual Hierarchy Design Patterns Part 2
  • Introduction to Column Construction Technique
  • Columns, Grid and Alignment Design Pattern
  • From Desktop to Touch
  • Themes and Style - Sharing - Review Video
  • Combining Views... Slide Control Technique
  • iPad Landscape and Portrait Mode
  • Calendar Dtae Style
  • Rounded Corners for Apple UI

FileMaker Go 13

    Introduction

  • "What is FileMaker Go?" - Training Series Overview
  • "FM Go or Code Your Own App?" - Discussion of App Creation Process
  • Installation & Overview

  • "Installation & Requirements" - Basic Video Covering OS & Hardware
  • "Free FileMaker Resources" - Additional Free FileMaker Resources
  • "Database Install Part 1" - Database Install using iTunes/DropBox
  • "Database Install Part 2" - Database Install using Email
  • "Database Install Part 3" - Database Install using Webpage
  • "7 Min Brain Dump" - FM Go 13 General Overview
  • "Brain Dump: Changes" - New Features in FM Go 13
  • "Concurrency Licenses" - License Requirements with Server
  • Navigation

  • "iPad Navigation" - Navigate FM Go 13 on the iPad
  • "iPhone Navigation" - Navigate FM Go 13 on the iPhone
  • "Record Locking" - Add/Delete Records and Record Lock
  • "Data in Tables" - Best View Options for Your Solutions
  • "Finds, Sorts, Portals" - Largely the Same as in Pro
  • "Slide Controls" - Navigate Through Records
  • "Tab Controls" - New Gesture To Capture
  • Layouts for FileMaker Go

  • "Tuning Layouts" - Usability, Workflow, and Testing
  • "Tuning Layouts for Touch" - Optimizing Fields & Buttons
  • "Directed Workflow" - Control UI Flow
  • "Workflow Demos" - Purpose Built iOS Layouts
  • "Detect Device Type" - Using Scripts for Type
  • "Detect Network" - Using Scripts for Network
  • "Locking Zoom" - Prevent Layout Accidents
  • "Orientation" - Change Layouts
  • "Create New Layout" - Making Go Layouts in Pro
  • "Optimize Layouts/CSS Part 1" - Updating Layouts for 13
  • "Optimize Layouts/CSS Part 2" - Custom Themes/Shared Styles
  • "Optimize Layouts/CSS Part 3" - Shared Styles Tips
  • "Animation States" - Script Nav Between Panels
  • "Input Methods" - Containers & Field Input
  • "Custom Keyboards" - For Inputting Data
  • "Bar Code Camera" - How To Capture Bar Codes
  • "Camera & Signatures" - Harness Container Fields
  • "Data & Fonts" - iOS Restrictions

    Managing Digital Media

  • "Digital Media Support" - FileMaker Container Overview
  • "Container Fields" - Container Interaction Differences
  • "Remote Container" - Using Remote Containers
  • "Web Viewer - Remote" - Accessing Web with Layouts
  • "Web Viewer - Idiosyncrasies" - Limited Interaction
  • "Web Viewer - Benefits" - Streaming Video
  • "GoDraw" - Finger Scribbling in Go
  • Scripting & Syncing

  • "Unsupported Scripts" - Error 3 & Error 4
  • "GPS Location Functions" - Location & LocationValues
  • "URL Protocol" - How to Implement the URL Protocol
  • "Activating SASE from Go" - FileMaker Server Runs Scripts
  • Printing & Exporting

  • "Printing - Part 1" - Printing Using Printopia
  • "Printing - Part 2" - Extra Features in Printopia
  • "Emailing PDFs" - How to Create and Send PDFs
  • "Exporting & Emailing" - Send Your Records to Others
  • Sleep & Restore

  • "Overview" - Sleep & Restore Summary
  • "Technical - Part 1" - A Look at the Origin
  • "Technical - Part 2" - Benefits of Sleep/Restore
  • "Technical - Part 3" - When Should You Use Sleep/Restore
  • "Hands on Demo" - Real Case Demo of Sleep/Restore
  • Deployment Strategies

  • "Deployment Strategies" - Shared Versus Local
  • "Beaming Solutions" - Base64 Encode
  • "App Store Guidelines" - Develop Outside of FM Go
  • "Syncing - 3rd Party Tools" - A Look at GoZync
  • "Syncing - Import Command" - Local Data to Hosted Data
  • Conclusion

  • "Conclusion & Resources" - Continue Your FileMaker Training
  • "About the Author" - Richard Carlton & RCC

With this bundle you have access to each update FileMaker makes to their software, including new versions of FileMaker Pro. You will also get any updated courses or even new courses automatically as long as your subscription is active.