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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.