Set Record

Sets a table record. An item must be specified for each dimension.

Permissions

Command Kind	Needed User Kind
Write	All

Parameters

Name	Type	Description	Required	Default	Values
Item	array of string	Dimension and item ([Dimension].[Item]).	yes
Table	string	Name of the table ([Table]).	yes
Add	boolean	If 'True', the new value is added to an existing one. If 'False', the new value overwrites an existing one. The default value is 'False'.	no	false
Adjust	boolean	If 'True' protected command chars are replaced: '[' becomes '(', ']' becomes ')' and '=' becomes empty. The default value is 'True'.	no	true
CreateItems	boolean	If 'True' non existing items will be created. The default value is 'False'.	no	false
DateOffset	integer	Moves the date dimension items by the offset. The default value is '0'. For example the month '2022-02' with an offset of 5 becomes '2022-07'.	no	0
Subtable	string	Name of the subtable ([Subtable]). A subtable contains additional filters used by the table.	no
Value	array of string	Sets the value of a number field ([Field Name].[123.45]) or text field ([Field Name].[Text]).	no

Result

Name	Type	Description

Code

SET RECORD
ITEM=[string, Multiple, Needed]
TABLE=[string, Needed]
ADD=[boolean, default=false]
ADJUST=[boolean, default=true]
CREATEITEMS=[boolean, default=false]
DATEOFFSET=[integer, default=0]
SUBTABLE=[string]
VALUE=[string, Multiple]