Hello, I have a problem. I hate redundancy. :-)
I have built a nested category tree by two collections: parent categories and subcategories. The category title field is reference field in subcategories collection, so I can asign a parent category to each subcategory. On the site I made two dropdowns: for parents and subs.
Now the problem appears: I want to filter subs by parents, so when in parent you choose one, for example fashion, then in subs dropdown you will only see subs like jewelry, clothing etc.
I made a filter on the subs dataset by the arents dataset and title field. But it doesn't work at all. When I choose whatever in the parents dropdown, in the subs dropdown I get only the same wrong subs, its like the subs dropdown didn't know, what parent I have chosen, it takes the subs of the first parents record.
Please help. Is it a bug or I just need a code to let one dropdown know what I have chosen in the other one ? Shouldn't it know, if I filtered it by the other's dropdown dataset ?
There is also some code trigered by on change property on the parent's dropdown, but when I removed this code for a while, the problem didn't disapper, so I think that dataset filter is independent on any triggering property. I am not a programmer at all, I hoped to do it visually in wix, I even have seen a video on this somewhere out there, but now I can not find it.