Objectives
- Build scripts to automate routines
- Write calculations that are flexible and powerful
- Use the calculations in scripts and on layouts
- Create a clean and efficient data entry layout
Evaluation
At the end of the training, the participants who have achieved the objectives receive a certificate of achievement attesting the success of their participation.
Schedule
Day 1
Part 1: Tour de Functions
- Survey the large set of calculations in FileMaker with a focus on which are important and why
- Learn the broad set of tools available in FileMaker
Part 2: Building a Clean Data Entry Layout
- Learn how to properly design your data entry layout
Part 3: Scripting 01 – Solid Foundations
- Foundations
- Best practices
Day 2
Part 1: Scripting 02 – Primary Script Steps & Debugging
- Discover primary script steps
- Build skills with features
- Error trapping
- Script debugger
- Data viewer
Part 2: Container Fields
- Manage images, PDF files, and other containers
- Explore container field features
- Internal vs. external storage
- Implications of secure image storage
Part 3: Let ( ) and Case ( )
- Use of Let( ) and Case( ) functions
