Course Description

Learn 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 30 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 30 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, 15, 16, 17, 18, 19 and 20 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 20 years. John Mark Osborne has also passed the rigorous FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15, 16 and 17 certification tests and is proud to display the certification logos.

Course curriculum

  • 1

    Introduction

  • 2

    Starting a Database

    • Planning your Solution

    • New Empty File

    • Housekeeping Fields

      FREE PREVIEW
    • Data Entry Fields

    • Primary Key

    • Adding Fields to the Layout

    • Arranging the Fields

    • Title and Merge Fields

    • Shipping Fields

    • Window Size

      FREE PREVIEW
    • Navigation Buttons

    • Status Toolbar

    • Button Bar

    • Tab Control

    • Choosing a Theme

    • Autosizing

    • List View

    • Navigating between Layouts

    • Completed Invoicing File

    • Import Data

    • Sample Requirements Document

  • 3

    Structural Relationships

    • Data Modeling

    • Relational Theory

    • Entity-Relationship Diagrams

    • Creating Tables

    • Creating Relationships

    • Anchor Buoy

      FREE PREVIEW
    • Anchor Layouts

    • Anchor Layouts 2

    • Populating a Foreign Key

    • Many-To-Many Relationship

    • Adding Records to the Portal

    • Finishing the Portal

    • How the Join Works

    • Aggregating Portals

    • Two-Way Relationships

    • Start and End

    • Totaling from Customers

    • Go to Related Record

    • Completed Invoicing Solution

  • 4

    Table Occurrences

    • What are Table Occurrences?

    • Where are Table Occurrences Used?

    • Basic Portal Filtering

    • Global Fields

    • Portal Filtering with Globals

      FREE PREVIEW
    • Totaling Filtered Portals

    • Totaling with ExecuteSQL

    • Complicated Filtered Portals

    • Filtered Portals with Multiple Globals

    • Updating the SQL

    • Filtered Relationships

    • Complex Filtered Relationships

    • Filtering Discussion

    • Self-Relationships

    • Conditional Value Lists

    • Calculated Value Lists

    • Conditional Value Lists Revisited

    • Scripts and Calculations

    • Organizing the Graph

    • Completed Invoicing Solution

  • 5

    Output

    • Printing Philosophy

    • Customer List

    • Improved Customer List

    • Exporting Customers

    • Labels

    • Merge Letters

    • Marbles

    • Building a Report

      FREE PREVIEW
    • Sophisticated Reporting

    • Exporting a Report

    • Printing an Invoice

    • Finishing the Invoice

    • Completed Invoicing Solution

  • 6

    Scripting

    • Scripting Defined

    • Anatomy of the Workspace

    • The Good, the Bad and the Ugly

    • Send Email and Open URL

    • New Invoice from Customers

      FREE PREVIEW
    • New Portal Row

    • Rolodex Find

    • Upcoming Birthdays

    • Duplicating Invoices

    • Batch Print Invoices

    • Inventory Control

    • Inventory Control Scripted

    • Leveling Once and Returns

    • Sub-Summaries in Browse

    • Naming Conventions

    • Completed Invoicing Solution

  • 7

    FileMaker 16 Bonus

    • Revamped Data Viewer Calculation Dialog

    • Data Viewer Example File

    • Layout Objects Window

    • No Example for Layout Objects Window

    • Window Cards

    • Window Cards Example File

  • 8

    Working with John Mark Osborne

Reviews

5 star rating

Best of the best !!!

Frank Lemonis

Awesome !!!!

Awesome !!!!

Read Less
5 star rating

The easiest way to become a FileMaker Pro!

Dennis Henley

This course was interesting and easy to follow. Best of all, I knew more when I reached the end of the course than when I started.

This course was interesting and easy to follow. Best of all, I knew more when I reached the end of the course than when I started.

Read Less
5 star rating

Awesome Filemaker Training

Dirk Zeilinga

At last, a training program that starts with the basics and does not assume any prior knowledge. I have wasted an unbelievable amount of time and money on ...

Read More

