Hello, I have an Enum column where I have allow other values set to on but when a user adds a new value, it doesn’t get added to be able to be used again. It only works for that one row. Is this a bug or what am I doing wrong?
1 Like
Hello @Dylan_Nicholson,
Welcome to the AppSheet community!
I researched on this and I found that instead of hardcoding your list in the Values box - like we normally do -, you need to indicate AppSheet to look at the data already saved in that column to build the list. Here’s how I did it:
-
In the App Editor, go to Data > Columns and find your
Enumcolumn. -
Open the column settings (pencil icon).
-
Scroll down to Suggested Values (do not use the “Values” list for this).
-
Enter the following expression: UNIQUE(TableName[ColumnName])
Let me know how it goes please and welcome again!
3 Likes
Hello! Thank you, I will try that!
3 Likes
You could also use Valid if, instead.
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.