How to insert a table

How to insert a basic table

Basic tables are static tables formatted manually with wiki markup.

To place a table in your text, add this markup:

Markup Result
#|
||cell11|cell12|cell13||
||cell21|cell22||
|#

Other formatting options are available for basic tables:

Frameless table
Markup Result
#||
||cell11|cell12||
||cell21|cell22||
||#
CSV table
Markup Result
%%(csv delimiter=; head=1)Header 1;Header 2;Header 3
cell11;cell12;crll13
cell21;cell22;cell23
%%

Parameters:

  • delimiter – The field delimiter in CSV records in the table.

  • head – If set to “1”, the first line of the table will be highlighted as the header.

Export from Excel file
  1. Save your Excel table as CSV.

  2. Upload the file to the page and copy the link to it.

  3. Use the dynamic block {csvfile}:

    Parameters:

    • url – URL or name of the CSV file attached to the page.

    • delimiter – The field delimiter in the CSV file, ; by default.

    • enclosure – Escape symbol for fields in the CSV file, " by default.

    • head – If set to “1”, the first line of the table will be highlighted as the header.

    • enc – Encoding of the CSV file.

How to insert a dynamic table

A dynamic table is a table where you can configure column data types, sort values, or make a cell required to fill in. You can use a table directly as-is, or insert it on a page.

To insert a dynamic table onto a page:

  1. Open the table.

  2. Click </> in the sidebar.

  3. Configure the settings for inserting the table.

  4. Copy the table code and insert it in the page text.

You can edit this table directly on the page (unless Read only is selected when inserting it). All changes will be automatically applied to the main table and all its occurrences on other pages.

How to set a filter for a table

You can configure table insertion so that only certain rows are displayed. To do this:

  1. Get the code to insert the table and insert it in the page text.

  2. Add the filter parameter to the code. You will use this parameter to configure filtering for table rows:

    With this filter, only the rows that match both conditions will be displayed:

    • The [id1] column has value1.

    • The [id2] column has value2.

    To find out the column ID, go to table editing mode (Edit) and click in the column header.

How to specify values for comparison

Depending on the column data type, the values to be compared may be specified in different ways:

Data type Example Description
Text Text in single quotes
Number -7 A number with no quotes
Checkbox true

Different formats are supported.

For boolean 0: no, off, false, unchecked.

For boolean 1: yes, on, true, checked, done.

Date 2012-12-12 Date formatted as YEAR-MONTH-DAY
List Text in single quotes
Multi-select list Text in single quotes
Supported comparison operations
Operation Notation Example
Equals =, is
Not equal !=, is not
Comparison <, >, <=, >=
[13] > 50
Contains substring ~
Does not contain substring !~
From ... to ... (works with numbers and dates) between ... and ...
[13] between 100 and 1000
Equal to one of... in (...)
Not equal to any of... not in (...)

How to restrict which columns to display

You can display just the columns you need on a page. To do this:

  1. Get the code to insert the table and insert it in the page text.

  2. Add the columns parameter to your code. You will use this parameter to display only the specified columns on the page:

    This dynamic block contains only the columns with the following identifiers: id1, id2, id3.

    To find out the column ID, go to table editing mode (Edit) and click in the column header.

How to navigate to the source of an inserted table

To open the source of a table inserted on the page:

  1. Click in the bottom of the table.

  2. Choose Parent table.