Course Description

Based on requests from student of the Philosophy of FileMaker video series, here are intermediate, advanced and expert tips and tricks to help you design better solutions in FileMaker 15. Topics include FileMaker scripting, calculations, relational design and reporting. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. An example file at the end of each video is provided with extensive documentation to supplement the oral directions.

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

    Intermediate Tips & Tricks

    • Notes Outta Nowhere

    • Window Positioning

    • Taming Layout Mode

    • Date Manipulation

    • Concatenating with List

    • Remove Text Formatting

    • Page Totals

    • Buttons

    • Shortcut Efficiency

    • Print Restoration

    • Example Files - Intermediate

  • 3

    Advanced Tips & Tricks

    • Context Sensitive Help

    • Progress Bar

    • Moving/Deleting a File

    • New Portal Row

    • How the Index Works

    • Quick Calendar

    • Isolating a Record

    • Slide Panel Interface

    • Designing with Scroll Bars

    • Highlight Search Criteria

    • Example Files - Advanced

  • 4

    Expert Tips & Tricks

    • Expand/Collapse Portal

    • Filtering Data Entry

    • Numbering Subsummaries

    • Conditional Headers & Footers

    • Multiple Prices

    • List Function Reporting

    • Virtual List: Script

    • Virtual List: SQL

    • Virtual List: Expand/Collapse

    • Multiple Parameters

    • Example Files - Expert

  • 5

    Working with John Mark Osborne

    • 0701

  • 6

    Bonus Tips

    • Reminders

    • Reminders Example File

    • Window Locking

    • Window Locking Example File

    • Containers

    • Containers Example File

    • Portal Notes

    • Portal Notes Example File

    • Dwindling Value Lists

    • Dwindling Value Lists Example File

    • Conditional Headers

    • Conditional Headers Example File


5 star rating

Tips and Tricks

Dirk Zeilinga

I purchased your Filemaker Tips and Tricks yesterday and have worked through the Intermediate set quite quickly as I have been working with Filemaker for a f...

Read More

I purchased your Filemaker Tips and Tricks yesterday and have worked through the Intermediate set quite quickly as I have been working with Filemaker for a few years now. The value for money is outstanding and I really like the way you present the information. Having come from a non programming background it has been a major challenge for me to become proficient in FM. But my persistence is paying off slowly but surely. As in any self directed training "You don't know what you don't know" and I have found your style great with the baby step approach and the example files to refer to afterwards. I have found lots of little bits that will assist me greatly in my work!! As soon as I am through the Tips and Tricks I will purchase the Philosophy of Filemaker series. What I really like is your writing and presentation style. Short sentences and smaller words go a long way in effective communication!!!

Read Less
  • $99.00

    $99.00Techniques Bundle

    Buy Now
  • $225.00

    $225.00FileMaker Mega Bundle

    Buy Now
  • $50.00

    $50.00The Philosophy of FileMaker - Part 1

    Buy Now

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.