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.

flat

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:

false150Table headeryy-mm-dd1612853872469IconIcon0

Activity	Campaign type	Budget	Start	End	Target audience	Priority
Twitter	Redsocial media	$600	1/1/2021	6/30/2021	Partners	trueGreenlow
Facebook	Redsocial media	$750	3/1/2021	9/30/2021	Potential Clients	trueYellowmedium
Instagram	Redsocial media	$300	3/1/2021	9/30/2021	Potential Clients	trueRedhigh
LinkedIn	Redsocial media	$250	1/1/2021	12/31/2021	Managers	trueRedhigh
Blog	Yellowonline	$1,000	4/15/2021	9/15/2021	Subject Matter Experts	trueRedhigh
Website	Yellowonline	$2,000	1/1/2021	3/15/2021	C-Level	trueGreenlow
Email Newsletter	Yellowonline	$500	9/1/2021	12/31/2021	Managers	trueGreenlow
Development	Blueweb	$6,000	1/1/2021	12/31/2021	Laypeople	trueRedhigh
Pay-per-click	Blueweb	$2,000	1/1/2021	12/31/2021	Laypeople	trueYellowmedium
SEO	Blueweb	$500	1/1/2021	12/31/2021	Subject Matter Experts	trueGreenlow
Surveys	other	$500	1/1/2021	12/31/2021	Old clients	trueGreenlow
Corporate Branding	other	$1,500	1/1/2021	12/31/2021	Business	trueRedhigh
Business Cards	other	$500	1/1/2021	12/31/2021	Business	trueYellowmedium
Signage	other	$500	1/1/2021	12/31/2021	Business	trueGreenlow

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: