Functions Reference

FILEMAKER FUNCTIONS REFERENCE 45
Examples
FieldComment("Customers"; "Phone Number") returns “Customer's home telephone
number” if it was entered as a comment for the Phone Number field.
FieldComment("Customers"; "Accounts::Current Balance") returns “Customer's
current balance” if it was entered as a comment for the Current Balance field in the Accounts table.
Related topics
Contents
Functions reference (alphabetical list)
FieldIDs
Purpose
Returns a list of all field IDs in fileName and layoutName, separated by carriage returns.
Format
FieldIDs(fileName;layoutName)
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 for information about literal text parameters.
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Related fields are returned as TableID::RelatedFieldID.
For example, 12::4, where 12 is the ID of the table and 4 is the ID of the related field.
If layoutName is empty, then the field IDs of the default table will be returned.
Examples
FieldIDs(“Customers”;””) returns IDs of all unique fields in the default table of Customers.
FieldIDs(“Customers”;”Layout#5”) returns IDs of all unique fields, including related fields,
on Layout#5 in Customers.
Related topics
Contents
Functions reference (alphabetical list)