Master Tips & Tricks of FileMaker Experts

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

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

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

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

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

Additional methods to clean up a data entry issues.

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

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

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

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

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

Three methods for creating a progress bar.

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

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

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

A calendar that's easy to implement and upkeep.

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

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

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

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

Revealing and hiding grandchildren records in a portal.

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

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

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

Price breaks based on quantity ordered.

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

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

Virtual lists with no scripts!

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

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

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).

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

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.

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.

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