Hello,
I’m working on a website dedicated to a filmmaker. I’m creating a page with a huge database with his crews and actors displayed in a table. As it’s long (+2000 rows), there are two dropdowns to help my users browsing through the crews :
1- Movies
2- Department
The dropdown works, I’ve added two filters to my dataset, both under the condition " Is ", and the source connected to user’s input.
The problem is that it seams to work as a " contains " condition. Let’s say there’s a movie called “AIDS” and another called “THE STRUGGLE AGAINST AIDS” : if I select “AIDS” on my dropdown, it’ll display both movies.
For other movies, it won’t display anything at all, just an empty table and I have absolutely no idea why.
So, I’ve remade my whole database (and as you might now, Wix won’t allow you to just replace your database for some reason, so I had to erase every time my 2000+ rows…) by adding a “FilmID” which are numbers. I’ve used these numbers as the values in my dropdown choices, this way “AIDS” value would have been #8 and “STRUGGLE AGAINST AIDS”, #9. I’ve changed my Dataset filter by replacing the “Film” filter by “FilmID”
Unfortunately, it didn’t work at all. I thought it had something to do with the fact that Wix automatically recognized them as numbers and somehow numbers can’t be used as filters (i don’t know). So, once again, I’ve erased my whole database, and created some “nicknames” for each movies. “AIDS” would simply be “aids” and “STRUGGLE AGAINST AIDS” being “saa”. I’ve used these nicknames as the values in my dropdowns, changed the filter to “FilmNickname” but it still doesn’t work as expected… (“Aids” being displayed as the title is the same as the value, but otherwise, no movies are displayed in my table…)
My last solution was to connect the dropdown to my dataset but it creates duplicates (if ten people work in one film, this film is displayed ten times in the dropdown). I checked some tutorials, end up finding a way to erase these duplicates… but, new problem: Wix won’t allow an higher limit than 1000 items, which means that not all movies are displayed. If 100 peoples work in each movies, and if the filmmaker made 20 movies, only the first 10 movies will be displayed.
Any idea on how can I fix that? Thank you