Youāre right. This is assuming that your users are signed in to the app. If you donāt have signed in users, youād have to create a working table, use user specific columns, and then bring in those values using single value columns rather than a template column.
That was fast!
Yes, I was making it that way with my old filter for everyone. Thank you again!
All this is amazing, but can this apply to the Website format? (not app).
I cannot even make it work for a single filterā¦
Sure can! The logic in this video is done in the data editor, so it can certainly be applied to a Glide Page.
Hi Robert,
may i ask how to do that in the data editor for the website (not the app)? Iām trying for hours but itās not that intuitive and i have been working with Airtable and Softr for years.;-(
Thanks a lot in advance.
Reg. Sabine
This is what i see:
Can you be more specific about what it is that you are stuck with?
As Bob pointed out, it should be the same either way.
Hi Darren,
Thanks for your quick response.
Iām building this dashboard (Glide App)
and before the custom collection i want to setup a multiple filter option.
At the moment i can use only one filter (years).
While having webpage setup in the first place i donāt have the ādetailsā style available.
For me it would helpful to get to know the first steps i would have to do for a webpage with multi filtering (which column type etc.).
May you can help?
Thanks, Sabine
The column types in the data are all the same, so there shouldnāt be a difference. The data editor has always been identical between Classic Apps and New Apps. There may have been slight changes in the past couple of years, but it should mostly be the same.
As for the front end, every screen in New Apps are Detail style screens. They are Detail style screens because you can add any component to the screen, and you are not restricted to only a collection.
Might be useful if you point out specifically where you are getting stuck.
Hi Jeff, Thanks for the explanation.
Iāll try to explain where i do stuck.
In the video one can see this structure of the screen:
If I do want to add the filter choices (tabs)(there are no tabs for desktop), what kind of element do i have to use/add to appear on the left side? My screen looks like this and i do have this collection, which people should be able to filter by 3 diff elements:
Thanks a lot.
Just found something called āChoiceā, but under form elements. I assume itās the one?
Yes, the Choice component is indeed what you need. Be sure that the values are written to a User Specific Column.
Still trying to set this up.
- Can you help me finding this āinline listā element. Has this been renamed?
- How is the setup for these multi filters if we donāt work with signed-in users? Do i also should work with the users table? If i would and would leave the filter (signed-in) out, the users appear on the page which is not intended.
Really appreciate your help.
Have a nice day.
Itās called a Collection now.
I think Bob likes to use the User table a lot. I usually create a separate single row table with mostly user specific columns within it. User specific columns work whether you are signed in or not, so you donāt have to rely on a user being signed in. Then to get the values from that table into other tables, you can simply use Single Value columns.
We usually call those separate tables āworking tablesā if you ever come across the term in the forum. The advantages of having a separate table, is that it keeps clutter out of the user table, and you can use it without a user being signed in. The disadvantage is that you have to bring the values into other tables using Single Value columns, so itās not as easy to access that working table data, like it is with a User Profile.
If you go this route, create a new tab and copy and paste your components so you donāt lose them again.
Hi Jeff,
Thanks for the comprehensive explanation. Really appreciate it.
I understand the concept of the working tables now and set up a single row table as you described. But there is no option to specify them as āuser specific columnsā. For other column types i can see that option, but not here:
Do you know why?
Iām afraid i still donāt fully understand all the glide concepts.;-(
Youāll have to add new columns and make them user specific. Unfortunately you canāt change other column types to user specific once itās been created.
Also, computed columns, such as the Single Value column you are showing, are automatically user specific if the basic value itās referring to is user specific.
Great tutorial Robert. I am willing to have multiple filters for one of my app. However, would like to confirm, everytime I select the choice component, will it cost āUpdatesā?
Yes.
Thank you for the confirmation.
Hi there everyone
Iām trying to accomplish a filter on a table, with choice component - a drop down that allows multiple choice.
My table data is a Glide big table - ācalls_tableā
The choice component feeds from that table (rep_name column)
The goal is to filter by repās that answered calls listed in the table.
I followed @Robert_Petitto excellent tutorial:
- Creating a split of the choice selections in the Users table,
- Then creating a rel column in the data table to relate to these values, I called it ārel_rep_nameā
The next step is to apply the filter to the table component in the layout section - however when I go to the layout view and to table > filter data, the column ārel_rep_nameā that I created is not appearing in the drop down list to filter by.
Iām not sure what Iām missing hereā¦
Please help