Home > Reference > Functions reference > Repeating functions > GetRepetition
GetRepetition Purpose Returns the contents of the repeating field specified by number. 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 Originated in FileMaker Pro 6.0 or earlier 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 Getting the contents of a repetition in a repeating field. Related topics Functions reference (category list) Functions reference (alphabetical list) About formulas About functions Defining calculation fields Using operators in formulas