Cell types

A cell can be of any of the following types:

Boolean

Values of true or false:

Number

Any integer or float

String

Anything else that is not a Boolean or a String:

The No-Code engine tries always to disambiguate the expression entered. However, sometimes, a string can contain certain characters that can generate interpretation conflicts. For example, if in an executable table we write:

The output will be:

sku1: Undeclared {id: "SKU123"}
sku2: -123

We can see that both sku1, and sku2 have unexpected values. In the first case, sku1 is assigned to an undeclared variable SKU123 instead of the string SKU123. In the second case, sku2 is assigned the value -123, because the engine interprets that SKU is a variable with value 0.

In order to disambiguate in these situations, we only have to enclose the string in simple quotes:

In this case, the output will be:

sku1: 'SKU123'
sku2: 'SKU-123'

Note that ambiguities can only occur in executable tables, where cells are interpreted. In data tables, we won't have this kind of problem.

Group

A group is a key-value object.

List

A list is a collection of elements.