"Allow other values" not working! ENUM column w/Valid_if

[NPKyle]

Hello,

In my current project I have several ENUM columns with Valid_If expressions to generate dropdown selections. All of these columns are set the same, with “Allow other values” and “Auto-complete other values” turned ON, however, on one of my columns the option to add another value is unavailable. This function is working well on all columns except for one, and for the life of me I can’t figure out why.

Any help is greatly appreciated!

-Kyle

[Steve]

If you have a Valid If expression, it will limit what other values will be allowed. Does your expression allow new values?

[NPKyle]

My valid_if constraint is formatted : UNIQUE(TABLE[COLUMN])

I have also tried using just TABLE[COLUMN] but still haven’t gotten it to function properly.

While I waited for a reply to my answer I moved on to some other columns that I need the same function from, instead, using a Valid_If expression formatted: SELECT(TABLE[COLUMN],…) where I’m also unable to get the “Add new value” option.

Are these expressions correct?
Thanks for the reply.

[Steve]

Your Valid If expressions are essentially telling AppSheet to only allow the values listed, despite the Allow other values setting.

Try moving your expression out of Valid If into Suggested values.

[NPKyle]

That makes sense, thank you so much for your help.