FieldType
Purpose
Returns information about fieldName.
Format
FieldType(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.
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Field names must be in the format 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, External(Secure), External(Open), or Global.
•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 three 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.
FieldType(“Customers”;”Statement”) returns
External(Secure) Container Unindexed 1 when, in the Customers database file, the Statement field is defined as a
container field that stores data externally using secure storage. Container fields cannot be indexed.
Related topics