Click here to print

FileMaker Pro Advanced: Getting Famous as a Developer

Class Details

Length of class: two days
Price per person: $695
Version covered: 19


This 2-day class, taught by FileMaker Certified Developer Tim Jones, will teach you best practices and help you avoid pitfalls to create elegant solutions that are easy to use and update. Explore complex relationships, advanced calcs, scripts, data-driven navigation, remote container data and how to secure and share your solution.


This class assumes you have attended our FileMaker Intermediate training or are comfortable performing the skills taught in that class.


Complex Relationships
- filtered value lists
- filtered portals
- use global fields for filtered relationships

Sophisticated Calculations
- simplify complex calcs with the Let function
- query data from any context with the ExecuteSQL Function
- work with value list with List, ValueCount and GetValue functions
- grab data using the GetNthRecord function

Advanced Scripts
- pass information into and between scripts using script parameters and script results
- local and global variables
- if, then, else conditional branching
- opening and controlling windows
- looping routines and strategies
- generate email messages with attachments

Improved Layouts
- format object states
- design custom menus
- create data-driven navigation systems

Secure and Sharing Data
- implement security via accounts and privilege sets
- peer-to-peer sharing from FileMaker Pro
- upload a database to FileMaker Server
- enable iOS and Web-based access

External Storage of Container Data
- enable external storage
- secure vs. open storage
- define container fields in a separate database file

Upcoming Dates

Mon-Tue, October 19-20, 2020
9:00 AM - 4:00 PM

Fri-Sat, November 20-21, 2020
9:00 AM - 4:00 PM