O'Reilly logo

FileMaker 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples by Steve Lane, Scott Love, Bob Bowers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required