Suggested Values - multiple input

AppSheet AppSheet Q&A
,
1

Hi, I have a table of products which as a column with the name “SKU” and another column with the name “Description” in which one corresponds to the other .

I then have a form where a user can choose from a drop down list any product by searching the name of the product.

What I want to know is, is there a way so that the user can search not only the name but also the “SKU” for the product?

Thanks in advance

2

Is the form on the described table, or some other table?

Assuming the latter, is it a Ref column? If so, you can concatenate description and sku in a new column, and set that column as the label.