Suggested Values turns on allow other values

AppSheet AppSheet Q&A
, ,
1

Hi all

I have the following formula in the “Suggested values” field in an Enum Type column.

if(
 IN(CONTEXT("View"), LIST("Ticket_Nicht Verrechnet")),
 LIST("5B_Nicht verrechnet"),
 List(
  "00_Neu",
  "01_Angenommen",
  "02_Termin",
  "03_In Arbeit",
  "04_Geschlossen",
  "90_On hold",
  "91_Eskaliert"
 )
)

As soon as I have a formula in there, AppSheet automatically adds the “Add” to the Enum search altough, “Allow other values” is not ticked.

eddie61_1-1670574599578.png

eddie61_0-1670574577125.png
eddie61_0-1670574577125.png329×196 5.29 KB

Is this a bug, or am I missing something?

Regards,

Adrian

2

Please take a look at the article and the excerpt from the article below

Configure suggested values for a column - AppSheet Help

Suvrutt_Gurjar_1-1670579452190.png
Suvrutt_Gurjar_1-1670579452190.png907×117 18.6 KB

1 Like
3

I didn’t read that article carefully enough. My bad and thanks for pointing it out to me @Suvrutt_Gurjar

Do you thinkt the best practice would be to write a Valid If formula like this (with all the ENUM values):

or(
 [Status] = "00_New",
 [Status] = "01_Angenommen"
)
4

You are welcome. If you are looking for multiple but different enum options depending on views, even the expression with LIST() values you have mentioned in the first post looks good.

Valid_if options through list will be constraining, the users cannot add option outside the list presented to them.

1 Like
5

Alright, thank you. Users shouldn’t be able to add new [Status] values to this enum, so the combination of suggested values and valid if seems to work.

2 Likes