Multiple columns in single select

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:

  1. I need the code to filter the list of employees
  2. I want the “single select” to display the description, not the code
  3. But I want the return value (stored in a variable) to be the code
1 Like