U.M. (Windows)

2-20 FileMaker Pro User’s Guide
Functions
A function is a predefined, named formula that performs a specific
calculation and returns a single, specific value. You type only the
function, and FileMaker Pro performs the calculation it represents. You
can use functions by themselves or combine them with other functions
or expressions. For information about specific functions in
FileMaker Pro, see appendix C, “Summary of functions.”
Writing formulas for calculation fields
1. Create a file, or choose Define from the File menu and then choose Fields.
2. In the Define Fields dialog box, for Field Name, type a name for the field.
3. For Type, select Calculation, and then click Create.
4. In the Specify Calculation dialog box, define the formula.
Choose FileMaker Help Index from the Help menu, and then type:
E functions, using
To Do this
Add a field
reference
In the formula box, click where you want the field reference to
appear. In the list of field names, double-click a field name.
Add a
mathematical or
text operator
In the formula box, click where you want the operator to appear. In
the keypad, click an operator. (Quotation marks and parentheses
are copied to the formula as a pair, with the insertion point blinking
in the middle).
Add a comparison
or logical operator
In the formula box, click where you want the operator to appear.
For Operators, choose an operator from the list.
Add a constant value In the formula box, type the value. (See “Constants” on page 2-14.)
Add a function In the formula box, click where you want the function to appear.
From the functions list, double-click a function. (To see a category of
functions, for View, choose a category.) In the formula box, replace
the placeholder parameter with the value or expression you want.
?