How to create dropdowns that leave out values that are selected in previous dropdowns?

Wappler General Need Help
1

Hi!

I need to create a field mapping flow, so let’s say there are two lists:

List 1:
call_id,
user_id,
date

List 2:
callid,
user,
date_created

I want my users to connect the correct fields to eachother with dropdowns.
For a better UX, I’d like selected values not to list again in the next dropdown.

So for example:

Dropdown 1:
callid, (SELECTED)
user,
date_created

Dropdown 2:
user, (SELECTED)
date_created

Dropdown 3:
date_created

The dropdowns are created from a repeat depending on which fields are available, so this changes every time. I tried several ways to do this without any results.

Does anyone have an idea how to achieve this?

2

In your query for the second dropdown, send the value of the first drop down and have a condition in it to not include that value.

3

Hi Jon. Do you mean that I should put a separate server connect api with every dropdown?

4

Hmm. Maybe create an array of all the selected dropdowns and send that to your API and in your condition, use the NOT IN condition and compare it to the array.

5

Yeah I tried that, but then the previous dropdowns lose the values too

6

Sounds like you need to do it all client side, then. Flows might be the way to do this using conditions there but I’ve not tried it myself.

7

I probably would go that way