OTHER APPS‎ > ‎Awesome Table‎ > ‎Documentation‎ > ‎Basic Configuration‎ > ‎

3. Available Filters

*** A new version of this article is available on this page ***

STANDARD FILTERS

StringFilter

Use the "StringFilter" to filter columns containing free text.
Note: this filter is sensitive to accents (you must type the accent in the filter to show results that have accented characters).
If you wish to make suggestions to make it better, please star this issue on the feature request page.

Demo

NumberRangeFilter

Use the "NumberRangeFilter" to filter columns containing numbers
Note: a range filter is automatically created for all columns containing numbers. If you don’t want the filter to be displayed, indicate "NoFilter" on that column.

Demo

DateFilter

Use the "DateFilter" to filter columns containing dates.
Setup date formats straight from the Spreadsheet in the Format menu:
  • Number>Date, or
  • Number>More Formats>More dates and time formats... to find a list of other formats

Demo

CategoryFilter

Use the "CategoryFilter" to filter columns containing values from a list (choose from a list).

When selecting multiple values, the view will show all results matching those values.
Note : You can setup Dependent "CategoryFilter"

Demo

csvFilter

Use the "csvFilter" to filter columns containing a list of comma separated values (e.g.: a list of skills).

When selecting multiple values, the view will show all results containing all the selected values.

Here are the data used in the example.

Demo

NoFilter

Use the NoFilter to prevent any filter to show up.

OPTIONS FOR FILTERS

Dependent Category Filters

You can add more functionalities by linking multiple CategoryFilter & csvFilter: the linked filters will only show the value matching the parent filter.
Link the columns by adding the letter of the linked column in brackets at the end of the categoryFilter (or csvFilter) keyword.
For instance, if you want the Country column (column C) interlinked to the State (column D) and City (column E), add (D,E) at the end of your CategoryFilter keyword: categoryFilter(D,E)

Demo

Labels inside filters

By default, you should get something like this for your filters:
It is possible to set a default text for each filter to get something like this :
To get the same result, open the Awesome Table settings and set the Caption field in the Format tab :