Functions Reference

150 FileMaker Functions Reference
GetRepetition
Format
GetRepetition(repeatingField;number)
Parameters
repeatingField - any repeating field, or an expression that returns a reference to a
repeating field.
number - the field repetition number.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the contents of the repeating field specified by number.
Examples
ParcelBids is a field defined to repeat with ten values and contains the values 2500, 1200,
and 1500.
GetRepetition(ParcelBids;2) returns 1200.
GetRepetition(if(IsEmpty(ParcelBids) ≠ true, ParcelBids,
HouseBids);2) returns 1200.
GetRepetition(ParcelBids;5) returns nothing.
Note You can also find the contents of a particular repetition in a repeating field using
square brackets [ ] as array operators. For example, ParcelBids[2] returns 1200. See
FileMaker Pro Help.
Last
Format
Last(field)
Parameter
field - any repeating field or related field, or an expression that returns a reference to a
repeating field
or related field.
Data type returned
text, number, date, time, timestamp, container