Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Product codes
TG761Z/A
Page of 238
46     FileMaker Functions Reference
Parameters
fileName - the name of an open 
 (local or remote).
 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 
 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 
 (local or remote).
fieldName - the name of a 
 on the specified layout.
Important  
See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text