
Meet John Mark Osborne, a seasoned FileMaker expert with 20+ years of experience and certifications across versions, highlighting training leadership and resources like database pros and the philosophy of FileMaker.
Learn a single calendar solution in FileMaker through a hands-on tutorial that builds from scratch, covers advanced topics and scripting, with downloadable end-of-chapter files for practical learning.
This lecture explains that the FileMaker calendar lacks drag and drop, shows editing appointment dates and times, and compares web viewer options with calendars such as C-code and simple calendar.
Build a dynamic FileMaker calendar inside a database with monthly, weekly, and daily views using scripts, calculations, and relational data, and add events with an intuitive interface.
Create a simple dropdown calendar in FileMaker using a date field and calendar icon to pick dates, then explore a full relational calendar with monthly views and search.
If you'd like your week to start on Monday instead of Sunday, use this formula in the downloadable file.
Build a FileMaker calendar using global month and year popup menus to drive the display, converting month text to a number with a custom function.
Fix the interface highlight with a conditional formula based on month and year using global fields. Add navigation buttons that update the current month and keep the date highlight aligned.
Squash a calendar navigation bug in FileMaker by creating a script that sets month and year fields using a case statement, and test December to January transitions.
Display multiple calendars side by side by tweaking calculations for next and previous months, adjusting conditional formatting, and updating layouts to show synchronized year navigation.
Generate days script for FileMaker calendars creates 365 date records per year, using get nth record and date functions with a custom year input to handle leap years and culture.
Troubleshoot why the current month's day lacks highlight in a FileMaker calendar portal, and apply conditional formatting to ensure consistent day highlighting across months.
Explore two ways to create events in FileMaker, starting with on-demand entries and progressing toward a visual calendar. Build an events table with id, date, start, end, name, and notes.
Automate new event creation in FileMaker calendar conundrum with a pop over and global fields for name and date, triggering a script to set the date and create the event.
Explore building a FileMaker navigation interface with a global X display, a day/week/other radio, and start/end date fields. Learn show/hide logic and layout tweaks to enable scripting.
Learn to build FileMaker navigation scripts that auto-enter the current day or week to drive day and week views, with next and previous controls.
Learn to format times in FileMaker by building a 12-hour display with hours, minutes, and am/pm using a let-based calculation, and sort the relationship to display times in order.
Discover how to add new month events in FileMaker by reusing the add event script on the calendar layout, changing context, and passing the current date from the monthly view.
Explore how to implement navigation between month views in FileMaker, fix a script-trigger bug, and configure a go-to-related-record workflow to display the full month or week from a calendar.
Colorize calendar events by linking color swatches to a colors ID through a foreign key and labels, updating scripts and layouts across portals.
Differentiate user events by implementing per-account security and privilege sets, using a global field to filter calendars and show each user's items.
Explore editing a FileMaker calendar event by updating global fields, populating new values from the current event, and replacing old sequences when dates change.
Learn to prevent overlapping calendar events in FileMaker by using execute as cuil to search an internal table without schema changes. Detect duplicates before adding or editing events.
Create a visual week view in FileMaker by building a calendar with a weekly portal of events, driven by a global week field and an x week calculation.
Design a printer-friendly calendar report in FileMaker by creating a dedicated print layout and using the list view for speed, with fonts, margins, and page breaks optimized for print.
This advanced course in FileMaker development walks you through the process of creating a calendar with a daily, weekly, and monthly view. In addition to creating a finished calendar from scratch, you'll learn tons about scripting, calculations and relational design. Author of "Scriptology: FileMaker Pro Demystified", John Mark Osborne, helps you understand complex concepts with ease. Even if you don't want to build a calendar solution, you'll still benefit from the training in this video. If you want a challenging video training that will take you to the next level of FileMaker design then this product is for you!