Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2018 08:36 AM
Newbie question here! I searched the forum and couldn’t find what I needed.
Wondering if it’s possible to share a read only link to a view with a URL parameter that filters to only show the records that match the parameter value?
Specifically, we have a field called “Group ID” that serves as a parent/master identifier that we use to group records together. I would like to share a read-only link with the Group ID value added on the end as a parameter. The viewer would then only be able to view records that had that particular Group ID. I’m able to dynamically generate the URL and send each time with a different Group ID and only want the viewer to see the records for that Group ID referenced in the URL they received.
The general idea is: www.airtable.com/viewid/?groupid=123456 would only show records that had a value of “123456” for the Group ID field.
I’m not sure how to set up the view and/or field or how to structure the URL :frowning:
From what I see hints of, this can be done but I couldn’t find specifics. Can someone point me in the right direction?
Thanks
Jun 01, 2018 09:53 AM
I don’t think this can be done in the URL - filter, sort, and group are done via JavaScript in the browser, not through URL parameters (you can see this by the fact that if you preview a shared view URL and then apply a filter, it does not reload the page or change the URL at all).
The only way to package a filter into a shared view is to build it into the view to start with - in other words, you need to build a View in your base for each Group ID filter, and each one will have a unique share URL.
Jun 01, 2018 01:07 PM
Thanks Jeremy.
That’s a bummer. I was hopeful. Unfortunately it’s not practical to build views for each Group ID, since we could have hundreds of Group IDs each month. Yeah, I noticed that same thing, that the URL didn’t change, that should have been my first clue, ha.
Holding out hope for some sort of workaround. :slightly_smiling_face:
If not, upon further consideration I could possibly work with having one filter on one view that everyone can see, I just need to add a couple more criteria. Was hoping to be more targeted in what I was sharing but oh well!
Thanks again Jeremy.
Aug 16, 2018 06:43 PM
I personally think it would be very powerful to be able to apply filters in the urls for linked views using conditions in an existing table. Either that, or the ability to bulk create views based on a field’s value.
Thanks for this post though - saved me a ton of time in research and experimentation, I suspect.
Nov 08, 2018 10:51 PM
This would be super powerful. You could build website cms collection urls that opened Airtable reports filtered for a product or client and the like.
Mar 21, 2019 09:09 PM
Yes, this would be fantastic.
I’ve been working on TWO tables for USA and UK theater showtimes, where the USA table needs to load sorted by STATE; the UK form loads sorted by COUNTRY. I’d rather just have one table + add html links “UK” “USA” (etc) above the table. Manual filtering is “OK”, but most normals aren’t NECKBEARDS. :nerd_face:
Oct 01, 2019 08:44 AM
Some time has passed since the last reply. Has anyone come up with a solution?
Another alternative for AirTable to consider, instead of putting the filter in the URL: let the account owner create a table of external users (view sharers), with the table showing the name, the access URL (provided by airtable?), and two columns for the filtering: FIELD and VALUE. So, in one row of the table, you could pick Field =company, and Value = Tesla. Then, that URL would only show rows with company name = Tesla.
Mar 11, 2020 06:07 AM
Our search tool for Airtable supports URL parameters. So you can consider it a dynamic view generator.
Oct 15, 2020 09:30 AM
This is probably what you were looking for:
Oct 09, 2021 01:10 AM
@Fabian correctly pointed out that one can easily filter records in shared views, by adding the filter URL parameter to the shared view link, as described in the above Airtable post.
The problem is that you cannot do the same for your internal, non-shared views.
In other words, you cannot dynamically filter non-shared views.
You have to manually create new views and preset their filter conditions.
Unless…
Unless…
Nope! I don’t think it can be done!
Any ideas @Jeremy_Oglesby, @Justin_Barrett