At last, a training program that starts with the basics and does not assume any prior knowledge. I have wasted an unbelievable amount of time and money on Filemaker training and support in the past. Your Philosophy of Filemaker series is that far ahead of anything else that it should be promoted by Filemaker as the best starting point for any aspirant Filemaker developer. I appreciate: The many basic concepts which are built upon as one goes from subject to subject. Your clear instructions and explanations. The way you have broken the series up into manageable chunks. The fact that you are not trying to impress with your knowledge but continuously bring it back to the delivery of great solutions. I love the way you introduce really important basic concepts as you cover each topic. These are overlooked and ignored in the official Filemaker material. Why are trainers (the others) unable to write or present in understandable language. There is a concept called the "fog index” which if applied to some of the Filemaker books and training notes indicate the material is beyond the scope of P.Hd’s My only regret is that it has taken me so long to find your material. You are indeed not just a Master of Filemaker but a Master trainer. I am having a ball working through each topic!!! I cannot thank you enough for what you have put together!!!

Read Less
5 star rating

Very interesting

Arnaud Siebering

The training is very well constructed and allows you step by step to understand filemaker, its subtleties, and to develop your own database yourself.

The training is very well constructed and allows you step by step to understand filemaker, its subtleties, and to develop your own database yourself.

Read Less
5 star rating

The Philosophy of FileMaker - Part 1

Gary Bonato

Have been struggling with learning aspects of Filemaker Pro and purchased many other video lessons. Then found 'The Philosophy of Filemaker' on Youtube and...

Read More

Have been struggling with learning aspects of Filemaker Pro and purchased many other video lessons. Then found 'The Philosophy of Filemaker' on Youtube and watched one of the lessons, went and purchased Part 1 to Part 4. Spent 1 hour going thru a couple of lessons which related exactly to what I was trying to do . . . and amazing . . resolved. Thank you will enjoy the rest of the videos and recommend this amazing resource and learning . . .well worth the purchase . . . saves lots and lots of time and frustration and I have only just started.

Read Less
5 star rating

Excellent -

Hew Mills

There's always more to learn. This course covers stuff I should have known since starting with FM7 and earlier, thank you John Mark.

There's always more to learn. This course covers stuff I should have known since starting with FM7 and earlier, thank you John Mark.

Read Less
5 star rating

This is an INCREDIBLE EXCELLENTLY ASSEMBLED ENSEMBLE FOR ...

David Kennedy

I cannot put into words that will express the learning excitement that one experiences from these skillfully crafted videos and supportive example files.. I...

Read More

I cannot put into words that will express the learning excitement that one experiences from these skillfully crafted videos and supportive example files.. I really need to take more time and go through the complete Course again, as it does have sophistication with complete clarity. Thank You, Mr. John Marc Osborne. Bravo!

Read Less
5 star rating

The Best!

Walter Norris

John is simply the best at explaining the ins & outs of FileMaker. There is a competitor with engineers in multiple cities who has a free template with t...

Read More

John is simply the best at explaining the ins & outs of FileMaker. There is a competitor with engineers in multiple cities who has a free template with training. There are tons of numbered table occurrences, numbered layouts, numbered scripts, etc., etc. John has a much simpler and well reasoned approach. At the same time - you get a deeper understanding of FileMaker. I highly recommend any of his courses.

Read Less
5 star rating

The Philosophy of FileMaker - Part 1

Ken Macdonald

5 star rating

The Philosophy of FileMaker - Part 1

Richard Sexton

This course is helping me tremendously to improve my FileMaker Pro Skills. John, I have viewed many You tube videos on how to do something in FM. None have...

Read More

This course is helping me tremendously to improve my FileMaker Pro Skills. John, I have viewed many You tube videos on how to do something in FM. None have been near as good as your explanations. I am so excited about the improvement I am making. I am learning so much it is hard to remember everything I am seeing. I have looked at many lessons more than once. Thanks for putting this training together.

Read Less
5 star rating

Thank you

Omelyan Burtnyk

5 star rating

Great

Robert Vorselman

The way you explain things is very good. Been developing for FileMaker since version 5, stopped at version 13. But picking it up again with 16. Only halfwa...

Read More

The way you explain things is very good. Been developing for FileMaker since version 5, stopped at version 13. But picking it up again with 16. Only halfway trough part 1 and already learned great tricks :)

Read Less
5 star rating

Very Useful, nice.

Fulvio Di Rosa

The must to have in learning FileMaker philosophy developing. Thank You

The must to have in learning FileMaker philosophy developing. Thank You

Read Less
4 star rating

Part 1 Review

Charles Katjivirue

This was the best course I have ever attended.

This was the best course I have ever attended.

Read Less
  • $149.00

    $149.00FileMaker Mega Bundle

    Buy Now
  • $69.00

    $69.00The Philosophy of FileMaker - Bundle

    Buy Now