Reference > Functions reference > Get functions > Get(CalculationRepetitionNumber)

Get(CalculationRepetitionNumber)

Returns a number representing the repetition of the calculation field being calculated.

Format

Get(CalculationRepetitionNumber)

Parameters

None

Data type returned

number

Originated in

FileMaker Pro 7.0

Description

The first repetition returned is 1. If the current field isn’t a repeating field, the function returns 1.

Example 1

Returns 5 when FileMaker Pro Advanced is calculating the fifth repetition of a repeating field.

Example 2

As the field definition for Timer::Reminder (a calculation field with five repetitions), calculates future times based on the contents of Timer::Start Time (a time field) and Timer::Snooze Minutes (a number field):

Time ( Hour ( Extend ( Timer::Start Time ) ) ; Minute ( Extend ( Timer::Start Time ) ) + ( Extend ( Timer::Snooze Minutes ) * Get ( CalculationRepetitionNumber ) ) ; Seconds ( Extend ( Timer::Start Time ) ) )

In this example, the Extend function allows a non-repeating field to be used in every repetition of a repeating field.

When Timer::Start Time contains "12:00:00" and Timer::Snooze Minutes contains "6":

•Timer::Reminder[1] returns 12:06:00

•Timer::Reminder[2] returns 12:12:00

•Timer::Reminder[3] returns 12:18:00

•Timer::Reminder[4] returns 12:24:00

•Timer::Reminder[5] returns 12:30:00