🌪 Use Multiple Choice Components to Filter an Inline List

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.

2 Likes

That was fast! :grin:

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…

1 Like

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.

2 Likes

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.

4 Likes

Still trying to set this up.:sweat_smile:

  • 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.

3 Likes

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.

3 Likes

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.

3 Likes

@Darren_Murphy @ThinhDinh

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.

2 Likes

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:

  1. Creating a split of the choice selections in the Users table,
  2. 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 :slight_smile: