User manual

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