Functions Reference

Data type returned
text, number, date, time, timestamp, container
Description
Returns one of two possible results depending on the value of test. If test is True (any
non-zero numeric result), FileMaker Pro returns result1. If test is False (0), result2
is returned. Test must be an expression that returns either a numeric or Boolean (True,
False) result.
Notes
• If you have more than two possible results, consider using the Case function.
• By default, if test refers to a field that doesn’t yet contain a value, the If function
returns an empty result. To override this functionality, deselect the Do not evaluate if
all referenced fields are empty checkbox.
Examples
If(Country = “USA”;“US Tech Support”;“International Tech Support”)
returns International Tech Support, if the Country field contains France or Japan.
Returns US Tech Support if the Country field contains USA.
If(State =”CA”;Subtotal * CA Tax Rate;0) returns the tax if the purchaser is
a resident of California, otherwise returns 0.
IsEmpty
Format
IsEmpty(field)
Parameter
field - any field name, text expression, or numeric expression
Data type returned
number
Description
Returns True(1) if field is empty, if a related field, related table, relationship, or file is
missing, or if some other error occurs; otherwise returns False(0).
Examples
IsEmpty(OrderNum) returns 1 if the OrderNum field is empty.
If(IsEmpty(LastName);“Invalid record”;““) displays Invalid Record if the
LastName field is blank, but displays nothing if there is an entry in LastName.