For an application I am developing, I need to use an enum data type and i need to have about 100 value options that can be selected from the dropdown list. Is there an easy way to add these 100 numbers or do I have to type them physically?
There are multiple required inputs that will also have a similar enum list but different numbers.
A possible approach is to create a table to contain the needed Enum values, then present them as options for your column using a Valid If expression, rather than define each possible value within the column definition itself.
Thanks. I used the Valid if and defined a list of options in it and it worked well for my purposes. Lists deifned as {a, b, c} instead of [a, b, c]
User | Count |
---|---|
43 | |
29 | |
22 | |
20 | |
15 |