The Query Based Dropdown List is great - but I’d like to be able to choose from something human readable but pick a different column (ie a numeric ID) for the result.
Such that I might have a query:
select concat(firstname, " “, surname, " (”, company, “)”) name, id from users;
and when I pick “Joe Smith (Aardvark Ltd)” from the list then the parameter will be populated by that persons numeric id from the id column.