Reference > Functions reference > Repeating functions > GetRepetition
 
GetRepetition
Purpose 
Returns the contents of the repeating field specified by a 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 brackets [ ] as array operators. For example, ParcelBids[2] returns 1200. See Getting the contents of a repetition in a repeating field.
Related topics 
Get(CalculationRepetitionNumber) function
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas