Awesome Table provides an easy way to filter data in your view.
If you have a lot of data in your Spreadsheet, you can easily search for entries using filters. Elements can be filtered by categories, numbers, dates, string and more!
1 - 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.
See our documentation on Spreadsheet configuration.
2 - StringFilter
Use the "StringFilter" to filter columns containing an exact match.
This filter is sensitive to accents (you must type the accent in the filter to show results that have accented characters).
3 - NumberRangeFilter
Use the "NumberRangeFilter" to filter columns containing numbers.
For now ,Awesome Table automatically adds Numeric filters when columns contain numeric data if you do not have another filter. To remove this filter, indicate "NoFilter" on that column.
4 - 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).
5 - 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.
CategoryFilter uses the logical OR operator when multiple values are selected.
6 - 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.
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 (e.g.: only people with ALL the selected skills will be shown or displayed: Google Apps, MS Office Suite, HTML, CSS, Pomodoro).
7 - 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.
8 - 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.
9 - 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.