FileMaker® 8 Functions and Scripts Desk Reference

Chapter 4. Working with Calculations Primer

The calculation dialog in FileMaker serves as a fundamental element in nearly all development activities. Beyond simply defining calculation fields, you will also work with the dialog within scripts, for setting some auto-enter field options, for field validation, and even within a file’s security settings. We encourage all developers to become deeply familiar with calculation functions and to that end have assembled here a concise reference to how the dialog works.

The Calculation Function Interface

The Calculation dialog allows developers easy access to the data fields in their solutions and to a complete function list (see Figure 4.1).

Figure 4.1. Both field names and calculation templates can ...