FileMaker Pro Intermediate: Getting Ahead as a Developer
Class Details
Length of class: two days
Price per person: $595
Version covered: 2024
Description
This two-day class by FileMaker Certified Developer Tim Jones will sharpen your skills as a FileMaker developer by teaching you how to build better layouts for desktop and iOS devices, smarter calculations, more elegant scripts, and subsummary reports and dashboards. Improve the use of space on your layouts with tab controls and slide controls, conditionally hide layout objects, create data-driven popup menus and web viewers, and allow objects to stretch and shift to fill larger screen space. Master dozens of the most important calculation functions including Let, Case, PatternCount, and ExecuteSQL. Learn how to generate and automate subsummary reports with detailed layout work and simple scripts, and how to represent your data as meaningful charts.
Prerequisites
This class assumes you have attended our FileMaker Beginning training or are comfortable performing the skills taught in that class.
Outline
Design Better Layouts
- show/hide layouts and organize layouts in folders
- optimize space with tab controls and slide controls
- build relationships and portals
- implement Anchor-Buoy approach to graph management
- use the tools in Layout mode
- field picker
- object panel
- screen stencils
- inspector and layout objects panels
- ruler guides
- align, distribute and resize objects
- hide objects conditionally
- define dynamic value lists
- control field entry
- format number and date fields
- stretch and shift layout objects to fill screen
- insert data-driven web content using web viewers
Write Smart Calculations
- manipulate numbers with rounding functions
- manipulate text strings with parsing and editing functions
- create and extract values from value lists
- use date functions to create and manipulate dates
- aggregate values from related records
- employ conditional logic with the Case function
- store calculations as custom functions for easy reuse
- display calculated tool tip hints on buttons and fields
Generate Printer-Friendly Reports
- sliding and hiding objects when printing
- group and summarize records using sub-summary parts
- write scripts to
- automate sorting
- go to related records
- fetch user-customizable report headings
- save report as PDF
- use triggers to run scripts automatically
- let users customize report headings using global variables
- merge field data and variables into text objects
- save report as PDF
Build Dashboards
- add data-driven bar and pie charts to layouts
- construct advanced relationships to access data from multiple tables on a single layout
- write simple ExecuteSQL calculations
Upcoming Dates
Mon-Tue, December 9-10, 2024
8:00 AM - 3:00 PM