If your spreadsheet contains lots of data and its structure is complex, it can be useful to have some of your filters already set when you load the app. It can be useful to display different versions of the same app on different pages.
1. Set up your preset filters manually
Below are simple examples of preset filters:
- All companies that are from China
- All companies that contain the string Micro
- All companies established between 1920 and 1980
If you look at the URL of this page after applying one of the preset filters, you can see that it follows a specific structure:
yourURL?filter[index of your column]=your value // yourURL?filterB=Todo
Here's a guide to help you choose preset filters depending on your needs (or data type):
|StringFilter||Content of the stringfilter (text)||
Filter for 'Yellow' in column A:
|CategoryFilter / CsvFilterAnd / CsvFilterOr||Comma separated values.||
Filter for 'Sales' and/or 'HR' in the
category 'Department' in column B:
|NumberRangeFilter||Two values: start and end of the range separated by a comma.||
Filter for a range of numbers, for example 50 to 70 in column M:
|DateFilter||Two parameters: start and end of the range separated by a comma. Dates need to be in timestamp. Use the timestamp convert site to convert your dates.||
Filter for a range of dates, for example 01/01/1975 to 01/01/1980 in column L:
For example: ?filterA=RED&filterV=USA
2. Generate your preset filters automatically
There is a second way to use preset filters with your Awesome Table app with a menu on the top right corner. It contains the Clear filters, Get filtered URL and Print actions.
Using this menu, you have access to the Clear filters button, that quickly erases the current selection.
You can also use Get filtered URL for your Awesome Table apps.
When you select this option the filtered URL is copied to your clipboard and you can paste it into a new tab to see your filtered app displayed in the awesome-table.com web app. This useful trick makes sharing filtered apps possible and very easy.
3. Embed your Awesome Table app with pre-filetered URLs
You can embed your app in a website with pre-filtered URLs. Depending on where you want to embed your app, you can either use a pre-filtered URL or use an iframe with your pre-filtered URL in it.
3.1 Use the pre-filtered URL to embed your Awesome Table app
Once you have created your pre-filtered URL (as described above) you can use it to embed your app.
3.2 Use the iframe to embed your Awesome Table app
Select the Iframe tab:
Then, copy the code under Iframe code.
Open a new tab and paste the Iframe in the browser bar.
Copy and paste your pre-filtered URL to replace the 'src' between quotation marks (like in our example below).
Your iframe is now ready to be embedded in your website.