Embedded Files
This site has moved.
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
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
DateFilter
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 "DateFilter" to filter columns containing dates.
Demo
CategoryFilter
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
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
NoFilter
Use the NoFilter to prevent any filter to show up.
OPTIONS FOR FILTERS
OPTIONS FOR FILTERS
Dependent Category 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
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 :
Page updated
Google Sites
Report abuse