Help

Table Of Contents

FILEMAKER PRO HELP 1284

Examples

Use ApplicationReceived="Y" AND FeePaid>0 if you want something to occur only if you

have received both the application AND the fee.

Use CurrentBalance≤0 OR CreditApproved="Y" if you want something to occur only if no

money is owed, OR credit has been approved, OR both are true.

Use FeePaid>0 XOR FreeGift="Y" if you want something to occur only if EITHER a fee has

been paid or a free gift has been sent, but not both (for example, if a fee has not been paid and a

free gift has been sent).

Use NOT IsEmpty(FieldName) to identify records that have a value in the FieldName field.

Related topics

About formulas

Symbol Definition

AND True only if both items are true

OR True if either item is true

XOR True if either of the expressions (but not both) is true

NOT Changes the value from False to True or from True to False

Symbol Name Definition

& Concatenate Appends the text string on the right to the end of the text

string on the left. Text strings can be fields, constants

enclosed in quotes, or certain functions.

" " Text constant Marks the beginning and the end of characters to be

considered a text constant. Quotation marks without text

between them indicate an empty value (no text). If you enter

text into a formula without using quotation marks,

FileMaker

Pro tries to interpret the text as a field or function

name.

\ Backslash Marks an operator character to be used as a character

instead of an operator.

¶ Carriage return Inserts a paragraph carriage return in the result of a formula.

/* */ C style comment Marks the beginning and the end of characters to be

considered as text comments within a formula.

// C++ style comment Identifies a single-line comment within a formula.

${ } Reserved name Identifies reserved function names and keywords used as

field names and table names.