Functions Reference

Get functions
F
ILEMAKER FUNCTIONS REFERENCE 121
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