Read more:

Apply the default sorting order to columns

You can sort one or multiple table columns in the ascending or descending order.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Table View tab.
  4. Locate the Default Sorting box.
  5. Click it and select the columns with the appropriate sorting order in them. Once you have saved the macro and the page, the defined sorting order is automatically applied to the selected columns.

If you need to apply cell formatting, please use the  FORMATWIKI function in the SQL query of Table Transformer.

Reset the sorting order

To reset the default sorting order applied in the page view mode for columns:

  1. Open the page with the table.
  2. On the filtration pane, locate and click the cogwheel icon.
  3. Select Reset column sorting.

Add automatic row numbering

The app allows you to enable either dynamic or static row numbering. You can choose one of the following options:

  • Dynamic
    • Ascending
    • Descending
  • Static
    • Ascending
    • Descending

The difference between Dynamic and Static is the following:

  • Dynamic: row numbering is updated each time you filter the table. So all the time your row numbers will look like 1, 2, 3 and so on.
  • Static: rows are numbered one time and row numbers are preserved all the time you filter the table. So after filtration your rows may be numbered like 2, 5, 6, 11 and so on.

To set the option:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Table View tab. 
  4. Locate the Row numbering type box and select the appropriate row numbering option.
  5. Save the macro and the page.

If you need to apply cell formatting, please use the  FORMATWIKI function in the SQL query of Table Transformer.

Add pagination to tables

  1. Switch the page to the edit mode.

  2. Select the macro and click Edit.

  3. Select the Table View tab.

  4. Locate the Number of rows per page

The pagination option is applied to tables both in the page view and edit mode.

If you need to apply cell formatting, please use the  FORMATWIKI function in the SQL query of Table Transformer.

Show first N rows if not filtered

This option lets you show N number of rows when you use no filtration. If you apply some filtration criteria, the set of filtered results will be expanded to show all the matches.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Select the Table View tab.
  4. Locate the 

If you need to apply cell formatting, please use the  FORMATWIKI function in the SQL query of Table Transformer.

Freeze first N rows/columns

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Table View tab.
  4. Locate the Freeze first N rows and Freeze first N columns options.
  5. Specify the correct number of rows and columns to freeze.
    For example, to freeze your report headers, set "1" in the Freeze first N rows field. And to freeze both the header row and the first row with data, set "2" in the Freeze first N rows field. The latter is handy for further comparison while scrolling long tables.
  6. Save the macro and page.
  7. Once you save the page, the table will automatically fit the available screen area or you can set the table height manually.

If you need to apply cell formatting, please use the  FORMATWIKI function in the SQL query of Table Transformer.

Hide columns

The Hide columns functionality allows you to hide unwanted columns both in the page view and page edit mode. 

To locate the option, navigate to the Filter Type menu and select it from the dropdown menu. Look here for the step-by-step guide.