This 2-day class, taught by FileMaker Business Alliance Trainer Tim Jones, will sharpen your skills as a FileMaker developer. Build better layouts, smarter calculations and scripts, and add subsummary reports and dashboards.
This class, along with our other FileMaker classes, will also help prepare you for the FileMaker Certified Developer exam.
PrerequisitesThis class assumes you have attended our FileMaker Beginning training or are comfortable performing the skills taught in that class.
Outline
Design Better Layouts
- optimize space with tab controls and slide controls
- create button bars and popover buttons
- hide objects conditionally
- control field entry and tabbing order
- use the tools in Layout mode
- field picker
- screen stencils
- inspector and layout objects panels
- guides
- align, distribute and resize objects easily
- show/hide layouts and organize layouts in folders
- format numbers and dates
- make layout objects stretch to fill screen
- specify iOS touch keyboard type
- display calculated tool tip hints on buttons and fields
- insert data-driven web content using web viewers
Write Smarter Calculations
- format or sanitize text entries with text parsing and editing functions
- total and manipulate numbers with rounding and aggregate functions
- use date functions to calculate age, project duration, due dates, etc.
- employ conditional logic with if or case functions
- store calculations as custom functions for easy reuse
Generate Printer-Friendly Reports
- sliding and hiding objects when printing
- group and summarize records using summary fields in subsummary parts
- write scripts to
- go to related records
- automate sorting
- fetch user-customizable report headings
- offer to save report as PDF
- set script triggers to fire scripts automatically
Build Dashboards
- construct advanced relationships to access data from multiple tables on a single layout
- add data-driven pie, bar and line charts to layouts
- write summary calculations
- merge field data into text objects
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.