Dependent Drop Down Lists

Hi,
Did you solved it ?
I checked it in your editor and it’s working.
Roi.

Hi Roi,

Are you aksing me ? No its not working.
Bhawana

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

@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

Hello Mikhail,
I want to use this function for my store product to categorize my product with there speciality. how to use this drop down function for my store product.?

like this

1 drop down list category (utility, fun, electronics etc.)
& 2 drop down list sub category (electronics(mobile, laptop, tablets, others), utility(for kitchen, for bedroom, for store room)

I want this type of product to categorise, How to ?

Hi Dylan:

Here is an example of how to do this in code that uses your data.

Hope this is what you are trying to do.

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

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!

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

Hello Mikhail,
Can you help by guiding how to set up the above drop down option on a dynamic page connected to list

Not sure if it is a wix issue right now, but unable to get this to work. The first dropdown will select appropriately, however Next/Previous buttons will not work to go to matching selections (only get the first to pop up). The second dropdown populates with selections but does nothing when selected and again the same next/previous button issue.

@nealindiatours09 Is your example missing another filter for the 2nd drop down?

Hi, Steve,
your example is awesome, but i still have a problem. I followed all the steps and 100% copy your original code, when i previewed, it said " Wix code SDK error: The text parameter that is passed to the text method cannot be set to the value 7. It must be of type string ", refer to $w(‘#itemCount’).text = results.totalCount;

// When we apply a filter (see updateRepeaterFilter()) this gets called to reload the drop downs
$w(‘#servicesDataset’).getItems(0,$w(‘#servicesDataset’).getTotalCount())
.then((results) => {
// Update our dropdown object with the new data record list
dropDownRecords.updateRecordList(results.items);
// Update the counter on screen
$w(‘#itemCount’).text = results.totalCount;
// Load/Reload dropdown data sets from our dropdown list data object
$w(‘#serviceList’).options = dropDownRecords.servicesList();
$w(‘#inverterTypeList’).options = dropDownRecords.invertersList();
$w(‘#supplierList’).options = dropDownRecords.suppliersList();
});

I try to use toString() to fix it, but didn’t work. Would you please help on it?

Hello Mikhail,
i tried as you said its working but, i want to add the value of dropdown list to a dataset. Can You help me to do this…
Thanks

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

Well it’s a bit different case i guess… You just need to expand/collapse those internal lists on clicks on 1st level menu. Check this article - https://www.wix.com/corvid/example/collapse-elements

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 can you guide me with this…

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