Enumerated select list populated from column values

Is there a way to build an enumerated selection list for a field from column values in a spreadsheet?

Solved Solved
0 2 115
2 ACCEPTED SOLUTIONS

Yes. Please use valid_if constraint. It is generally expected that the column values are in a single column.

Drop-down from Valid_If - AppSheet Help

So the general valid_if syntax for an enum list through lookup values in a column in a table will be 

Table_Name[Column_Name]

where [Column_Name] contains enum values to be shown as options in the enum column.

 

View solution in original post

Yes, thank you!  Had to make the "base type" enum as well to have it show up as a drop down. 

Thanks again!

View solution in original post

2 REPLIES 2

Yes. Please use valid_if constraint. It is generally expected that the column values are in a single column.

Drop-down from Valid_If - AppSheet Help

So the general valid_if syntax for an enum list through lookup values in a column in a table will be 

Table_Name[Column_Name]

where [Column_Name] contains enum values to be shown as options in the enum column.

 

Yes, thank you!  Had to make the "base type" enum as well to have it show up as a drop down. 

Thanks again!

Top Labels in this Space