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

[Selim_Tuncay]

[StockName],[Amount]

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

[Aleksi_Alkio]

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

[Selim_Tuncay]

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]

quantity and name columns at the

same row on table

[Selim_Tuncay]

i want to see the quantity for just information

[Aleksi_Alkio]

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

[Selim_Tuncay]

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

[Aleksi_Alkio]

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]

thank you

[Aleksi_Alkio]

You’re welcome