Functions Reference

136 FileMaker Functions Reference
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.
IsEmpty(Payments::DatePaid) returns 1 if, for example, the Payments table has
been moved or renamed.
IsEmpty(“text”) returns 0.