AppRecord Add() Method

(SBM On-Premise/PaaS only) Adds a new row to a table.

Function Signature

 int Add()


Parameter Type Description



Type Description


The TS_ID of the record added, which is unique to this table. Zero means the record could not be added due to an error.

Technical Details

SBM ModScript version: 11.3.


var tableId = Ext.TableId("TS_CONTACTS");
var myRecord = Ext.CreateAppRecord(tableId);
var myRecord.SetFieldValue("CONTACTLASTNAME", "Smith");
var ret = myRecord.Add();
if (ret == 0){
  Ext.LogErrorMsg("Error adding Contact.");


After creating an AppRecord from the desired table and setting any desired field values, use this method to add the record as a new row in its table. This is not for use with Primary tables, because those items must go through a Submit transition. However, it is possible to make a copy of a Primary table item using this method.

Note: Changes to cached items written with the Add() method are not immediately available to other SBM servers that are connected to the same database. The other servers see these changes when the cache periodically synchronizes with the database. The time interval for cache updates can be configured and defaults to twenty seconds.

Related Topics