In conjunction with this trigger request for dropdowns, It would be nice if a Single Select widget could support multiple columns.
Also possibly show only one of the columns but it stores two.
The idea is that I have
- a list of department descriptions and department codes,
- and a list of employees assigned to the department code
The codes are ugly, but no one usually sees them, so who cares. But:
- I need the code to filter the list of employees
- I want the “single select” to display the description, not the code
- But I want the return value (stored in a variable) to be the code