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, over 50 hours of video training, PLUS exclusive Video Content! Thats an over $500 value, all for the introductory price of $249! (annual renewal of $199)

This Bundle includes:
  • 1 Copy of FileMaker Pro 16
  • 1 Copy of FM Starting Point Enhanced
  • 50 hour FileMaker Pro 16 Video Course ($69 value)
  • 9 hour FileMaker Go 16 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)
  • 5 hour Filemaker iOS App SDK Video Course ($70.00 value)

Detailed list of courses included in kit

FileMaker Pro Training

    Introductions - Overview

  • FMP Training with Emphasis on FM Starting Point
  • The FileMaker Platform - Summary
  • What kind of Solutions can be made with FMSP?
  • Product Positioning
  • Installing FileMaker and Downgrades
  • Buying / Licensing FileMaker - FLT
  • Pro for FLT & Concurrency Connections
  • New Features Brain Dump for New and Intermediate Users
  • The New Windows Interface!!!
  • Basics of Sharing a Database
  • Upgrading 12, 13, 14, or 15 Solutions to FM16
  • FM Pro Vs. Pro Advanced
  • FM Starting Point Walkthrough

  • FMSP Walkthrough - Intro
  • FMSP Device Support & Layout Organization
  • Script Numbering and Organization
  • FMSP Complexity Theory
  • What's New in FMSP 5?
  • FMSP Accounts & Contacts Walkthrough
  • FMSP Invoices 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
  • FMSP Unlimited Related Digital Document Upgrade
  • Calendar Under the Hood - Part 1
  • Calendar Under the Hood - Part 2
  • Tab Controls with Calculations1
  • Dashboard Charts Part 1
  • Dashboard Charts Part 2 - Scripting
  • Dashboard Charts Part 3 - Performance
  • Managing Primary Keys
  • 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
  • How to make a Copy of a FM 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
  • Intro to Adding Fields to Database (Text and Number)
  • Added Calc fields and Hiding Objects
  • Creating a Survey & Tab Panels & Value Lists
  • Value Lists - Under the hood
  • Hiding Objects & Conditional Formatting
  • Text fields & 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
  • Layout Object Windows (LOW) aka Layout Object Tree
  • Tabs vs. Slide Controls
  • Popovers and New Window Command
  • Auto-Enter Options for Fields
  • Introduction to Single-User vs. Multi-User Databases
  • 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
  • Advanced Container Field Kung-Fu
  • Interactive Containers in FileMaker
  • Containers in FMSP
  • HiJacking Containers in FM Starting Point
  • When Container Storage goes Bad...Recovery Plan...
  • Advanced Layout Techniques

  • Making Layouts load 200% faster in FM 16 - Performance
  • 200% faster Part 2 - Performance
  • 200% faster Part 3 - Performance
  • Grouping with Slide Panels to Hide Objects
  • Get Object Attribute for Hidden Objects
  • 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 14 SVG Icon Helper Tool
  • 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, migrating / updating to a new release
  • Using 360Works Email Plug in to Send HTML Emails
  • 360Works' CloudMail Inside of FMSP...Overview
  • 360Works' CloudMail Install
  • Integration

  • Barcode 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 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?
  • Intro to Sending HTML emails and SMS messages
  • Building a Progress Bar in FileMaker
  • Validating Emails with a Service
  • Getting Driving Distance from Google
  • Dialing VOIP Phone with SIP & X-Lite
  • Syncing to iPad or Syncing 2 databases - MirrorSync 2
  • Clustering and Replication - MirrorSync 3
  • US Postal Address Verification in FileMaker

    Writing Scripts

  • Scripting
  • Intro to Script Workspace
  • Workspace Keyboard Shortcuts
  • 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
  • Preserving User Context when running a Script
  • New Window - Script Step
  • Script Debugger - Part 1
  • Script Debugger - Part 2
  • Data Viewer
  • UI Indicators for Database Activity
  • Database Performance Optimization Overview
  • Making Scalable Databases
  • Server Evidence - Slow Performance - Slow Scripts
  • Perform Script on Server - PSOS
  • PSOS in FMSP
  • Testing for PSOS Availability
  • SASE
  • Case Statement
  • Deduplicating Records, the Plan
  • Replace Command - A Tiger Loose at the Zoo
  • Landmines in FileMaker
  • Testing to see if a Field or variable contains ONLY a number / Trim Function
  • One Use Loop Technique
  • Calculations

  • Calculation Engine & New Work Space
  • Calculation Engine & New Work Space Part 2
  • 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
  • SorttValues and UniqueValues
  • Get (ScriptName) - Understand Timing Issues...
  • 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
  • Lookup Values
  • Relookup Command - Updating One Time Relationships
  • Anchor Buoy Design Methodology Part 1
  • Anchor Buoy Design Methodology Part 2
  • 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
  • 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
  • FileMaker Server

  • Deployment & Sharing
  • FMS Admin Walkthrough
  • Scheduling Backups
  • Progressive Backups
  • Restoring from a Crash - FileMaker Server
  • Server Performance Improvements 14 - Nick Lightbody
  • Server Performance Improvements 15 - Nick Lightbody
  • 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
  • Printing & Reporting on Government Forms
  • Subsummaries in Detail
  • State of Charting in FileMaker
  • Built-in Charting Overview
  • Google 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
  • WebDirect

  • Overview WebDirect - Android Client for FileMaker
  • MISC

  • Performance Improvements with the 16 Platform
  • Database Performance Tuning with Nick Lightbody
  • Performance Improvements with the 15 Platform
  • Performance Improvements with the 14 Platform
  • How to make an Asset Database in 5 Minutes
  • 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 Cloud

  • 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 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)
  • Restoring from a Backup (Old 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
  • Instance Refresh & Emergency Procedures Part 1
  • Intro T2 Burstable Instances, Performance, CPU Credits
  • CPU Credit and Base lines for T2.Small, T2.Medium, T2.Large
  • Standard Usage Scenario
  • 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...
  • 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 16

    Introduction

  • What is FileMaker Go?
  • Build with FMGo or Code your own App?
  • Brain Dump: Everything New in FileMaker Go 16
  • Brain Dump: Everything you need to know about FileMaker Go in 12 Minutes
  • Installation & Overview

  • Installation & Requirements
  • Free FileMaker Resources
  • Go and WebDirect and their place in the Universe
  • Installing and Uploading DBs - Dropbox
  • Installing and Uploading DBs - Email
  • Installing and Uploading DBs - AirDrop
  • Installing and Uploading DBs with iTunes Sync
  • Licensing FileMaker Go
  • Navigation

  • Navigating FileMaker Go
  • Window Management
  • Card Style Window in Go & WebDirect
  • Connecting to FileMaker Server
  • Record locking with shared solution
  • Display Data in Table / List Views
  • Finds, Sorting, Portals and Tabs
  • Gesture Slide Controls
  • Gesture Tap Controls
  • Force Touch in FileMaker Go
  • Layouts for FileMaker Go

  • Tuning Layouts for Deployment to FileMaker Go
  • Tuning Layouts - Touch Screen Considerations
  • Intro to Directed Workflow
  • Demos of Directed Workflow
  • Detecting Device & Platform Types
  • Detecting Networks
  • Locking Zoom on a Layout
  • Orientation Detection
  • Creating a New Layout for FileMaker Go
  • Optimizing the Layout and CSS Part 1
  • Optimizing the Layout and CSS Part 2
  • Optimizing the Layout and CSS Part 3
  • Controlling Animation States
  • Inputting Data

  • Introduction to Input Methods for FileMaker Go
  • Custom Keyboards Overview
  • Barcode Camera Integration & Insert from Device
  • Container Field - Camera
  • Container Field - Signatures
  • Supported Fonts and Styles in the iOS
  • iBeacons - RangeBeacons
  • iBeacons - Configure Region Monitor for iBeacons

    Managing Digital Media

  • Digital Media Support Summary
  • Container Fields - Streaming & Interaction in iOS
  • Remote Container Intro & Conversion for use in iOS
  • Web Viewer Idiosyncrasies
  • Benefits to streaming video through web viewers
  • AVPlayer Scripted Controls
  • AVPlayer Script Triggers
  • GoDraw
  • Scripting & Syncing

  • Unsupported Script Steps
  • GPS Location Functions
  • URL Protocol and Sandboxing
  • Activating SASE from Go - How to get plug-ins back into FileMaker Go
  • Script Error Capture & User Abort Controls
  • Printing & Exporting

  • Printing - Part 1
  • Printing - Part 2
  • Scripting Print Jobs - Frustration
  • Emailing PDFs - Simple and Complex
  • Exporting & Emailing
  • Security

  • Security Overview & Keychains
  • Sleep & Restore - Overview
  • Sleep & Restore - History
  • Sleep & Restore - Technical Part 2
  • Sleep & Restore - Technical Part 3
  • TouchID
  • Deployment

  • Deployment Strategies Part 1
  • Deployment Strategies, Beaming copies of solutions back to the Developer
  • Syncing - Third Party Tools
  • Syncing - Import Command/Set Field
  • Conclusion

  • Conclusion & Additional Resources
  • About the Author

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 for as long as your subscription is active.