Tutorials and Online Training Videos

FileMaker Pro 11: Advanced Tutorial

FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical "how to" course by FileMaker expert John Mark Osborne, starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10 and 11 features and techniques including the Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. To begin learning today, simply click on the movie links.


About John Mark Osborne
System Requirements
FileMaker 11 Family of Products pt. 1
FileMaker 11 Family of Products pt. 2
About the Tutorial Series pt. 1
About the Tutorial Series pt. 2
Why an Invoicing Solution? pt. 1
Why an Invoicing Solution? pt. 2
What is a Database? pt. 1
What is a Database? pt. 2
Planning Your Solution
New FileMaker 11 Features
IMPORTANT: Work File Passwords

Ultimate Find

Why Script a Find?
Find Layout
Basic Find Script with Button
Continue & Cancel pt. 1
Continue & Cancel pt. 2
Cancel Improved
Modular Scripting
No Records Found
No Find Criteria
Errors in Memory
Modify Find
Dynamic Scripting
List vs. Form
Save by Table Occurrence pt. 1
Save by Table Occurrence pt. 2
Save by Table Occurrence pt. 3

Save a Found Set

Organization pt. 1
Organization pt. 2
Loop with Global pt. 1
Loop with Global pt. 2
Loop with Variable
Speed Testing
GetNthRecord Recursion
Compare & Contrast pt. 1
Compare & Contrast pt. 2
Save Multiple Found Sets
Duplicate Set Names
Restore Multiple Found Sets Layout
Restore Multiple Found Sets Script
Completing the Interface
Account Aware Found Sets
Save with Snapshot Link
Restore with Snapshot Link

Parsing Text

Advanced Text Parsing Techniques
Gathering Find Criteria
Saving Find Criteria
Restoring Find Criteria pt. 1
Restoring Find Criteria pt. 2
Restoring Find Criteria pt. 3
Compare & Contrast
Parse Web Form
Parse Popup Menu
New Requests Interface
New Requests Script pt. 1
New Requests Script pt. 2
Charting with Delimited Data

Delete Duplicates

Basic Duplicate Search
Global Loop pt. 1
Global Loop pt. 2
Improving the Loop
Replace Field Contents
Improving Replace Technique
Export by Group
Merging Duplicate Records
Validating Duplicates
Compare & Contrast
Scripted Duplicates Defined
Scripted Duplicates Interface
Scripted Duplicates Scripts pt. 1
Scripted Duplicates Scripts pt. 2
Scripted Duplicates Scripts pt. 3

Recursive Phone Filter

Why Recursion?
Recursive Formula
Global Preferences pt. 1
Global Preferences pt. 2
Startup Layout
Personal Information
Auto Enter pt. 1
Auto Enter pt. 2
Multi-User Preferences pt. 1
Multi-User Preferences pt. 2
Multi-User Preferences pt. 3
Multi-User Preferences pt. 4
Multi-User Preferences pt. 5
Multi-User Preferences without Accounts pt. 1
Multi-User Preferences without Accounts pt. 2
Revisiting Validation

Back Button

Mimic Web Browser
Storing Layouts
Back Layout pt. 1
Back Layout pt. 2
Forward Layout
Back Record & Window
Visual Interface Cue
Dimmed Buttons Structure
Dimmed Buttons Interface
Dimmed Buttons Script
Dimmed Buttons for Multiple Tables

Custom Form Letters

Flexible Form Letters
Form Letter Fields
Form Letter Interface pt. 1
Form Letter Interface pt. 2
Print Layout
Print Script
Record Locking Issue
Save Letter
Insert Letter
Changing Text Style Components
Changing Text Style Interface
Changing Text Style Script

Miscellaneous Techniques

Conditional Formatting Basics
Dimmed Buttons
Field Highlight
Better List View
Hidden Field Labels
Portal Resize
Sorting Portals
Totaling to Zero
Highlight Portal Row
Cross-Tab Reports
Transaction Processing

Event Driven Scripting

Overview & Considerations pt. 1
Overview & Considerations pt. 2
Definitions pt. 1
Definitions pt. 2
Simple Yet Powerful Triggers
Resetting Globals
Using the Toolbar
Validating Duplicates Revisited pt. 1
Validating Duplicates Revisited pt. 2
Portal Refresh
Custom Quick Find
Highlight Quick Find
Commit Record
Save/Revert Record
No Field Selected pt. 1
No Field Selected pt. 2
Prevent Carriage Return
Highlight Record
Automatic History pt. 1
Automatic History pt. 2
Interaction Between Multiple Triggers
Revisit Back Button

Final Touches

Hiding Trash Can
Hidden Notes
Print as PDF Dynamically pt. 1
Print as PDF Dynamically pt. 2
Better List to Form
Scripted Popup Menus
Check List

Working with John Mark Osborne

Free Resources
Consulting & Meta-Consulting
Contacting Me

Related Books on FileMaker Pro 11: Advanced

Save $80 on the
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts