Functions Reference

FILEMAKER FUNCTIONS REFERENCE 175
GetNthRecord(Contacts::First Name;2) returns the contents of the First Name field for
record 2 in the Contacts table.
GetNthRecord(Contacts::Has Repetitions[2];2) returns the contents of the second
repetition of the Has Repetitions field for record 2 in the Contacts table.
Related topics
Contents
Functions reference (alphabetical list)
If
Purpose
Returns one of two possible results (result1 or result2) depending on the value of test.
Format
If(test;result1;result2)
Parameters
test - any numeric value or logical expression
result1 - expression or field name
result2 - expression or field name
Data type returned
text, number, date, time, timestamp, container
Originated in
FileMaker Pro 6.0 or earlier
Description
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, If 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.