Data Entry

[RickPenna]

Hello AppSheeters,,

I am Rick a NewB, loving AppSheet,

I have a question about entering data into a form, I have a table (Product) with 5 columns, ProductId, Brand, Product, Color and image. I am thinking about data entry, for super lazy/efficient people like me, so I make brand Enum, because it has only 3 brands, but I have many products, and sometimes, I need to enter the same product for a different color, so I was thinking if I can have dropdowns for product and color, containing the existing products and colors, without creating a Enum. Please take a look in the pictures it may help to understand, the situation, thanks.      

[Marc_Dillon]

You want to create an Enum without creating an Enum? Huh? Why?

[RickPenna]

OK, So, Enum is the only way to generate this kind of dropdown? My idea is, I already entered many products, so if I can have access to that list of products already enter manually, in a dropdown, I don't need to type again, I would just to pick the color, because the same product has different columns. So as well it brings another question about the same topic, is there any way to get a suggestion of products based in my initial typing?    

[Marc_Dillon · Accepted solution]

>>"OK, So, Enum is the only way to generate this kind of dropdown?"

I did not say that. I was just confused about what you're wanting to do.

Try this:

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if