Skip to content

Create Tablecalculation

Creates a tablecalculation.

Permissions

Command KindNeeded User Kind
WriteAll

Parameters

NameTypeDescriptionRequiredDefaultValues
TablestringName of the table ([Table]).yes
TablecalculationstringName of the tablecalculation ([Tablecalculation]).yes
Caption1stringCaption 1no
Caption2stringCaption 2no
Caption3stringCaption 3no
Caption4stringCaption 4no
Caption5stringCaption 5no
Caption6stringCaption 6no
Caption7stringCaption 7no
Caption8stringCaption 8no
Caption9stringCaption 9no
Caption10stringCaption 10no
Fieldarray of stringName of the tablecalculation field ([Field]). A tablecalculation is a visual script which is added to queries (e.g. consolidations) by the server. The groups/fields to be calculated by the visual script must be defined. These fields must also be present in the query.no

Result

NameTypeDescription
TablecalculationstringName of the tablecalculation.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
FieldsstringNumber of custom fields of the tablecalculation.

Code

text
CREATE TABLECALCULATION
TABLE=[string, Needed]
TABLECALCULATION=[string, Needed]
CAPTION1=[string]
CAPTION2=[string]
CAPTION3=[string]
CAPTION4=[string]
CAPTION5=[string]
CAPTION6=[string]
CAPTION7=[string]
CAPTION8=[string]
CAPTION9=[string]
CAPTION10=[string]
FIELD=[string, Multiple]