Functions Reference

40 FileMaker Functions Reference
Description
Returns a list of the names of all fields on layoutName, in fileName file, separated by
carriage returns. Related fields are displayed in tablename::fieldname format.
If layoutName isn’t specified, then the field names of the first table created (the “default
table”) will be returned.
Note If FieldNames returns a question mark (?) or the name of only one field, go to the
Specify Calculation dialog box and make sure the Calculation result is text. Also, you
can increase the size of the field on the layout to show more field names.
Examples
FieldNames(“Customers”;””) returns a list of all the fields in the default table of the
Customers database file.
FieldNames(“Customers”;“Data Entry”) returns a list of all the fields, including
related fields, in the Customers database file that appear on the Data Entry layout.
FieldRepetitions
Format
FieldRepetitions(fileName;layoutName;fieldName)
Parameters
fileName - the name of an open database file (local or remote).
layoutName - the name of a layout in the specified database file.
fieldName - the name of a field on the specified layout.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns the number of repetitions of the repeating field
fieldName as it is currently
formatted on layoutName (which could be different from the number of repetitions when
the field was defined), and the orientation of the field repetitions (horizontal or vertical) on
the layout. If fieldName isn’t a repeating field, it returns 1 vertical.
Example
FieldRepetitions(“Customers”;“Data Entry”;“Business Phone”) returns
3 vertical if the Business Phone field is defined as a repeating field with five repetitions
but is formatted to only show three repetitions in a vertical orientation on the Data Entry
layout.