User manual

11-4 FileMaker Pro User’s Guide
Logical operators
Use logical operators to include conditions in a calculation.
Operator Definition Example
AND True only when both of two ApplicationReceived=
values are true. ”Y” AND FeePaid>0
OR True when either of two values is CurrentBalance <= 0 OR
true. CreditApproved=”Y”
XOR True when either, but not both, of FeePaid>0 XOR
two values is true. The result is: FreeGift= “Y”
1 false when true AND true
1 true when false AND true
1 false when false AND
false
Text operators
Use the following text operators with text expressions. (Double
quotation marks enclose text constants.)
Symbol Definition Examples
& Appends the text string on "XXX" & "ZZZZZ" returns
(Concatenation)
the right to the end of the "XXXZZZZZ"
text string on the left. Text
strings can be constants (in
quotes), field references, or
some functions.
NOT Changes a value within
parentheses from false to true or
from true to false. The result is:
1 false when NOT true
1 true when NOT false
NOT IsEmpty(FieldName)
" "
(Text constant)
Marks the beginning and "Sydney, NSW" returns
the end of a text constant. Sydney, NSW
Quotation marks without
"" returns an empty (null) value
text between them indicate
FirstName & " " &
no text. If you enter text
LastName returns John Smith if
into a formula without
the fields referenced hold John
quotation marks,
and Smith
FileMaker Pro interprets
the text as a field name or
"The report said
function name. To put a
""Confidential"" on the
quotation mark in a text
top" returns The report said
constant, precede it with
"Confidential" on the top
another quotation mark.
¶ Inserts a paragraph return
(Return marker)
in a text constant. (The ¶
symbol must be enclosed
within the quotation marks
of the text constant.)
"M.T.N.Trek¶Sporting
Equipment" returns
M.T.N. Trek
Sporting Equipment
City & "¶" & State returns
city and state on separate lines.