Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A User Manual

On the Data Entry layout in the Customers database file, 
FieldStyle(“Customers”;“Data Entry”;“Current Customer”) returns 

 when the Current Customer field is formatted as a radio button 

and is associated with the value list named Yes/No List.

FieldType(fileName;fieldName)

fileName - the name of an open 

 (local or remote).

fieldName - the name of a 

 in the specified database file.

See “Design functions” on page 41 for information about literal text parameters.

text

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 

: text, number, date, time, timestamp, or 

•

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 

, this value is 1).

FieldType(“Customers”;“Phone Number”) returns 

, 

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 

 when a find is performed in that field.)

FieldType(“Customers”;“Current Balance”) returns 

, 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 

, 

when, in the Customers database file, the Today’s Date field is defined as a 

 of 

type date. Global fields are never indexed.