Hello everyone Is it possible to have a drop...

(Xavier G) #1

Hello everyone

Is it possible to have a dropdown list with more information than the user selection ? For instance, I have a list of places with a code and a description. I would like both information appearing in the dropdown as text but only the code will populate the form.

Thx

(Steven Coile) #2

If the column type is Ref, the dropdown will display the values from the LABEL column of the rows from which the dropdown is generated. When the user chooses one, the KEY value from the chosen row will be stored.

(Fernando López) #3

Like +Steve Coile said, you can create a Virtual Column concatenating all the data you want and check it as LABEL