Displaying multiple columns in a dropdown

[Sarah_Keown]

Hi, I would like to create a dropdown menu using multiple columns from en excel spreadsheet.

I have a selection of dependent drop downs: Product Group > Product > Product Code.

When a user selects their Product Group it filters the products displayed, the Product dropdown displays a concatenated value of Product Code and description, this Product Code selected is auto filled into the form input beneath. These drop down values all come from separate tables in excel i.e. I have multiple product tables with different descriptions, images and codes. These user selected values are input into an Order Details table.

I wonder if there is a way to concatenate the image into the product dropdown; as it stands right now the column types of product group, product and product code are all text and product image is an ‘Image’ column type, however in the form this shows as an image capture input value.

Having the image displayed in the same dropdown as well as insert into the Order Details table as a separate column is what I am trying to do; is there any option to achieve this?

[Dylan_Buttera]

Hello! Did you ever figure out if multiple columns in a single dropdown, as you described, is possible with appsheet? I may be interested in doing something like this in an app I am working on currently.

Thanks in advance!