Category: Design

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

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 © 2008-2020.
If you may any questions please contact us: