Tutorials and Online Training Videos

FileMaker Pro 9: 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 and 9 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 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 one of the FileMaker Pro 9: Advanced links.

The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 9 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution.

* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary.

** This tutorial is part three in a 3-part FileMaker Pro 9 series.

*** Captions not yet available on CD version.


About John Mark Osborne
FileMaker 9 Family of Products pt. 1
FileMaker 9 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
Accounts & Passwords

Ultimate Find

Why Script a Find?
Find Layout
Continue & Cancel
Modular Scripting
No Records Found
No Find Criteria
Modify Find
Dynamic Scripting
List Versus Form
Save by Table Occurrence pt. 1
Save by Table Occurrence pt. 2

Save a Found Set

Organization pt. 1
Organization pt. 2
Loop with Global
Loop with Variable
Speed Testing
GetNthRecord Recursion
Compare & Contrast
Save Multiple Found Sets
Duplicate Set Names
Restore Multiple Found Sets pt. 1
Restore Multiple Found Sets pt. 2
User Interface

Parsing Text

Advanced Text Parsing Techniques
Store Find Criteria
Save Find Criteria
Restore Find Criteria pt. 1
Restore Find Criteria pt. 2
Compare & Contrast
Parse E-mail
Parse Pop-up Menu pt. 1
Parse Pop-up Menu pt. 2
New Requests Interface pt. 1
New Requests Interface pt. 2
New Requests Script

Delete Duplicates

Basic Duplicate Search
Global Loop pt. 1
Global Loop pt. 2
Improving the Loop
Replace Field Contents
Export by Group pt. 1
Export by Group pt. 2
Validate on Exit
Compare & Contrast
Contacts from Invoices pt. 1
Contacts from Invoices pt. 2
Contacts from Invoices pt. 3

Recursive Phone Filter

Native Formula
Static Case Statement
Recursive Formula
Global Preferences
Startup Layout
Personal Information
Auto Enter
Multi-User Preferences pt. 1
Multi-User Preferences pt. 2
Multi-User Preferences pt. 3

Back Button

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

Custom Form Letters

Flexible Form Letters
Form Letter Fields pt. 1
Form Letter Fields pt. 2
Form Letter Interface
Print Layout
Print Script pt. 1
Print Script pt. 2
Save Letter
Insert Letter pt. 1
Insert Letter pt. 2
Changing Text Style
Text Attribute Script pt. 1
Text Attribute Script pt. 2

FileMaker 9 Techniques

Conditional Formatting Basics pt. 1
Conditional Formatting Basics pt. 2
Change Background
Field Highlight
Better List View?
Record Highlight
Hidden Field Labels
Portal Resize
Sorting Portals
Highlight Portal Row

Final Touches

Delete Portal Row pt. 1
Delete Portal Row pt. 2
Hidden Notes pt. 1
Hidden Notes pt. 2
Menu Button Change
Print as PDF Dynamically pt. 1
Print as PDF Dynamically pt. 2
Better List to Form
Check List

Working with John Mark Osborne

Free Resources pt. 1
Free Resources pt. 2
Consulting & Meta-Consulting
Contacting John Mark Osborne

Related Books on FileMaker Pro 9: 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