About formulas
Formulas perform specific operations on one or more values in a database file, and return a single result.
Formulas can be used to define:
•a calculated value that can be used to replace the values in a field (by using the Replace Field Contents command in the Records menu or a script step). See
Replacing the contents of a field.
•calculations in some FileMaker script steps, such as the script steps
If, Exit Loop If, Set Field, Insert Calculated Result, and
Replace Field Contents. See
Automating tasks with scripts.
Formulas can contain:
•constants - numbers, text, date, or time values that don’t change.
•operators - symbols that indicate how to combine or compare two or more values.
•functions - predefined, named formulas that perform specific calculations and return single, specific values for each repetition.
Examples
Formulas can be used in many places throughout FileMaker Pro. Here are some examples:
•Returns the first and last name separated by a space:
FirstName & " " & LastName
For example, Michelle Cannon.
•Returns the value in the SubTotal field multiplied by .08:
SubTotal * .08
•Returns the first and last name, each on a separate line:
Field1 & ¶ & Field2
For example,
Fred
Jane
Related topics