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.
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.
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
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.
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.
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)
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 :