Course Description

Dive deep into the FileMaker calculation engine with this course designed for intermediate or aspiring developers. Topics include live calculation fields, auto-enter formulas, validation calculations, Hide Object, Conditional Formatting, Tooltips, Placeholder Text, Scripting (as it applies to calculations), custom functions, parsing and much more. Includes a free copy of $29.95 Complex Calculations solution.

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

Reviews

5 star rating

Learn to write calculations like a seasoned developer!

Michelle Gonzales

Every single one of John Mark Osborne’s courses are detailed and full of useful tips, and "Complex Calculations for FileMaker" is no exception. There are usu...

Read More

Every single one of John Mark Osborne’s courses are detailed and full of useful tips, and "Complex Calculations for FileMaker" is no exception. There are usually multiple ways of accomplishing a task, and he always takes the time to explain where and why you might want to use one over another. As a result, you learn to compare techniques and choose the best one for your specific situation. Basically, what John Mark does is help you learn to think like a developer! Although this course offers so very much more, there are two things that really stood out for me. First is the way John Mark demonstrates how to break down a complex calculation piece by piece in the Data Viewer. Being able to see how each portion works is invaluable! The second thing is something I’ve always had difficulty understanding – the concept of recursion. The way it’s explained in the ”Phone Formatting” video makes it perfectly clear, though, and I finally get it! While I only mentioned those two standout items, I learned something with each lesson, and that makes this course worth every single penny!

Read Less
5 star rating

Fulvio Di Rosa

5 star rating

GREAT COURSE | I will be looking for Complex Calculations...

Chuck Coughlin

This is by far the best course I have taken. So much information. It is nice to learn by example. It just makes so much sense to see it being used. The...

Read More

This is by far the best course I have taken. So much information. It is nice to learn by example. It just makes so much sense to see it being used. The only suggestion I have is can you create another one with different calculations. I am learning so much from this course I will be 1st in line to purchase Complex Calculations for FileMaker 2. GREAT JOB--It is PERFECT!!!!!

Read Less