Embedding dynamic tables

You can use blocks to embed dynamic tables on your page and configure them.

Using the block

{{grid page="tableAddress"}}

You can edit dynamic tables right on the page where they're embedded. All changes are automatically applied to the main table and all its occurrences on other pages.

Block parameters

page

The address of the table you want to embed.

width

Optional parameter. The table's width as a percentage of the page's width:

{{grid page="tableAddress" width="60%"}}

readonly

Optional parameter. If specified, the table is embedded in “read-only mode”.

num

Optional parameter. If specified, the table row numbers aren't displayed.

sort

Optional parameter. If specified, the sorting settings of the original table don't affect other tables.

filter

Optional parameter. Use it to set filters for displaying table rows.

columns

Optional parameter. Sets which columns to display on the page.

Setting filters for displaying rows

Use the filter parameter to set which rows should be displayed in the embedded table. Example:

{{grid page="tableAdress" filter="[id1]=value1, [id2]=value2"}}

This filter will only display rows that meet all the following criteria:

The column with the ID [id1] has the value value1.
The column with the ID [id2] has the value value2.

To find a column's ID, switch to table editing mode (Edit) and click the ≡ icon in the header of the corresponding column.

Specifying comparison values

There are multiple ways to choose values for comparison based on the table's data type:


Data type	Example	Description
Text	`'Bike'`	Text in single quotes
Number	`-7`	Number without quotes
Checkbox	`true`	Values have multiple optional variants. Boolean \"false\" value: `no, off, false, unchecked`. Boolean \"true\" value: `yes, on, true, checked, done`.
Date	2012-12-12	Date in the YYYY-MM-DD format
List	`'Bike'`	Text in single quotes
Multi-select list	`'Bike'`	Text in single quotes


Data type	Example	Description
Text	`'Bike'`	Text in single quotes
Number	`-7`	Number without quotes
Checkbox	`true`	Values have multiple optional variants. Boolean \"false\" value: `no, off, false, unchecked`. Boolean \"true\" value: `yes, on, true, checked, done`.
Date	2012-12-12	Date in the YYYY-MM-DD format
List	`'Bike'`	Text in single quotes
Multi-select list	`'Bike'`	Text in single quotes

Supported comparison operations


Operation	Operator	Example
Equal to	`=`, `is`	`[13] is 'Bike'`
Not equal to	`!=`, `is not`	`[13] is not 'Bike'`
Comparison	`<`, `>`, `<=`, `>=`	`[13] > 50`
Contains substring	`~`	`[13] ~ 'Bi'`
No substring	`!~`	`[13] !~ 'Bi'`
Value from ... to ... (works with numbers and dates)	`between ... and ...`	`[13] between 100 and 1000`
Equal to either of ...	`in (...)`	`[13] in ('Bike', 'motorcycle', 'helicopter')`
Not equal to either of ...	`not in (...)`	`[13] not in ('submarine', 'spaceship')`


Operation	Operator	Example
Equal to	`=`, `is`	`[13] is 'Bike'`
Not equal to	`!=`, `is not`	`[13] is not 'Bike'`
Comparison	`<`, `>`, `<=`, `>=`	`[13] > 50`
Contains substring	`~`	`[13] ~ 'Bi'`
No substring	`!~`	`[13] !~ 'Bi'`
Value from ... to ... (works with numbers and dates)	`between ... and ...`	`[13] between 100 and 1000`
Equal to either of ...	`in (...)`	`[13] in ('Bike', 'motorcycle', 'helicopter')`
Not equal to either of ...	`not in (...)`	`[13] not in ('submarine', 'spaceship')`

Choosing columns to display

You can choose to only display specific columns from your dynamic table. To do this:

Get an embed code and place it in the page text.
Add the columns parameter to your code in order to display only the specified columns:
```
{{grid page="linkToTheTable" columns="id1, id2, id3"}}
```
This type of dynamic block only includes columns with IDs: id1, id2, id3.

To find a column's ID, switch to table editing mode (Edit) and click the ≡ icon in the header of the corresponding column.

Contact support