TableStore is a textual data structure in JSON format representing the state of a dynamic table embedded on a PlusWorkflow system form. Together with the provided functions it allows you to easily manipulate data within a table and move data between tables.
Save TableStore in variables
Due to the large size of "TableStore" objects (often exceeding 4,000 characters), it is recommended to store the TableStore in form parameters, which have an unlimited size compared to "ordinary" form variables.
TableStore structure
A valid TableStore object must contain two fields:
- variableType - JSON Object (key-value object), containing the definition of the fields of the TableStore object. The keys are IDs and the values are the types of variables that make up the table, the state of which is to be reflected by the TableStore object,
- data - JSON Array (an array of key-value objects), containing JSON objects representing individual rows of the table, where the key is the ID of the variable and the value is the value of the variable in the table row.
Field types
The fields of the TableStore object take the same types as the variables that make up the table whose state is represented. Possible types are: date, float, integer, string.
Default values of variables
| Variable type | Default value |
|---|---|
| date | null |
| float | 0.0 |
| integer | 0 |
| string | "" (empty string) |
Example
The above table will be presented as:
TableStore
{"variableType":{"tekstowy":"string","datowy":"date","zmiennoprzecinkowy":"float","calkowity":"integer"},"data":[{"tekstowy":"przykładowy tekest","datowy":"2021-03-01","zmiennoprzecinkowy":123.13,"calkowity":123},{"tekstowy":"","datowy":null,"zmiennoprzecinkowy":0.0,"calkowity":0},{"tekstowy":"przykładowy tekst 2","datowy":"2021-03-15","zmiennoprzecinkowy":321.12,"calkowity":321}]}