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
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?
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
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
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
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.
is possible use "order by" with theses filters?
ex: ?filterQ=4&orderB=asc
Hi Borys,
It is not possible to do so for now on Awesome Table. If you send a pre-filtered link to another user, he will be able to see the filters
Thanks
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.
I'm struggling with embedding a prefiltered app on a new Google Site.
My urgent question: How can I make sure I can embed my app with dynamic height on a new Google Site?
Thanks!
PS: This documentation seems outdated, can it please be updated?
Hello Megan,
It is not possible to have an Awesome Table view with no data by default.
Thank you for your understanding.
Thomas
Hello, is there a way to get a filtered view and hide the filters (like how you can do from the print screen)?
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
Hello Juliet,
This is unfortunately impossible, sorry for the inconvenience.
Nicolas
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.
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 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
I don't want to see the filters at the top. How can I hide them or remove them. Thank you.
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?
Hi, is it possible to hide the "get filtered url" option?
Hello David Oliveira,
This is unfortunately not possible.
Nicolas
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
The generated code for embedding the app via <script> includes a parameter for data-filters="". I have tried various combinations attempting to apply a filter but it seems to have no affect - blank rows still show up in the barchart. For example, data-filters="filterM<>'' " and data-filters="filterM is not null" and data-filters="M<>'' " and data-filters="M is not null".
How do I pre-filter using the embedded script?
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 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
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
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
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
Is it possible to disable the next button?
Please sign in to leave a comment.