---
metadata:
- name: generator
content: Diplodoc Platform v5.46.1
alternate:
- https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com.tr/support/wiki/en/llms.txt
# Dynamic table
{% note info "" %}
Here you'll learn how to work with the [new Wiki editor](https://yandex.com.tr/support/wiki/en/pages-types.md#new-editor). For information on how to create and edit tables, see [Dynamic tables (old editor)](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md).
{% endnote %}
[Dynamic tables](https://yandex.com.tr/support/wiki/en/pages-types.md#grid) are tables where you can specify column data type, sort values, or make cells required for filling in. You can create a new table on your page or [embed an existing one](#embed).
Embedded tables can be edited right on Wiki pages, unless you selected **Read-only** when copying the table code. All changes are automatically applied to the main table and any of its occurrences on other pages.
A single table can have no more than 1000 rows and 300 columns.
## Creating a dynamic table {#add}
1. Open a page or [create a new one](https://yandex.com.tr/support/wiki/en/create-page.md).
1. In the visual editor, click → **Dynamic table** on the toolbar.
This will add the table to the page. If you switch to markup mode, you'll see the [table code](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md#embed) in the text.
The created table becomes a [resource of the current page](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md#go-to-source).
1. To edit the table header, click it and enter a new title.
1. Add columns to the table and [configure their parameters](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md#column-params).
1. [Fill out the table](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md#edit-cell).
### Copying a dynamic table {#copy}
To create a copy of a dynamic table:
1. Click **Table settings** and select **Create copy**.
1. Enter a name for the table copy.
1. The URL for the copied table is generated automatically. You can edit it if you want.
1. Select the cluster where you want to place the table copy.
1. To copy the table along with its contents, select **Copy with content**.
1. Click **Copy**.
{% note warning "" %}
If you select and copy a table in the visual editor or its embed code in Markup mode, you'll only copy a link to the original table with its ID. In this case, all changes to the embedded table automatically will apply to the source table and vice versa.
{% endnote %}
### Importing data to a table {#import}
You can create a table from an existing `CSV` or `TXT` file. For more information, see [Importing a page from a file](https://yandex.com.tr/support/wiki/en/import-page.md#dynamic-table).
## Editing a table {#edit-grid}
#### Editing cell contents {#edit-cell}
* Click in the selected cell and enter a value. The row height depends on the content of the cell where the largest value is written.
* Use the [Markdown markup](https://yandex.com.tr/support/wiki/en/wysiwyg/text-format.md) to format text.
* To switch to a new row in a cell, press the **Shift** + **Enter** hotkey.
* To open an input field in a separate window, click .
* To save the changes, exit the cell editing window. This saves the changes automatically.
#### Setting up table columns {#column-params}
To add a column:
1. In the top right corner, click .
1. Specify the column parameters:
* Enter the column **header** in the top field.
* The **Unique ID** field will be filled in automatically. You can edit it manually, if required.
* Select a type of data to display in the column from the drop-down list. After you save the settings, you will not be able to edit the data type.
{% cut "Available data types"%}
* **Formatted text**. Any text formatted by [Markdown](https://yandex.com.tr/support/wiki/en/wysiwyg/text-format.md).
* **Number**.
* **Checkbox**. Field with a checkbox. To mark an entire row, enable the **Mark as done** option. In this case, the checked rows will appear gray.
* **Date**.
* **List**. Field to select one value from a list of suggested options.
To select a multiple-choice list, enable the **Allow multiple options** option.
* **Employee**. Employee's first and last name.
To select multiple employees, enable the **Allow multiple users** option.
* **Issue in Tracker**. The key of the issue that will function as a link in Tracker.
* **Issue parameters**. Parameters displayed for the **Tracker issue** data type.
{% endcut %}
* In the **Width** field, set the column width or leave the default `Auto` value.
* To enter a column description, click **Add description**. To view the column description, hover over the icon. Its text will appear in the pop-up window.
* To turn cells into required, enable the **Required** option.
* For columns with the **Checkbox** data type, enable the **Mark as done** option. In this case, the checked rows will appear gray.
1. Click **Add** to save your changes.
1. To change the column parameters, click in the first cell of the column and select **Settings**.
1. To change the column width, move the side border to the left or right. The change in width will be immediately displayed to all users who are currently viewing the table.
#### Changing the column order {#column-transfer}
1. In the top right corner, click .
1. Select **Configure columns** in the table settings.
1. Select the column name in the list, click , and drag it. You cannot select multiple columns to move.
#### Deleting a column {#del-column}
1. Click in a column's first cell.
1. Click **Delete**.
#### Adding and deleting rows {#edit-line}
* To create a new row, click **Add row** at the bottom of the table.
* To delete a row, hover over it and click **Delete row**.
#### Importing data to a table {#import}
You can add data from a CSV or TXT file to a table: For more information, see [Adding data to a dynamic table](https://yandex.com.tr/support/wiki/en/import-page.md#table).
#### Highlighting in color {#highlight}
1. Click in the column header or next to the right edge of the row.
1. In the menu, hover over **Choose color** and click the preferred sample.
#### Renaming a table {#rename-tab}
To rename a table, click the table name and enter a new one.
#### Restricting editing for a table {#readonly}
You can apply the `readonly` parameter to prevent users from editing the table. In markup mode, add the `readonly` parameter to the code and specify a value of `1`.
```
{% wgrid id="88812dba-0e72-48bf-bd68-1b2e1534b5e0" readonly="1" %}
```
To remove this restriction, specify `0`.
#### Showing row numbers {#num}
You can use the `num` parameter to display the row numbers of the table. In markup mode, add the `num` parameter to the code and specify a value of `1`.
```
{% wgrid id="88812dba-0e72-48bf-bd68-1b2e1534b5e0" num="1" %}
```
To hide row numbers, specify `0`.
## Embedding an existing table {#embed}
You can embed a dynamic table in an existing page. In this case, all changes to the embedded table automatically will apply to the source table and vice versa.
1. Open the page with the table.
1. In the top right corner, click **Table settings**.
1. Select **Share**.
1. Configure the [parameters](#tab-params) for embedding the table.
If the table was created in the old version of the Wiki editor, you can use the **WYSIWYG markup** parameter:
* If the option is disabled, the code for embedding the table into an old format page will be generated, for example, `{{ grid page="/users/username/page-with-table" }}`.
* If the option is enabled, the code for embedding the table into a new format page will be generated, for example, `{% wgrid id="112233" %}`.
1. Copy the table code using the button.
1. Paste the code into the page text.
#### Restricting editing of the source table {#restrict}
If you add a dynamic table by linking from another page, users without access to that source page won't be able to view the table. [Learn more about access settings.](https://yandex.com.tr/support/wiki/en/page-management/access-type.md)
To restrict editing of a source dynamic table:
1. Open the page where the table is added as a resource.
1. In the top right corner, click **Actions** → **Settings** → **Access rights** and select **Only its authors can edit the page**.
1. When embedding a dynamic table on other pages, enable **Read-only**.
{% note info "" %}
If you have access to the page where the dynamic table is added as a resource, you can [open the source page](#go-to-source) to edit the embedded table.
{% endnote %}
#### Table embed parameters {#tab-params}
You can set parameters for a table during the embedding process or change its code in markup mode.
Sample table code:
```
{% wgrid id="67b29081-ab1e-4ec7-a5b8-8511025f250a" num="0" sort="0" readonly="1" %}
```
| Parameter code | Description |
--- | ---
| `Id` | Required parameter. Present by default. ID of the table that you want to add to the page. |
| `readonly` | If specified, the table is embedded in [read-only mode](#readonly). |
| `num` | If specified, [the table's row numbers are displayed](#num). Enabled by default. |
| `sort` | If specified, the [sorting settings](#sort-line) of the source table are ignored. Enabled by default. |
| `filters` | Use it to set [filters for displaying table rows](#row-filter). |
| `columns` | Use it to [set columns to display on the page](#col-filter). |
{% note info "" %}
The `num` and `sort` parameters are enabled by default and aren't shown in the code when the table is copied. Their default value is `1`.
{% endnote %}
#### Jumping to the parent table {#go-to-source}
To open the original table embedded in the page:
1. In the top right corner, click **Table settings**.
1. Choose **Parent table**.
This opens the page where the table is listed among the page resources. To see a full list of page resources, click **Actions** in the top right corner and select **Page resources**.
#### Choosing columns for display {#col-filter}
You can use the `columns` parameter to only display the specified columns of the dynamic table on the page. In markup mode, add the `columns` parameter to the code and specify the IDs of the required columns.
```
{% wgrid id="88812dba-0e72-48bf-bd68-1b2e1534b5e0" columns="name, description, properties" %}
```
To find out the column ID:
* Click in the column header.
* Select **Settings** → **Unique ID**.
#### Setting filters for displaying rows {#row-filter}
Use the `filter` parameter to set which rows should be displayed in the embedded table. For example:
```
{% wgrid id="88812dba-0e72-48bf-bd68-1b2e1534b5e0" filter="[name]=, [description]=" %}
```
This filter will only display the rows for which the following conditions are met at the same time:
- Column with the `name` ID is set to ``.
- Column with the `description` ID is set to ``.
To find out the column ID:
* Click in the column header.
* Select **Settings** → **Unique ID**.
To output all rows that meet at least one of the specified conditions, use the `OR` operator.
{% cut "Setting values to compare" %}
Depending on the column data type, values to compare are specified in different ways:
| **Data type** | **Example** | **Description** |
--- | --- | ---
| Text | `'bicycle'` | Text in single quotes |
| Number | `-7` | Number without quotes |
| Checkbox | `true` | Different write formats are supported.
For logical 0: `no, off, false, unchecked`.
For logical 1: `yes, on, true, checked, done`. |
| Date | `2012-12-12` | Date in `YEAR-MONTH-DAY` format |
| List | `'bicycle'` | Text in single quotes |
| Multiple-choice list | `'bicycle'` | Text in single quotes |
| Employee | `login@` | Employee's username without quotes |
| Issue in Tracker | `KEY-1234` | Tracker issue key without quotes |
{% endcut %}
{% cut "Supported comparison operators" %}
| Operation | Writes | Example |
--- | --- | ---
| Equal to | `=`, `is` | `[vehicle] is 'bicycle'` |
| Not equal to | `!=`, `is not` | `[vehicle] is not 'bicycle'` |
| Comparison | `<`, `>`, `<=`, `>=` | `[count] > 50 ` |
| Contains a substring | `~` | `[vehicle] ~ 'bi'` |
| Contains no substring | `!~` | `[vehicle] !~ 'bi'` |
| In the interval from ... to ... (handles numbers and dates) | `between ... and ...` | `[count] between 100 and 1000` |
| Equal to any of ... | `in (...)` | `[vehicle] in ('bicycle', 'motorcycle', 'helicopter')` |
| Not equal to any of ... | `not in (...)` | `[vehicle] not in ('submarine', 'spaceship')` |
{% endcut %}
## Sorting table rows {#sort-line}
#### When viewing a table
You can change the sorting order when viewing a table. To do this, click in the first cell of the column and select **Sort in descending order** or **Sort in ascending order**.
{% note info "" %}
This sorting order is available only if sorting isn't disabled by the [embed parameters](#tab-params).
{% endnote %}
#### Default sorting
To set up the default sorting order:
1. In the top right corner above the table, click **Sorting**. The **Table settings** panel appears on the right.
1. On the **Table settings** panel, select **Sort** → **Add**.
1. In the drop-down list, select a column and sorting type: **Sort in descending order** or **Sort in ascending order**.
1. Click **Save**. The **Sorting** button in the top right corner above the table will be highlighted in blue.
You can use the **Add** button to select multiple columns and set their sorting order. To do this, in the list of sorting conditions on the **Table settings** panel, click and drag . You can't drag multiple sorting conditions at the same time.
To remove all sorting conditions, on the **Table settings** panel, click **Reset**, then **Save**.
## Downloading a table {#download}
1. Click **Table settings**.
1. Select **Download Table** and select the required format.
## Sharing a table {#share}
1. Click **Table settings**.
1. Select **Share** and click **Copy**. The table link will be copied to your clipboard.