Functions Reference

Table Of Contents

FILEMAKER FUNCTIONS REFERENCE 49

Important See Design functions for information about literal text parameters.

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, 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 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.