
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.
Derive the first day of the month with the date function and get current date to handle locale differences; use let and custom functions for first day and last day.
If you'd like your week to start on Monday instead of Sunday, use this formula in the downloadable file.
Enhance the FileMaker calendar interface by restricting field access, applying conditional formatting to highlight the current month and date, and refining borders, headers, and day labels for clarity.
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.
Add day buttons to a FileMaker calendar using two approaches: a simple script trigger method and a date display button with parameters, showing dates in a custom dialog.
Create a dates table as the relational calendar’s reporting backbone in FileMaker, with housekeeping fields, a primary key, and a date field populated by a script.
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.
Create a basic monthly calendar by using 42 portals linked via a relationship and minimal calculations, achieving precise layout and clean formatting.
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.
Create an event via a FileMaker script in a pop-over, transferring data from global fields to a new record and initializing the name and time start and end fields.
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.
Develop a modular daily find script in FileMaker that uses Get Current Date to search and display today’s and this week’s records, with on object exit triggers and sorting.
Enable in-place event editing via a popover, expanding fields like location, address, city, state, zip, phone, website, and notes, and implement a delete action with a confirmation dialog.
Explore how to display monthly events in FileMaker using the list function, establish relationships, and concatenate the name and start time to show each day’s events.
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.
Build a basic holidays interface in FileMaker to manage fixed and variable holidays, with fields for name, date, month, day, year, and a fixed/variable radio.
Master importing holidays into the events table with a script, using a custom dialog to input the year, duplicate checks, and an import flow that marks holidays for calendar highlighting.
Create and manage a priority feature in FileMaker by adding a priority field and a global field to assign values from popovers, mapping hot, warm, cold colors via scripts.
Implement a hover-activated edit/delete button in a FileMaker events portal with sizing and right-side icon placement. The delete action affects the record, and the button can be reused across portals.
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.
Discover how to manage multiple calendars in FileMaker by applying color-coded labels, creating a global display field with a value list, and syncing views with scripts.
Differentiate user events by implementing per-account security and privilege sets, using a global field to filter calendars and show each user's items.
Learn to enable changing users on the fly in FileMaker by creating an accounts table, auto-entering account names, and driving a dynamic pop-up menu for calendar views.
Fix calendar behavior by automatically updating dates on exit with a refresh window script, and switch from month to list view to display the current month's events.
Explore visual events in a FileMaker calendar, using 15-minute increments and multiple records per hour to display overlapping events. Weigh the advantages and drawbacks of adopting a visual calendar approach.
Generate events for a full year by looping through dates and creating 14,965 event records from 8 a.m. to 6 p.m. with 15 minute increments, in FileMaker.
Edit scripts to support new visual events by locating existing records in find mode, using time start and time end range searches, and linking records with a shared event id.
Remove blanks from the calendar by filtering for the first event name in each sequence, using a portal, and create a weekly visual view.
Explore editing a FileMaker calendar event by updating global fields, populating new values from the current event, and replacing old sequences when dates change.
Create a delete event script that removes the event, refreshes the list view with a daily find, and runs only on the Callendar list view.
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.
Fix a bug in the calendar app by correcting initialization and script triggers, connect colour's calendar to events, and add safeguards for deletes and overlapping events, with thorough testing.
Perfect swatches in Filemaker by making the highlight fill the row, aligning color and name, centering the body to 28, and removing corner radius for a professional look.
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.
Design and automate a FileMaker report workflow with scripts, custom dialogues, and print setup. Preview, print, save as pdf, then email or save to desktop.
Build a find script in FileMaker calendar conundrum that searches event name and notes via a global x search field and a simple custom dialog.
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!