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

Twitter

$600

1/1/2021

6/30/2021

Partners

(tick)

Facebook

$750

3/1/2021

9/30/2021

Potential Clients

(grey lightbulb)

Instagram

$300

3/1/2021

9/30/2021

Potential Clients

(grey lightbulb)

LinkedIn

$250

1/1/2021

12/31/2021

Managers

(tick)

Blog

$1,000

4/15/2021

9/15/2021

Subject Matter Experts

(info)

Website

$2,000

1/1/2021

3/15/2021

C-Level

(red star)

Email Newsletter

$500

9/1/2021

12/31/2021

Managers

(tick)

Development

$6,000

1/1/2021

12/31/2021

Laypeople

(star)

Pay-per-click

$2,000

1/1/2021

12/31/2021

Laypeople

(star)

SEO

$500

1/1/2021

12/31/2021

Subject Matter Experts

(info)

Surveys

$500

1/1/2021

12/31/2021

Old clients

(lightbulb)

Corporate Branding

$1,500

1/1/2021

12/31/2021

Business

(warning)

Business Cards

$500

1/1/2021

12/31/2021

Business

(warning)

Signage

$500

1/1/2021

12/31/2021

Business

(warning)

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:

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: