Conditional Dropdown; 2+ sources for dropdown list
It would be nice if we could have conditional dropdowns (not cascading) that will change the datasource/value list depending on the value of a Parent element.
In example, if the Parent value was A, then the dropdown would list Group A values. Likewise, if the Parent value was B, then that same dropdown would now show Group B values.
No, that is not even remotely close to the same thing.
When using a cascading dropdown, where do you select the 2nd data source/table?
I see you can select one datasource, and select a matching field to filter, but there is not a spot to add a second datasource with different values.
If I selected Blue for my parent field, I want to see values from the Blue table. If I select Yellow, I do not want to see blue values - I want to see Yellow values. I am not going to combine the two different tables, because they do not belong together and are completely different from eachother. If I select the parent value for cascading, what datasource would I use for the value list? That's right... can only choose between the two tables, not both. I would have to create a 2nd dropdown.
Aviva Wilen commented
You can do that already by making a separate table with one column for values and one column for parent value, and then using cascading dropdown