addRow(record)

This method of the table object adds a record to an existing detail table (see table). The detail table must already exist in the data model, otherwise the call fails.

The call returns the index of the newly added record.

record

The optional record parameter is a JavaScript object that contains one or more fields specified in the Data Model for this detail table.
The record parameter may contain a subset of the fields in the Data Model. Only the fields included in the record parameter are updated in the database, while the contents of all other fields remain unchanged.
The call fails if the parameter is omitted or empty, if any of the fields specified in the record doesn't exist in the Data Model, or if a value cannot be converted to the data type that is expected in a field.

About data types

Where possible, values are automatically converted into the data type of the respective data field.

Note: Dates must be passed as a Date object to allow them to be extracted into a Date field. See Date in the Mozilla help files.

Passing an improper data type triggers an error. For instance the following objects are all invalid:

{ myBoolean : "true" } - The myBoolean field is boolean and expects a boolean, not a string

{ myDate : "2021-03-29" } - The myDate field is a date and expects a Date object: myDate: new Date(2021,2,29), not a string

{ myPageCount : 2.5 } - The myPageCount field is an integer and expects a number without any decimals

{ myPrice : "19.99" } - The myPrice field is a currency and expects a number value, not a string

Example

This script adds an empty row to a detail table called 'myDescriptions'.

row = record.tables.myDescriptions.addRow();