Get(CalculationRepetitionNumber)
Purpose
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 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 ) ) )
Note 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
Related topics