Dropdown Ref with more rows to show

[reggieneo]

Hi All,
My Materials is a dropdown ref from the Product table. when filling up options from the product name dropdown, I would like to see the QTY of each item. so that if there not enough qty then I will exit the form. How can I do that? thanks

[Suvrutt_Gurjar]

Does the product table contain a column for the quantity remaining for that product?

[reggieneo]

yes Suvrut. actually it is named [Total Available]

[Suvrutt_Gurjar · Accepted solution]

Please explore below.

Please create a VC with an expression something like CONCATENATE( [Product Name], " QTY- ", [Total Available]) and please assign this column as label column.

The drop down column should reflect with quantity as well.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

[reggieneo]

Suvrutt_Gurjar:

CONCATENATE( [Product Name], " QTY- ", [Total Available])

Thanks, it works.