2022.2

Field Type Description
fields
Array Thefieldvaluesthatbelongtothisrecord.
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['field-
name'](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.
Inordertoloopoverrecordsinadetailtableyoucoulduseafor(...in...)loop(see"for(...in...)"on
page1174),forexample:
var records = record.tables.detail;
for (var i in records) {
var rec = records[i];
...
}
Page 1200