Course Description

Part 2 of this training series continues on with FileMaker Scripting, Calculations, Relationships and Reporting from the guy who actually wrote the book, Scriptology: FileMaker Pro Demystified. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. Intermediate and advanced FileMaker techniques will be taught throughout the three part tutorial series. In order to better understand every nut and bolt that goes into designing a solution, a single file will be created from scratch. The chosen solution is an invoicing solution for its familiarity to a wide audience and flexibility of applying techniques to other solutions. The completed FileMaker file at each stage is provided to assist with the learning process.

FileMaker Pro Expert

John Mark Osborne

John Mark Osborne has been working with FileMaker Pro for over 20 years. He earned his FileMaker Pro degree working on the frontlines of Claris technical support. John was the Technical Lead for FileMaker, serving as an escalation path for other technical support representatives and writing a large portion of TechInfo (now called Knowledgebase), their technical information reference. John also acted as a liaison between the technical support department and the FileMaker development team, reporting bugs, attending product meetings and acting as resource for the development team.John Mark is best known as the author of the popular FileMaker Pro web site Database Pros. The Database Pros web site has been on the internet for 20 years and gets over 35,000 hits a day by offering free FileMaker Pro tips, tricks and techniques.John Mark is also well known as the co-author of the wildly popular Scriptology book and CD ROM. John Mark launched a hands-on training class based on his Scriptology book and it has become so popular that it is now taught at MacWorld Exposition in San Francisco and New York. Most recently, John Mark was one of twelve trainers in the United States authorized to teach their new FileMaker Training Series of classes.John Mark has been a featured speaker at the FileMaker Developer Conference for 15 years. At the 1999 Developer Conference, he was awarded the FileMaker Pro Excellence award for "creation of outstanding technical resources".John Mark is a former technical editors for Advisor magazine working on the tips and tricks section which is the most popular column in the magazine.John Mark has recorded beginner, intermediate and advanced tutorial videos for FileMaker 8, 9, 10, 11, 12, 13, 14 and 15 totaling thousands of hours.John Mark Osborne has been an FBA (FileMaker Business Alliance) working closely with FileMaker, Inc. and their most important customers for the past 15 years. John Mark Osborne has also passed the rigorous FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16 certification tests and is proud to display the FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16 certification logos.

Course curriculum

  • 2

    Ultimate Find

    • Why Script a Find?

    • Basic Find Script

    • Continue and Cancel

    • Hiding Objects

    • Canceling a Script

    • No Records Found

    • No Find Criteria

    • Modify Find

    • Dynamic Scripting

    • List Versus Form

    • Table Occurrence Found Sets

    • GTRR with Table Occurrences

    • Adaptive Saving and Restoring

    • Fixing the Other Scripts

    • Perfecting Invoice Duplication

    • Completed Invoicing Solution

  • 3


    • Anatomy of a Calculation

    • The Variety of Calculation Dialogs

    • Sales Tax

    • Grand Total Part 1

    • Grand Total Part 2

    • Phone Formatting

    • Phone Validation

    • Remove Text Formatting

    • Overdue Invoice Display

    • Locating Overdue Invoices

    • Parsing Text Basics

    • Replacing Data

    • Parsing Text Advanced

    • Scripts versus Calculations

    • Field Level Tracking

    • Field Level Tracking Advanced

    • True Modification Tracking

    • Tooltips

    • Hide Objects in Portals

    • Delivery Work Day

    • Completed Invoicing Solution

    • Parsing Text File

  • 4

    FileMaker Advanced

    • What does it do?

    • Recover

    • Plug-In Example

    • Database Design Report

    • Developer Utilities

    • Script Debugger 101

    • Debugging Script Example

    • Custom Functions with Phones

    • Recursion Primer

    • Recursive Phone Function

    • Validation Recursion

    • Custom Menus

    • Dynamic Custom Menus

    • Completed Invoicing Solution

  • 5

    Multi-User Solutions

    • Sharing a File

    • Record Locking Defined

    • Deleting a Record

    • Adaptive Deletion

    • Deleting a Portal Row

    • Deleting a Line Item

    • Global Fields & Script Variables

    • Identifying Scripts with Record Locking

    • Scripting for Multiple Locked Records

    • Marking Records

    • Multiple User Marking

    • Creating a Multi-Key

    • Saving a Found Set

    • Restoring a Found Set

    • Transactional Processin

    • Inventory Leveling Revisited

    • Completed Invoicing Solution

  • 6

    Custom Form Letters

    • Merge Fields in Browse

    • Substitution

    • Print Layout

    • Print Script

    • Resolving Record Locking

    • Save Letter

    • Insert Letter

    • Overwrite Letter

    • Text Formatting Interface

    • Formatting Magic

    • Emailing

    • History

    • Mistakes

    • Completed Invoicing Solution

  • 7

    Working with John Mark Osborne

    • Services Offered


5 star rating

Fulvio Di Rosa

5 star rating

The Philosophy of FileMaker - Part 2

Bruce Drake

Fabulous use of FileMaker for a really useful solution. Good lessons, good pacing and great instruction.

Fabulous use of FileMaker for a really useful solution. Good lessons, good pacing and great instruction.

Read Less
  • $225.00

    $225.00FileMaker Mega Bundle

    Buy Now
  • $125.00

    $125.00The Philosophy of FileMaker - Bundle

    Buy Now