Functions Reference

46 FileMaker Functions Reference
Parameters
fileName - the name of an open database file (local or remote).
layoutName - the name of a layout or table in the specified database file.
Important See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text
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” on page 41 for information about literal text parameters.
Data type returned
text