Remove dynamic geo location dropdown duplicates

annamendivil · 2020-09-20T16:49:52.767Z

Hey Bubble community,

My issue that I need help with is that I am receiving duplicate geo locations in my dropdown. The dropdown is a filtered dynamic dropdown that is based on (1) selections of two other dropdowns (2) the database that sources the dropdown. Dropdown 3 filters the geo locations listed based on the users in the database that match with the previous dropdown selections. Hopefully the screenshots below help to visual the flow if my description is confusing.

Is there any way to source the filtered database without receiving duplicate geo locations?

Dropdown 1:

image2068×1048 198 KB

Dropdown 2:

image1460×818 82.7 KB

Location Dropdown:

image2106×744 108 KB

Duplicate Options:

image2254×582 109 KB

nocodeventure · 2020-09-20T18:42:56.826Z

You can add :unique elements after your search query by pressing More…

annamendivil · 2020-09-20T19:32:01.102Z

Thanks for the response @nocodeventure!

Added :unique elements after the search query but not seeing any change. I would think that I would want to add that to the option caption part which is where I choose locations as what will be listed but that is not an option.

Dropdown 3 w/ :unique elements included

image1466×934 82.4 KB

Screenshot of user flow once preview was updated:

image2360×690 113 KB

annamendivil · 2020-10-01T15:05:57.443Z

I figured out the solution for anyone that is or will have this issue I thought I would post my solution. I changed the type of choices from the database to geographic locations and then did a search of the database within the choice sources and signified the choices would be narrowed to locations there. Then in the option caption I just put current option