@richard28494
Never feel like you need to apologize for asking more questions when you still don’t understand something. It is ok to be confused by documentation or tutorials.
What you are looking for is not a native setting (as explained in one of my tutorials):
You cannot select 1 field for value and 1 field for label.
If you connect through dataset, you can select 1 field for both the value and the label.
If you want to set different fields for label and value, then you will have to add code to change the options.
In my conditional filtering tutorial, we populate some dropdowns by performing a query on the database, getting all the unique values then setting them as the options. Of course, we used same field for label and value.
Depending on your code experience you could modify the code to get 1 field for label and 1 field for value. (Or simply modify something else. Such as: if you want them to select a Label but then search the database for a different value then just query the value that matches that label. You can check the navigation tutorial to see how we created a query to find a URL field based on a title selected from a dropdown element. We then used the URL value to do something else: redirect to a page. You can use the value to do something else: continue searching for a different value, etc.).
If you don’t want them to use a dropdown to search, then use an text input element instead. Depending on your coding level, you can create something that searches 1 field, multiple fields, trigger on keypress, trigger on button click, auto suggest, Etc.
Sometimes, it helps when you rewrite a question in the form of a Goal and screenshot what your elements and data look like. Because it could end up being that your question is entirely different, such as: How do i create a search function for multiple fields that is triggered by a button click?
Or: I want to allow users to search my database collection, and want to allow them to search for any field. How do I do this?
Instead of: Populating a dropdown