Cascading dropdown lists doesn't work with multiple datasets

Ask the community
, ,
1

Hi guys, I’ve been cracking my head for more than a week trying to cascade multiple dropdown lists with no luck.
To cut a long story short (at least I’ll try)…

  • 1st main list (data set - ‘streams’) - 1 column:
  1. streamName - [text].
  • 2nd list (data set - ‘categories’) - 2 columns:

  1. categoryName - [text]

  2. stream - reference to the Streams dataset.

  • 3rd list (data set - ‘proposals’) with a list of 50 proposals with multiple columns:

  1. proposalName - [text]

  2. categoryName - reference to Categories dataset.

  3. streamName which - reference to Streams dataset.
    I’ve got a page (tried to play with standard and dynamic - failed with both) where I want to provide 2 dropdown lists, 1 for Streams and another for Categories.
    The user will then be able to first choose a stream. based on his selection, the category dropdown should be filtered. Based on the selection of a Category, the last componenet below (repeater) should presend just the images of the relevant proposals based on the selected stream and category.
    Screenshot below:

987×292 45.5 KB

I’ve played with every option I could find (suggestions from this forum and knowledge base) with no luck and I can’t make the second dropdown to be filtered by the first selection.
Regarding the repeater, my expectation is for it to present the relevant proposals based on the CURRENT state of the dropdown lists. That is, On Load - present all. When choosing a Stream, filter to all proposals within the Stream (regardless of category). When chossing category, filter repeater to all proposals under the same stream and Category.

If anyone can help me here, I’ll be forever thankful as I lost most of my hair struggling with it :slight_smile:

(In case one of WIX admins want to view the site’s backend: ian1415.wixsite.com, the new site - members page).

Many thanks in advanced,
Oz.