If your spreadsheet contains a lot of data and its structure is complex it can be useful to use preset filters. That way you could for example choose to filter your data in specific places of your website.
It is not possible to use preset filters in the New Google Sites because of the platform's limitations.
1 - Example
Here is a simple example, please try reloading this page with these preset filters:
- All companies that are from the United States
- All companies that corresponds to the string research : "Micro"
- All companies created before 1970
2 - Setting up your preset filters
If you look at the URL of this page after reloading it with one of the link above you will notice that the structure is the following :
filter[index of your column]=your value
You need to have a filter for this column in order to work.
Here is how to add a preset filter to every type of filter:
- CategoryFilter / csvFilter
- Number filter
3 - Combining filters
You might want to add several preset filters in the same URL.
You can easily combine as much as you would like by separating them with "&".