Category: Get
Syntax: Get ( CalculationRepetitionNumber ) |
Parameters: None
Data type returned: Number
Description:
Returns the current repetition number of a calculation field. If the calculation is not set to allow more than one value, Get (CalculationRepetitionNumber) returns 1.
Get (CalculationRepetitionNumber) is nothing more than the repetition number.
You can use the repetition number in conditional tests involving repeating fields. For instance, the following formula
If (Get (CalculationRepetitionNumber) < 4; "foo"; "boo")
returns a repeating calculation field with values foo, foo, foo, boo, boo, and so on.
Examples:
Function |
Results |
---|---|
Get ( CalculationRepetitionNumber ) |
Returns 1 in the first repetition of a repeating field, 2 in the second repetition, and so on, up to the maximum number of repetitions the field has been defined to hold. |
A calculation field defined to hold five repetitions and has the following formula
Get (CalculationRepetitionNumber) ^ 2
returns the repetition values 1, 4, 9, 16, 25.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information