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