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.
Outline
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
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.