An insertion of Enum Values

AppSheet AppSheet Q&A
1

Hi,
I may not be asking the right question online…
I’m wondering if it’s possible to display a dropdown list of the days of the week (I mean, a list of the names of the days of the week) in a number column and set the corresponding weekday number in the column…
If so, can I have a link or an example of how to set up the column?
Thanks for your help…

1 Like
2

You cannot do this in a single column alone. But there are a couple of options to accomplish the same thing:

  1. Use TWO columns. Chose the character based value in one column, then set the numeric value in another column. You actually might find have the text and the number on the row to be helpful.

  2. Create “utility” table with columns for the ID and Name where ID is the row key assigned the numeric value of the day. Set the Name column as the label column. In the view column to select the weekday, define it as REF type and use this utility table to show the dropdown values. This will result in the Name being shown in the dropdown list BUT the row key (or day value) will be assigned as the column raw value.

For more details, see Drop-down on a Ref column

Please ask if you still have questions.

I hope this helps!

1 Like
3

Thanks…
Yes, I already did that. I didn’t want to use two columns, especially since both need to be set to the Data Source…
That’s fine, too…
See you next time…

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.