so…
my countries drop down is connected via filter within the database so that when option is selected in the drop down it filters all the items in the database with the selected country to the repeater
and my cities drop down is connected via connect a list so that it retrieves the list of the cities in the database
that way If I select for example the US it shows the states that I have in the database or if I select UK it shows the cities that I have in the database meaning it filters the city drop down related to the country
however it shows duplicates as I have many items within a city with the same text where as I want the drop down to show the city once not as a duplicate
I hope to hear from velo staff with any bit of help as it is an issue i have been trying to fix for two days with not sleep
Hmmm, i do not know how you use the search-function, but if you would search for → dublikate dropdown <— then you would also find posts, where you surely would find your solution.
https://www.wix.com/velo/forum/tips-tutorials-examples/remove-duplicates-from-connected-dropdown-options
i have been trying to fix for two days with not sleep
I don’t know how to interpret your statement, you should not forget, that this forum is not a wishlist, where you can wish some code for free.
And just to be honest, someone also is searching for months for a possible solution. So i would say, you are lucky to have found your solution already after 2-days.
Take a look onto the shown link, this link will help you out and is also very good explained.
And here one simple example of my own…
const list = [1, 2, 3, 3, 4, 9, 4]
const uniqueList = [...new Set(list)]
console.log(uniqueList)
I’m pretty bad with coding and yes I understand I cannot just wish for a code it’s just I am very eager to get it done and it’s killing me haha
the code listen in the link you sent I have already tried and I struggled with as my “countries” dropdown would work but the “cities” dropdown would not show any cities
It is very difficult for me to figure out the issues and have had no luck finding a solution whatsoever
although I am definitely happy to hear from you so quick !!
@stephanos02x
Perhaps you should elaborate more on your project.
How do look like your DATABASE ?
How do look like the result you are expecting?
Which elements are used in your project?
-Do you use datasets or data-queries?
Perhaps also some screenshots?