Reference > Functions reference > Repeating functions > GetRepetition
 

GetRepetition

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

Notes 

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.

Example 1 

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.

Related topics 

Get(CalculationRepetitionNumber) function

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas