Hi
Does anyone have an example how to implement a dependent Drop Down Lists mechanism?
lets say that i have dropdown list #1 where all of it's items are taken from a dataset.
Now, based on what i chose in dropdown list #1 - i want dropdown list #2 to display it's relevant items (also from dataset).
![](https://static.wixstatic.com/media/a27d24_a220d0490880454994e4169c2047b59f~mv2.jpg/v1/fill/w_345,h_156,al_c,q_80,enc_auto/a27d24_a220d0490880454994e4169c2047b59f~mv2.jpg)
Thanks,
Roy
i need help in dependent drop down in wix e.g i have 2 fields 1 is pin code & 2 is area whenever i select any pin code from dropdown then automatically show related area to pin code
@Mikhail Spirin (Wix) does the functionality described in your original post still work in the latest version of Wix? I have been trying to apply a filter to my 2nd dataset and have not been successful in the implementation. Every time I set the "teams" filter, I still get the entire "data" list. I am using Chrome as my browser to make these changes.
Hi @Mikhail Spirin (Wix) , I'm trying to follow your instructions as embedded below: It's achieved without code actually
So, you need two collections.
First is actual data:
Second is a list of teams (first dropdown)
Then you create 2 dropdowns and 2 datasets (both read/write)
First dropdown connected to the teams dataset:
It selects current team
Second dropdown connected to data dataset:
And, second dataset (data dataset) is filtered on first one. This is settings:
So, idea is that values in data dataset are filtered - it shows onlyt those items, which has "title" value SAME as currently selected in teams dataset
When you select smth other in first dropdown, it changes its value to another team
Values in second datsset are filtered automatically - only those which has changed value of "teams" field
There is no code here, only UI connections
But I'm not able to follow it properly as the screenshots all seem to be the same. May I request if you're able to revive the correct screenshots please? Apologies for removing the links as my account is not able to post links yet.
Thank you in advance!
Warm regards,
Ping
Hi I know this is an old post but could some one please help me! @Mikhail Spirin (Wix) I am new to corvid.
I simple would like a dropdown list to display from the bottom two bullet points please see below
so there is an arrow new to Bathroom fixtures which will show another list and an arrow next to Staff room fixtures that shows another little list.
that expand and collaspe.
Your help would be greatly appriciated. I have been trying all day. !!
Good morning,
Thank you Mikhail for your response
I've followed your directions but the drop down list isn't coming up
What could i be missing?
Thank you i look forward to your response
Hi, i am trying to create a custom form with dependent dropdown list that will enable interested distributors to apply for my product. now i need that on every submission i am sent a mail with all the details entered in the form. can someone please help me with the same? also i dont have a background in computers and have zero knowledge about coding.
another thing to mention - i created my dropdown menu following the steps given on this forum itself.
your help will be appreciated. thank you!
HI Prafoolgang
Its not clear what you are asking.
Your web page seems to behave as your screen shots show. What exactly isn’t happening?
steve
Hello,
i want to connect drop down menu for filtering my store product.
anyone have solution for this problem.
please see image for example.
i want like this.. this is also wix store.
website URL: www.foodmania.net.in
Hi Dylan:
Here is an example of how to do this in code that uses your data.
https://stcroppe.wixsite.com/steveonsoftware/example-code/wix-dataset-filtering-multiple-columns
Hope this is what you are trying to do.
Steve
@Mikhail
I am trying to do something similar to the above problem you laid out but for some reason was not able to get it to work. Wondering if you could help me on where I am messing up. I have laid out screen shots of what I am doing and what I am trying to accomplish.
1. I have a dataset with all the values. What I am trying to do is create three dependent filters. So ultimately when I select a service only certain values show up for Inverter Type and when I select an inverter type only specific values show up for supplier name.
2. For the first list "Service" I created another data set with just the specified values "Replace a Solar Panel" and "Replace and Inverter"
3. Then on the page I created two drop down list to begin with.
4. Here is the way I linked them. They are both linked back to a "ContactUs" Data base because when they submit I want the values select to push back to another data base so I can keep and utilize the data for my CRM system.
5. I connected the second drop down.
6. Then I did a filter on Dataset2 for services.
This did not seem to work and after that I was lost on how to filter the third data set "Manufacturers" on both the first and the second data sets.
Any help would be greatly appreciated!
Thank you,
-Dylan
Hi Roi,
It is working after syncing the database. I will go step by step and post my queries in this forum if I face any difficulty.
Thank you
Bhawana
Hi Roi,
Are you aksing me ? No its not working.
Bhawana
Hi,
Did you solved it ?
I checked it in your editor and it's working.
Roi.
Hi Mikhail ,
I am trying to achieve same dependent drop down by the steps given by you , but drop down list is not appearing on the UI.
https://www.worksheetsforpractice.com/question-bank
Grades dataset is read and write.
What am I doing incorrectly ?
Hi Rishabh,
Check out this thread.
Good luck!
Roi
How to create a filter search for a repeater
Dear Mikhail
******
Another decision - with code
Using code part, you can add to this structure function, which will be executed onClick, takes values from both datasets with this
https://www.wix.com/code/reference/$w.Dropdown.html#value
And, using this -
https://www.wix.com/code/reference/wix-data.html#insert
inserts those two taken values to the third collection
********
Thanks for the quick answer.
Your solution is good, and works on a test page i made, but maybe fit for a situation where there are 2 databases.
I want to use your logic, but to insert the selections of both drop-down lists to a third database.
(i have 3 databases on that page)
So, basically i want to select a team with the first drop-down, then select a relevant person from that team with the second drop-down and to insert those 2 values (team and person) to a third database.
Do you have any design or code that could support that please?
Mikhail
how I wish you have made a video tutorial
**********
It's achieved without code actually So, you need two collections. First is actual data: https://www.screencast.com/t/n0BVyxG0fMf Second is a list of teams (first dropdown) https://www.screencast.com/t/bueWCaEtvdrg Then you create 2 dropdowns and 2 datasets (both read/write) First dropdown connected to the teams dataset: https://www.screencast.com/t/MoGpOwBDQayw It selects current team Second dropdown connected to data dataset: https://www.screencast.com/t/BKNaKFqJaxf2 And, second dataset (data dataset) is filtered on first one. This is settings: https://www.screencast.com/t/toIoweMgg4f7 So, idea is that values in data dataset are filtered - it shows onlyt those items, which has "title" value SAME as currently selected in teams dataset When you select smth other in first dropdown, it changes its value to another team Values in second datsset are filtered automatically - only those which has changed value of "teams" field There is no code here, only UI connections
@Mikhail - Hi,
I wanted to deploy a dependent dropdown list with the 1st dropdown containing Category (from AdvCategory Collection) and the 2nd dropdown containing Unique Visitors Per Month (from UniqueVisitors Collection) which is dependent on the selection made in the 1st dropdown. The results would be shown in a table (hidden on show).
I followed your recommendation to @Kris previously but could not replicate the results.
1. An overview of the datasets, fields and codes used.
2. Data search results in 2nd dropdown not accurate:
3. Filtering condition used for 2nd dropdown:
4. Would appreciate enhancement suggestions beyond this:
a. How to deploy a reset on the search dropdown at the end of the search exercise because the current one does not reset to default.
b. The table does not display the correct data as required by the 2nd dropdown condition.
c. How to filter out the duplicates in 1st dropdown (there's a prior case in the forum but was not conclusive to me: https://www.wix.com/code/home/forum/questions-answers/filtering-gallery-in-response-to-drop-down-menu-options)...probably due to my infant coding skills.
Hey Mikhail,
THANKS!!!