Master Tips & Tricks of FileMaker Experts
4.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
161 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Tips & Tricks of FileMaker Experts to your Wishlist.

Add to Wishlist

Master Tips & Tricks of FileMaker Experts

Intermediate & Advanced FileMaker Techniques
4.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
161 students enrolled
Created by John Mark Osborne
Last updated 4/2017
Current price: $25 Original price: $100 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 6 hours on-demand video
  • 36 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn important keyboard shortcuts
  • Position window anywhere on the screen
  • Manipulate dates properly
  • Understand restoring of scripts steps
  • Learn layout tricks of the trade
  • Understand how the index works
  • Write scripts at an advanced level
  • Formulate complex calculations
  • Work with local and global variables
  • Create virtual lists
  • Design relationships with operators other than equals
  • Understand SQL
  • Combine scripts, calculations and relationships into a cohesive feature
  • Create custom functions
  • Understand recursion
  • Conquer multi-user issues
  • Uniquely number subsummaries and restart numbering at breaks
  • Define parameters with multiple values
  • Create progress bars
  • Create a quick calendar
  • Delete files off a hard drive with only FileMaker
  • And, much more!
View Curriculum
  • Students should be familiar with layout mode, scripting, calculations and relational design
  • Philosophy of FileMaker Parts 1, 2 and 3 are good experience for this course
  • This is course move from intermediate to advanced to expert

Have fun learning FileMaker with thirty individual technique files covering important concepts in FileMaker. Based on requests from student of the Philosophy of FileMaker video series, this tutorials includes ten intermediate, ten advanced and ten expert tips and tricks to help you design better solutions in FileMaker 15. An example file at the end of each video is provided with extensive documentation to supplement the oral directions. 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.

Who is the target audience?
  • Students who enjoyed the Philosophy of FileMaker video series
  • Aspiring developers with some to moderate experience designing FileMaker solutions
Compare to Other FileMaker Courses
Curriculum For This Course
38 Lectures
Tips & Tricks Overview
1 Lecture 04:51

Thirty tips & tricks to help you design better FileMaker solutions

Preview 04:51
10 Lectures 01:23:35

Make a notes field appear out of nowhere without a popover!

Preview 06:36

Position windows in the center of the screen, in the center of the current window and various other locations!

Window Positioning

Helpful layout mode tips and tricks designed to make you more efficient! 

Taming Layout Mode

Manipulating dates properly is a crucial skill in any database solution.

Date Manipulation

Avoid lengthy Case statement to conditionally concatenate text with the List function.

Concatenating with List

Additional methods to clean up a data entry issues.

Remove Text Formatting

Page numbers are easy what about page totals (e.g. 2 of 5 pages).

Page Totals

The all important button and techniques to give them more flavor.


The keyboard shortcuts I use personally and why I use them.

Shortcut Efficiency

The ins and outs of restoring Print Setup and Print script steps.

Print Restoration
10 Lectures 01:25:32

Adding help to a FileMaker solution so it is easy to deploy is the focus of this technique.

Context Sensitive Help

Three methods for creating a progress bar.

Preview 12:03

Moving and deleting files at the operating system level with nothing other than FileMaker!

Moving/Deleting a File

Multiple methods for adding a new portal row without the blank row.

New Portal Row

Understanding exactly how the index works makes you a better FileMaker developer.

How the Index Works

A calendar that's easy to implement and upkeep.

Quick Calendar

Isolating a record to a found set of itself is easy but did you know the multi-user issues and get around them?

Isolating a Record

An alternative to the Tab Control feature with animation to give your interface a little more flavor!

Slide Panel Interface

How to efficiently design portals with invisible scroll bars so everything works properly.

Designing with Scroll Bars

One of the number one requested features for FileMaker but it's not that complicated to add with a calculation.

Highlight Search Criteria
10 Lectures 01:45:44

Revealing and hiding grandchildren records in a portal.

Preview 14:58

Validation and Auto-Enter are great but what about the benefits of script triggers to simulate these features?

Filtering Data Entry

Uniquely number subsummary breaks as well as restarting the numbering of records within each subsummary group.

Numbering Subsummaries

Subsummary records that break across a page can be labeled with a conditional calculation.

Conditional Headers & Footers

Price breaks based on quantity ordered.

Multiple Prices

When traditional reporting techniques won't work to combine multiple tables in a single report.

List Function Reporting

The coolness of virtual lists are explored and will open your mind to the possibilities of FileMaker programming.

Virtual List: Script

Virtual lists with no scripts!

Virtual List: SQL

Expanding and collapsing related records below their parent with virtual lists.

Virtual List: Expand/Collapse

Passing multiple values in a single parameter the easy way and the super genius way.

Multiple Parameters
Bonus Tips
6 Lectures 01:02:01

A reminder system, much like you see in a calendar solution, using the Install OnTimer Script step.


Avoid window locking when spawning new windows (not to be confused with record locking).

Window Locking

All about container fields including storage methods, interactive PDFs, scripting and more!


Storing notes in a single text field can get messy, especially with multiple users entering data. With a little more work, a portal can neatly organize your notes and even allow for a few additional features.
Portal Notes

Dwindling value lists are a common request from my clients, especially when reservations are being made. In this example, there are a limited number of tables that can be reserved for the day. As soon as a table is reserved, it should disappear from the value list so it can’t be selected again.

Dwindling Value Lists

If the records in a single subsummary group break across the page boundary, the listing on the next page is not identified by the subsummary part contents. This can make it difficult to read a report when you have to continually flip back a page or two to see the heading for the grouping.

Conditional Headers
Working with John Mark Osborne
1 Lecture 05:18

Work directly with John Mark Osborne on your project or training needs.

Preview 05:18
About the Instructor
John Mark Osborne
4.7 Average rating
585 Reviews
4,517 Students
9 Courses
FileMaker Pro Expert

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 is an FBA member (FileMaker Business Alliance) working closely with FileMaker, Inc. and their most important customers. John Mark Osborne has also passed the rigorous FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 certification tests and is proud to display the FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15 certification logos.