About formulasFormulas perform specific operations on one or more values in a database file, and return a single result.
• 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 Creating scripts to automate tasks.
•
• 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.
• field references - fields in the same table or in a related table. A related field referenced in a calculation has the syntax tablename::related field. See Working with related tables and files.
• FirstName & “ ” & LastName returns the first and last name separated by a space. For example, Michelle Cannon.
• SubTotal * .08 returns the value in the SubTotal field multiplied by .08.