Hey everybody! I am super new to Wix code. I need a quick explanation with copy/paste code of how to filter a database by a dropdown menu.
Basically, I've created a database for actors in my area. I want to be able to search this database and allow other filmmakers to search. I have the form all figured out and works great, and the dynamic page for each actor set.
I'm hoping to have a page with a gallery that features the headshots the actors have uploaded (I've figured out how to do this) and that can be filtered by different drop-down options. Actors can submit their age, race/ethnicity, build and gender by dropdown. I'd like to be able to filter the gallery by these queries. For example, if a filmmaker was looking for a fifty-year-old African-American heavyset man they could select that from the dropdown and actors who have entered in corresponding data would appear in the gallery.
Any help with this would be wonderful!