U.M. (Windows)

Creating a database file 2-15
FileMaker Pro interprets the type of data of a constant value according to
the way you type the constant in a formula. Be sure to type each constant
in a consistent format. (Quotation marks indicate a text expression.)
Field references
A field reference is a field name that acts as a placeholder for the field’s
value. When FileMaker Pro evaluates the formula in the current record,
the value in the field represented by the field reference is used in the
calculation. (Quotation marks indicate a text expression.)
Operators
You combine expressions using operators, symbols that determine
which operation to perform on the expressions. You place operators
between the expressions you want to perform the operation on, as in:
Subtotal + Tax
For this type
of data
Do this when you
type a constant Examples
Text Enclose the text in quotation marks (") "Montréal"
"514 555 1212"
Number Don’t include thousand separators or
currency symbols
123
1234.56
Date Use the value as a parameter of the Date
function or TextToDate function. See
appendix C, “Summary of functions.”
Date(2,1,1998)
TextToDate("03/04/1998")
Time Use the value as a parameter of the
Time function or TextToTime function.
See appendix C, “Summary of
functions.”
Time(4,14,32)
TextToTime("02:47:35")
This expression Returns
Invoice Total*0.075 7.5 when the value in the Invoice Total field
is 100
First Name & " " & Last Name "John Jones" when the value in the First Name
field is “John” and the value in the Last Name
field is “Jones”
Relationship Name::Invoice
Total*0.075
7.5 when the value in the Invoice Total field is
100. The Invoice Total field is located in a
related database
The syntax is Relationship name::Field name