Hi all :-)
I was wondering if anyone could help me. I am new to code (brand new) and am having a bit of trouble with my drop down menus. Although I'm new to code, I'm loving the possibilities that it opens up for website design and functionality on the Wix platform!
I've created a database for a recruitment agency with a list of available jobs and fields (job title, classification, sub-classification, location, etc.)
With help from this fantastic forum I've been able to create a working:-
- Search field which filters the job title
- Drop down menu for location
- Drop Down menu for job classification
Unfortunately, My drop down menu shows all the locations listed in the database so there are double ups (see right) and there is no logical structure. As you can see Christchurch appears 3 times... etc.
My question is: How do I create a drop down that shows custom location values (New Zealand's major regions, and not all the location values in the database column), which then searches the location field of my database?
I also wondered how to link all the search menus, so that each search box filters the results in conjunction with one another? For example Someone could type in 'Pricing Analyst', then select 'Christchurch' and then 'Banking and Finance', and get search results ONLY showing jobs that match all three specific criteria. At the moment the search menus work separately.
I hope this all made sense? Any help would be hugely appreciated! Thanks :-)
Below is the code I've got so far:-