Table Filter macro is a powerful macro that allows you to filter table data in page view and edit modes and manage the look of your table data on the page.
Live Filtration
To get started, try filtering table data on the fly in table headers. Hover over table columns and click the funnel icon in one of the headers:
Activity | Campaign type | Budget | Start | End | Target audience | Icon | Priority |
---|---|---|---|---|---|---|---|
SOCIAL MEDIA | $600 | 1/1/2021 | 6/30/2021 | Partners | LOW | ||
SOCIAL MEDIA | $750 | 3/1/2021 | 9/30/2021 | Potential Clients | MEDIUM | ||
SOCIAL MEDIA | $300 | 3/1/2021 | 9/30/2021 | Potential Clients | HIGH | ||
SOCIAL MEDIA | $250 | 1/1/2021 | 12/31/2021 | Managers | HIGH | ||
Blog | ONLINE | $1,000 | 4/15/2021 | 9/15/2021 | Subject Matter Experts | HIGH | |
Website | ONLINE | $2,000 | 1/1/2021 | 3/15/2021 | C-Level | LOW | |
Email Newsletter | ONLINE | $500 | 9/1/2021 | 12/31/2021 | Managers | LOW | |
Development | WEB | $6,000 | 1/1/2021 | 12/31/2021 | Laypeople | HIGH | |
Pay-per-click | WEB | $2,000 | 1/1/2021 | 12/31/2021 | Laypeople | MEDIUM | |
SEO | WEB | $500 | 1/1/2021 | 12/31/2021 | Subject Matter Experts | LOW | |
Surveys | OTHER | $500 | 1/1/2021 | 12/31/2021 | Old clients | LOW | |
Corporate Branding | OTHER | $1,500 | 1/1/2021 | 12/31/2021 | Business | HIGH | |
Business Cards | OTHER | $500 | 1/1/2021 | 12/31/2021 | Business | MEDIUM | |
Signage | OTHER | $500 | 1/1/2021 | 12/31/2021 | Business | LOW |
Tips & Tricks
1. Try additional functionality in the page view mode. Click the funnel icon at the top right corner of the table to reach the features:
- Save changes to preserve filtration after refreshing the page
- Filter whole table to apply text filter to the whole table at once
- Hide columns to hide unnecessary columns in the page view mode
- Copy the filter URL to share the link with the predefined filtration parameters with your teammates
- Export to PDF, CSV, Word to share already filtered table
- Remove the macro to unwrap your table in the page view mode
2. Click the equal sign to search for not equal values:
3. Switch to the editor, select the macro and click Show filter to use filtration while editing your table:
Filtering with the Filtration Panel
To learn more about displaying filters on a filtration panel or additional options of table viewing and try these features live, open any of these pages:
- Managing Look of Tables
- Managing Filters on the Filtration Panel
- Filtering Text Table Data
- Filtering Number and Date Values
- Filtering Tables with Images and Icons
- Filtering Table in Page Edit Mode
- Managing Look of Filtration Pane