O'Reilly logo

FileMaker® 12 Developers Reference: Functions, Scripts, Commands, and Grammars by Scott Love, Dawn Heady, Bob Bowers, Steve Lane

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 8. 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, for charting, and even within a file’s security settings. We encourage all developers to become deeply familiar with calculation functions. To that end, this chapter provides a concise reference of how the dialog works.

The Calculation Function Interface

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

Figure 8.1. ...

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