FileMaker Pro Intermediate: Getting Ahead as a Developer
Class Details
Length of class: two days
Price per person: $595
Version covered: 2023
Description
This 2-day class, taught by FileMaker Certified Developer Tim Jones, will sharpen your skills as a FileMaker developer. Build better layouts, smarter calculations, elegant scripts, and subsummary reports and dashboards. This class, along with our other FileMaker classes, will help prepare you for the FileMaker Certified Developer exam.
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
Tue-Wed, June 11-12, 2024
8:00 AM - 3:00 PM
Wed-Thu, July 24-25, 2024
8:00 AM - 3:00 PM