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
Was this topic helpful? Send feedback.