| Price per person: | $695 |
| Length of class: | two days |
| Version covered: | 2024 |
| Delivery format: | live over Zoom |
This two-day class by FileMaker Certified Developer Tim Jones will teach you best practices and help you avoid pitfalls and create elegant solutions that are easy to use and update involving complex relationships, advanced calcs, sophisticated scripts, data-driven navigation, remote container data and robust security. Learn to use the Relationships Graph to filter value lists and portals and incorporate global fields in relationships. Explore the Let and ExecuteSQL functions, among others. Write scripts that include variables, conditional branching, loops, and send email, and learn how to pass information into and between scripts. Create a data-driven navigation system that lets users freely move about the solution from every layout that you can update from a single table. And secure your solutions with privilege sets and extended privileges.
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