Home > Reference > Functions reference > Design functions > FieldIDs

FieldIDs

Purpose 

Returns a list of all field IDs in fileName and layoutName, separated by carriage returns.

Format 

FieldIDs(fileName;layoutName)

Parameters 

fileName - the name of an open database file (local or remote).

layoutName - the name of a layout or table in the specified database file.

Important  See Design functions for information about literal text parameters.

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Related fields are returned as TableID::RelatedFieldID.

For example, 12::4, where 12 is the ID of the table and 4 is the ID of the related field.

If no parameter is specified for fileName, FileMaker returns results for the current file.

Examples 

FieldIDs(“Customers”;””) returns IDs of all unique fields in the default table of Customers.

FieldIDs(“Customers”;”Layout#5”) returns IDs of all unique fields, including related fields, on Layout#5 in Customers.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas