Syntax: FieldRepetitions ( fileName; layoutName; fieldName )
fileNameThe name of the open file where the field to be referenced is located.
layoutNameThe name of the layout where the field to be referenced is located.
fieldNameThe name of the field for which to return repetition information.
Data type returned: Text
Returns a space-delimited text string that indicates the number of repetitions and orientation of the field in question. Note that you must pass a layout name. (A table name does not work.) The data is returned in the format of "NumRepetitions Orienation."
The MiddleWords() function can be used to extract either component of the result.
If literal names of objects are used, calls to the function may be broken when file or object names are changed. Functions such as Get(FileName), LayoutNames(), and FieldNames() can be used to dynamically return information about a database. Also remember that only the number of repetitions that appear on the layout are returned, not the number of repetitions defined in Define Database. Use FieldType() to return the number of repetitions specified in Define Database.
FieldRepetitions ( Get ( FileName ); "Invoice_Detail"; "Payment_History" )
Might return a string like 10 vertical.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
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