Functions Reference

Table Of Contents
38 FileMaker Functions Reference
Example
FieldBounds(“Customers”;“Layout #1”;“Field”) returns 36 48 295 65 0 in the
example below. Notice that all parameters are enclosed in quotation marks.
FieldComment
Format
FieldComment(fileName;fieldName)
Parameters
fileName - the name of an open database file (local or remote).
fieldName - the name of a field in the specified database file.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns the specified field’s comment. The field name must be in the form
tablename::fieldname to specify a field that exists in a table different from the current
table.
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.
36
295
48 65