Link a choice list to a list and a map

[maxime]

Hi,

I’m trying to create an app based on a map that displays various points of interest, with a list of those places shown below the map.

I’d like to have a dropdown menu that filters both the map and the list underneath based on selected categories (e.g. restaurants, hotels, bars…).

My data is correctly structured, I have a table with all the points of interest, including a column that indicates the category (and others with address, contact info, etc.).

I’ve tried everything — including using relations with other tables — but I can’t get it to work. The dropdown isn’t properly filtering the map or the list.

Could you help me figure this out?

Thanks a lot!

[Darren_Murphy]

@maxime

I’d like to have a dropdown menu that filters both the map and the list underneath based on selected categories (e.g. restaurants, hotels, bars…).

If you want a single filter that applies to both collections, then you need to create your own custom filter.

There are many ways to do this, but a one approach could be:

• Add a User Specific text column to your User Profiles table
• Add a choice component to the screen, source it from your list of categories, and target it the User Specific column
• Add a filter to each collection: Category is User Profile->Selected Category

You can do a lot more with custom filters, depending on what you want. Below is a video that demonstrates some advanced techniques, that may give you a few ideas.

Custom Filters using Data Editor logic

PS. It’s not necessary to create multiple posts for the same topic in different languages. We know how to use translation tools
I’ve closed the other topic.

[maxime]

Hi Darren, and thank you for your response.
I read your explanation and watched the video carefully.
However, I’m still stuck when it comes to linking my list above to the categories below.

When I select an item from the dropdown, it only changes the name of the first item in the list underneath.
And when I try to apply filters, everything disappears, and it doesn’t seem to be connected to the dropdown selection.

Thanks a lot for your help!

[Darren_Murphy]

Sounds like you are not applying the filters correctly. Make sure you are applying the filters to the individual collections, and not to the screen/tab.

[maxime]

I tried with the filter like this but it just dissapear

[Darren_Murphy]

[maxime]

I’m doing it , but still nothing appear …

[Darren_Murphy]

Why are you writing the choice to a relation?

What you should do is write the choice directly to a User Specific column, and then refer to that in your filter.

[maxime]

Thank you very much it’s working
I’ve already linked my dropdown list to both a map and a list in Glide (as I mentioned in my previous post). Now, I’m looking to take it a step further.

Is there a way to allow users to select the places they’re interested in (by checking them off) and then create an optimized route to visit all those places? Ideally, it could be done with Google Maps or another route optimization tool.

Haha, I know I’m asking a lot, but any help or suggestions would be awesome!

Thanks in advance!

[Darren_Murphy]

@maxime

Is there a way to allow users to select the places they’re interested in (by checking them off) and then create an optimized route to visit all those places? Ideally, it could be done with Google Maps or another route optimization tool.

That might be possible with the Radar integration, or with the Google Maps API. I don’t know, sorry.