2022.1

Field Type Description
id
Number The id of this record.
index
Number The one-based index of this record, or zero if no
data is available.
<tableName>
Array of
records
Shortcut to access a table in the tables array. For
example, you can use record.Products to access
record.tables.Products.
tables
Array The detail tables that belong to this record.
Accessing fields and tables
You can access a specific field value:
l using the field's name: record.fieldName (case sensitive)
l via the fields array, by name: record.fields.fieldname or record.fields['fieldname']
(case insensitive)
If there is no field with the specified name, record.fields.fieldname returns an empty string,
whereas record.fieldname will return undefined (unless there is a table with the same name,
in which case the table is returned).
A detail table can be accessed using its name: record.tableName, or via the tables array.
Either way the table name should be followed by a numeric index for a record in that detail
table.
For example, to access the value of the field "prod_id" in the first record of a detail table called
"detail", you can use:
record.detail[0].fields.prod_id or
record.tables["detail"][0].fields.prod_id or
record.tables.detail[0].fields.prod_id or
record.detail[0].prod_id.
If there is no table (and no field) with the specified name, record.tableName results in
undefined.
Page 1382