Course Description

This advanced course for FileMaker 17 covers the creation of a Calendar solution from scratch. Every nut and bolt will be shown to foster a better learning experience. Any version of FileMaker from 13 through 17 can benefit from this course, with the exception of a few exercises. Topics include monthly, weekly and daily views and all the complicated calculations and relationships required to make these views.

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

  • 2

    Calendar Pickers

  • 3

    Month View

    • Dates Table

    • Generate Days Script

    • Import Days

    • Filtered Relationship

    • Plethora of Portals

    • Navigation Buttons

    • Highlight Colors

    • Highlighting Perfected

    • Day Numbers

    • Portal Highlight

    • Quiz for Chapter 3

    • Finished FileMaker File

  • 4


    • Events Table

    • Day & Week View

    • Interface Updates

    • Automating New Events

    • Scripting the Event

    • Navigation Interface

    • Navigation Scripts

    • Script Triggers

    • Editing & Deleting

    • Brain Malfunction

    • Monthly Events

    • Time Formatting

    • New Month Events

    • Quiz for Chapter 4

    • Finished FileMaker File

  • 5

    More Events

    • Holidays Table

    • Holidays Interface

    • Modular Scripting

    • Holidays Import

    • Bugs and Formatting

    • Priority

    • 42 More Portals

    • Carpal Tunnel

    • Edit & Delete Button

    • Navigation

    • Finished FileMaker File

    • Quiz for Chapter 5

  • 6

    Multiples, Etc.

    • Multiple Event Colors

    • Preferences

    • Never-ending Interface

    • Multiple Calendars

    • Multiple Users

    • Differentiating User Events

    • Changing Users on the Fly

    • Label Bug

    • Trigger Keystroke

    • Miscellaneous

    • Quiz for Chapter 6

    • Finished FileMaker Solution

  • 7

    Visual Events

    • Ups & Downs of Visual Events

    • Generate Events Script

    • Importing Events

    • New Events

    • Remove Blanks

    • Edit Events Part 1

    • Edit Events Part 2

    • Deleting Events

    • Adds, Edits and Deletes

    • Overlapping Events

    • Traditional Week View

    • Quiz for Chapter 7

    • Finished FileMaker Solution

  • 8

    Bits & Pieces

    • Oops!

    • Perfecting the Swatches

    • No Records Found

    • Report Layout

    • Report Automation

    • Find Script

    • Security

    • Custom Menus

    • Clean Up

    • Quiz for Chapter 8

    • Finished FileMaker Solution


5 star rating

Don't let the "Advanced" label stop you!

Michelle Gonzales

I’ve learned so much over the years by taking advantage of John Mark Osborne’s tutorials, so whenever he has a new one available, I’m quick to purchase it. I...

Read More

I’ve learned so much over the years by taking advantage of John Mark Osborne’s tutorials, so whenever he has a new one available, I’m quick to purchase it. I hesitated to buy this one, however, because the course summary made it clear that it’s an advanced course, and I doubted that I was ready for something like that. After watching a couple of the preview videos, though, I decided to buy it, and I’m so VERY glad I did! The thought process involved in building a calendar solution is different from anything I’ve done so far. There are some rather complex features, but John Mark explains the reason for everything, and his step-by-step methods make them easy enough to understand. Throughout the entire tutorial, he provides tips and shortcuts for making the development process easier and, in many cases, faster – especially when the task is repetitive. I appreciate the way John Mark leaves his little mistakes in the videos, because that’s something which really happens. It’s extremely helpful to see the process involved in correcting them. And it’s a great confidence-booster on the rare occasions when I spot the answer before he does! The questions at the end of each chapter focus on the important concepts, and it’s a nice little “pat on the back” when I get them all correct. I really appreciate the ones I either get wrong or get right only after much thought, though, because they show me the areas I need to review. So, if you’re just barely getting started with FileMaker Pro, the comprehensive “Philosophy of FileMaker” series will give you everything you need. But if, on the other hand, you’re like me and you’re hesitating to purchase the “Calendar Conundrum” because it’s labeled as an advanced course, I highly recommend that you just do it. You won’t be sorry!

Read Less
4 star rating

Excellent Class

Sam Jordan

JMO does a great job breaking down the complexities of developing a calendar solution. I would have given the course 5 stars, but a few of the explanation...

Read More

JMO does a great job breaking down the complexities of developing a calendar solution. I would have given the course 5 stars, but a few of the explanations went just a little long, and while I understand the logic of going through every step, performing tasks such as assigning 42 portals then having to redo that action because of the positioning of the explanation adds a level of frustration. I'm not sure how I would accomplish both of these elements differently, but, just saying.

Read Less

Pricing options

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