Logo

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: 18

Description

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.

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
- 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
- use object names to reference layout elements
- 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

Wed-Thu, October 30-31, 2019
9:00 AM - 4:00 PM

Mon-Tue, November 25-26, 2019
9:00 AM - 4:00 PM