|
|
If adding the number or date filters, additional configuration of the data format may be required. |
If you add filters to multiple columns, you may need to apply either all or separated filtration criteria. You can set the Multi-filter operation option.
|
|
|
Look at this section if you want to remove the whole Table Filter macro from the table.
To add filters to the table:
In the Filters tab, click the Add filter button and select the column for filtration along with the filter type. You can select same columns to set different filters.
Save the macro and the page.
To remove filters from the columns click the urn icon to the right of the filter type box.
In the page view mode:
|
In the macro browser:
|
In the page view mode:
|
In the macro browser:
The app allows you to temporarily reset the defined filtration values. This may be useful when you deal with the table with multiple filters applied. Instead of clearing values for each filter, you can do this at once.
To reset filtration values:
All values in the filters are reset. If the changes are not saved, the default filtration values will be restored upon the page reload.
|
Set this option if you have some data in the top rows of a table that you don't want to be filtered.
Displays the list of unique values stored in the selected column of your table. You can select one or multiple values for data filtration in this dropdown filter.
To filter all selected values, choose OR operator in the Set dropdown filter operators option. |
To choose the way of dropdown list displaying set the Dropdown filters options updating option.
Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Settings tab.
Click the Update dropdown filter options slider to display only the unique values from the selected column available after other filters were applied.
Click the Update dropdown filter options slider again to display all the unique values from the selected column of the table.
Save the macro and the page.
You can also filter tables with @-user mentions by the current user (write or select @currentUser ).
To filter tables by the current page title, enter @pageTitle in the dropdown filter.
Allows you to specify the number range for showing data in the table. Alternatively, you can set the start or end value instead of the number range. Both cardinals and decimals are supported.
|
Allows you to filter your table by one or multiple icons, emoticons, images or checked / unchecked boxes.
Allows you to hide unnecessary table columns.
|
|