2
It can be useful to have some of your filters already set when you load the app and to display different versions of the same app on different pages (for example: one page per country).
After adding filters to your spreadsheet, you’ll be able to filter data in your app.
To embed your apps with pre-selected filters, filter your app. Then, click Embed.
A pop-up appears. Click Ok to allow Awesome Table creating pre-set filter URLs.
Go to the Iframe tab. The URL in the Iframe Code has been filtered automatically. Copy the URL.
done That’s it! Your pre-filtered URL is ready to be embedded in your website.
Once you have the pre-filtered URL, the way to embed your app in a website is the same as usual.
Learn more: How to embed your app in your website
Embedding your Awesome Table app with pre-filtered URLs works:
- On the Awesome Table app
- In any custom site when using the iFrame Code provided by Awesome Table
- In any website when using the embed script provided by Awesome Table
- In Lumapps
info Due to their new referrer policy, it does not work when embedded in Google sites (using the filters in the Google site URL to navigate to a pre-filtered Awesome Table app).
Comments
34 comments
Is it possible (using the card visualization) to show no results until filters have been selected? That way users are not seeing all of the data at the start. They will only see the results of what they are filtering for.
Thanks
Hello Megan,
It is not possible to have an Awesome Table view with no data by default.
Thank you for your understanding.
Thomas
"It's not possible to use preset filters in the New Google Sites because of the platform's limitations."
Et dans le futur est-ce que le retour de cette fonction est prévue ?
Hello Benoît Dumeaux,
Indeed, it is not possible to use preset filters with New Google Sites for now. We don't have a date when it will be possible.
However, we will let you know when you will be able to use preset filters with New Google Sites.
Thank you for your understanding.
Thomas
Hi,
Can I manipulate the embed code to display the filtered table? We want to embed the FAQ as a resource list on multiple pages of our site but have different filtered views set automatically. We want users to be able to change it still, but see immediately what they are looking for. I know it works if I send them to a different page, but I also like the idea of keeping all the content on one page.
Thanks for your help!
Hello Juliet!
I am not to understand what your question is. You should be able to have the same view embedded in various pages; have some different initial results thanks to the filtered URL (users will then be able to manipulate the filters as desired. Please note that the filtered URL should not be in your embedded view but in the URL of your website page itself.
Nicolas
Hi Nicolas,
Thank you for your response. So, there is not a way to change the embed code to display a filtered view? I can only link to a page that has the table with the filtered view?
Hello Juliet,
This is unfortunately impossible, sorry for the inconvenience.
Nicolas
Can we hide the "Print" button ?
Hello,
It is possible to hide the print button by overwriting the native CSS with your personal code but it requires knowledge in code and we don't recommend to do that because if we make some change in the native code, it will affect your view.
Kind regards.
Thomas
I don't want to see the filters at the top. How can I hide them or remove them. Thank you.
Hello Stephen Tackett,
You can hide your filters with the "noFilter" keyword. You just need to use this keyword in the relevant column.
Kind regards.
Thomas
Any news on this?
"It's not possible to use preset filters in the New Google Sites because of the platform's limitations."
Hello Dany,
We don't have news from Google about updates of New Google Sites.
Of course, we will let you know if there is an update.
Thank you for your understanding.
Thomas
Hi Thomas,
It's interesting that it's a limitation with Google Sites, because we are able to embed a url/page with custom url parameters without any issues. It's a shame that Awesome Table is unable to do likewise.
Hello Caleb,
We are working on it but it is not the same problem because it is an iframe.
Please, rest assured, we will take care of it.
Kind regards.
Thomas
is possible use "order by" with theses filters?
ex: ?filterQ=4&orderB=asc
Hello Edwing Perez,
It is not possible to use these queries for a filter.
Kind regards.
Thomas
Hi, is it possible to hide the "get filtered url" option?
Hello David Oliveira,
This is unfortunately not possible.
Nicolas
Hello, is there a way to get a filtered view and hide the filters (like how you can do from the print screen)?
Hi,
Is it possible to use two filter options (i.e. using the AND command) when filtering the data?
For example - In the "country" field, some respondents wrote USA and others wrote the United States.
I need a way to show both their data in one visualization.
Cheers,
Shuli
Hi, I have a question about getting a filtered view.
When I filter the view and press "Copy filtered URL", my URL ends with undefined, like this: /view?filterD=undefined...don't know why is undefined..that happens on every filter I put. Can someone help me with this?
Hi Magdalena,
Thanks for your post!
This issue has been escalated to our technical team and we are currently working on it. We will keep you posted when it has been fixed.
Thanks
I am having the same issue as Magdalena. I was able to print filtered data previously so I think the issue is on your end.
Hi Richard,
Quick update on this issue, as a workaround, you can pre-filter manually the view by using our first method detailed on our article here.
We understand that it requires a bit of work on your side but it will work.
We'll keep you posted about this problem and its resolution
Regards
The work around doesn't work with embeded views in google sites (classic.) The URLs aren't valid according to the Awesome table widget.
Any update on this fix. This is a rather huge problem and big part of the awesome table functionality.
Thanks.
Actually, even entering the pre-filled filter url into the address bar doesn't work. It's not doing the filtering at all.
Hi Marc,
On our side, the first method is working correctly.
Could you please create a ticket here: https://support.awesome-table.com/hc/en-us/requests/new and provide a screenshot of your issue. Please share your view and spreadsheet with support@awesome-table.com
Thanks
Hello,
Is there a way to pre-set a filter that will be hidden from the users. The use case is that I would like to create different views for different departments of the company, but I don't want the users to be able to choose the particular filter, it would be predefined for them on the department section in google sheets.
Please sign in to leave a comment.