Functions Reference

42 FileMaker Functions Reference
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns information about fieldName. Field names must be in the form
tablename::fieldname to specify a field that exists in a table different from the current
table. The result has four values separated by spaces:
• The first value is either Standard, StoredCalc, Summary, UnstoredCalc, or Global.
• The second value is the field type: text, number, date, time, timestamp, or container.
• The third value is Indexed or Unindexed.
• The fourth value is the maximum number of repetitions defined for the field (if the field
isn’t defined as a repeating field, this value is 1).
Examples
FieldType(“Customers”;“Phone Number”) returns Standard Text Unindexed 3,
when, in the Customers database file, the Phone Number field is defined as a text field
that repeats a maximum of 3 times and the storage options are left unchanged. (Most
fields are indexed when a find is performed in that field.)
FieldType(“Customers”;“Current Balance”) returns StoredCalc Number
Indexed 1, when, in the Customers database file, the Current Balance field is defined as
a stored, numeric calculation field that is indexed.
FieldType(“Customers”;“Today’s Date”) returns Global Date Unindexed 1,
when, in the Customers database file, the Today’s Date field is defined as a global field of
type date. Global fields are never indexed.
GetNextSerialValue
Format
GetNextSerialValue(fileName;fieldName)
Parameters
fileName - the name of an open database file (local or remote).
fieldName - the name of the field whose next serial number you want to determine.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text