FileMaker Pro Advanced: Getting Famous as a Developer

This 2-day class, taught by a FileMaker Certified Developer/Business Alliance Trainer, 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.

Prerequisites

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

• simply complex calcs with the Let function
• query data from any context with the ExecuteSQL Function
• manipulate text with PatternCount, Position and Filter functions
• work with value list with List, ValueCount and GetValue functions
• grab data using the GetField, GetFieldName and GetNthRecord functions

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
• use object names to reference layout elements
• looping routines and strategies
• generate email messages with attachments

Improved Layouts

• formatting object states
• design custom menus
• create data-driven navigation systems

Securing 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

• enabling external storage
• secure vs. open storage
• define container fields in a separate database file