I would like to show a dropdown with two colu...

(Yossi Oulu) #1

I would like to show a dropdown with two colums, e.g. item catalog# And item description. Once the user select an item the item catalog# should be returned back as a result. How do I do that?

Thanks Yossi

(Aleksi Alkio) #2

You can do that with a ref field. Your ref table should have a virtual column where you concatenate catalog# and description. When you choose this virtual column as a label and the catalog# is a key column, you will have that result. Another question is if that column catalog# can be the key column.

(Yossi Oulu) #3

Hi Aleksi, This is indeed what I was trying, but it does NOT work. I get back the virtual column not the catalog# (which is the key).

(Aleksi Alkio) #4

When you use the label feature, it will save the key column’s value to your database but it will always show the label value with your app. It seems that you want to use the label value in your dropdown, but when you have chosen the value and saved it, you want to show the key column’s value in the app, is this correct?

(Yossi Oulu) #5

OK. Thanks a lot! Works! I wasted lots of time on this.

All I had to do is look at the database

:slight_smile: Thanks for the clarification.

(Aleksi Alkio) #6

You’re welcome