Reference > Functions reference > Design functions > FieldIDs


Returns a list of all field IDs in fileName and layoutName.


FieldIDs ( fileName ; layoutName )


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

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

Data type returned 


Originated in 

FileMaker Pro 6.0 or earlier


Listed items are separated by carriage returns.

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.

Example 1 

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

Example 2 

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