Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page contains examples of text tables that you can filter with the set of available filters. Please try to use the macro in each specific situation.

Table of Contents

Generic table data filtration

Info

Please select one or multiple values to filter data in the table below.

Table Filter
default,,,
cell-width150,150,150,150
userfilterLast Name
columnCity,First Name,Occupation
id1457694137940_-159727723

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Default values for filtration and regular expressions

Info

Please note that Table Filter macro allows you to define default filter values for table columns. These values will be automatically applied upon each reload of the page. You can also use regular expressions for flexible data filtration.

...

Table Filter
defaultDoe,
cell-width,
columnLast Name, City
datepatternyy-mm-dd
id1457694296418_-997170632
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Table filtration by the user-entered keyword

Info

Please note that Table Filter macro allows you to add free-text fields for dynamic data filtration depending on the specified query.

Try to start entering some values for filters to get dynamic filtration of the table.

Table Filter
default,,,
cell-width,,,
userfilterFirst Name,City,Last Name,Occupation
datepatternyy-mm-dd
id1457694300404_1866020122
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

...

Filtering throughout the table

Info

The global filter allows you to dynamically filter values in all columns of your table. Enter some query to get the table filtered.

Table Filter
default
cell-width
datepatternyy-mm-dd
globalFiltertrue
id1457694304175_1866020122
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Filtering multiple tables at once

Info

You can filter several tables at a time. Just paste two or more tables into the macro.

...