Filters

Spreadsheet configuration

In Awesome Table, we use a Google Sheets datasource with a prescribed structure: The first row is for headers (a short descriptive name of your columns), and the second row for filters and keywords (parameters).

Simply write the keyword corresponding to the filter you want to use.

info See our documentation on Spreadsheet configuration.

StringFilter

Use the "StringFilter" to filter columns containing an exact match.

warning This filter is sensitive to accents (you must type the accent in the filter to show results that have accented characters).

NumberRangeFilter

Use the "NumberRangeFilter" to filter columns containing numbers. 

info Add "NoFilter" in the second row of a numeric data column to prevent a numberRangeFilter to display automatically.

DateFilter

Use the "DateFilter" to filter columns containing dates.

In this field, you can change the way your dates are displayed (here you can find examples of date formats).

CategoryFilter

Use the "CategoryFilter" to filter columns containing values from a list (dropdown menu). If you select several values in your filter, your view will display elements that match at least one value.

info CategoryFilter uses the logical OR operator when multiple values are selected.

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 results containing all the selected values.

info csvFilter uses the logical AND operator when multiple values are selected. The results will show items that contain or matches ALL the selected (multiple) values</strong (e.g.: only people with ALL the selected skills will be shown or displayed: Google Apps, MS Office Suite, HTML, CSS, Pomodoro).

Copy this template

Dependent categories filter

 You can add more functionalities by linking multiple CategoryFilter & csvFilter: the linked filters will only show the value matching the parent

Link the columns by adding the letter of the linked column in brackets at the end of the categoryFilter (or csvFilter) keyword.

noFilter

By default, Awesome Table automatically applies the NumberRangeFilter on columns containing (or formatted) as numbers. To bypass or overwrite this, use the noFilter option.

Labels inside filters

By default, Awesome Table uses headers of your spreadsheet as labels for your filters. You can change that in Formatting - Filter's Caption.

By default, filters look like this:

It is possible to set a default text for CategoryFilter and csvFilter to get something like this:

To do this you will need to go to Formatting in your sidebar and change the "Filter's caption" link. 

You can get your headers back as your filter's labels by writing "insideFilter" in this field