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.
Note  For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
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 
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.