Get(CalculationRepetitionNumber)

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



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net