Is there a way to build an enumerated selection list for a field from column values in a spreadsheet?
Solved! Go to Solution.
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!
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!
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |