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
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 layoutName is empty, then the field IDs of the default table will be returned.
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
Was this topic helpful? Send feedback.