Chapter 7. Calculation Primer

The Calculation dialog in FileMaker serves as a fundamental element in nearly all development activities. Beyond simply defining calculation fields, you also work with the dialog within scripts, for setting some auto-enter field options, for field validation, for ToolTips, for conditional field formatting, 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 of how the dialog works.

The Calculation Function Interface

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

Figure 7.1. Both field names ...

Get FileMaker 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.