[StockName],[Amount] is it possible to see ...

(Selim Tuncay) #1

[StockName],[Amount]

is it possible to see two column’s values in dropDown list?

(Aleksi Alkio) #2

Do you want to combine them as an one value or do you want a list of values from both columns?

(Selim Tuncay) #3

the point is; i am selling one product from list which i can choose from dropdown list. i want to see quantity of this product near the name like so

“Apple , 2” in dropdown list

(Selim Tuncay) #4

quantity and name columns at the

same row on table

(Selim Tuncay) #5

i want to see the quantity for just information

(Aleksi Alkio) #6

Add a virtual column with CONCATENATE([StockName],", ",[Amount]) and set it as a label.

(Selim Tuncay) #7

i did it already . just i wonder can do it in dropdown list

(Aleksi Alkio) #8

If you mark it as Label, it will show it in the dropdown but it will save the key column’s value to the spreadsheet. Of course you need to use a ref column.

(Selim Tuncay) #9

thank you

(Aleksi Alkio) #10

You’re welcome