Add or Search Option

[sonam2]

Hello team,
I am getting an “add or search” option for columns having Enum data type which is not required.
I have even set the option “AllowOtherValues” to FALSE. refer below screenshot.

So I would like to know that how I can remove this “add or search” option?

[Marc_Dillon]

I would double-check that you really did de-select the “allowothervalues”.
I tested it just now, and de-selecting that did indeed get rid of the “add or search” option.
Also be aware that the search box only goes away when the amount of options is less than the amount that would require a scroll-bar.

Also, if you set the input mode to “Buttons”, then there’s no add or search option, but it only looks good for very small number of options.

[Qiro]

Reviving this thread from the dead! 👻

I'm having the same issue with an ENUM list using suggested values. The 'add or search' option is appearing when it shouldn't. Adding a new item would actually break the system.

Any ideas?

[Steve]

Don't use an Enum column, use the base type instead. Then use Valid If to generate the list of allowed values.

Drop-down from Valid_If - AppSheet Help

[1minManager]

Is this possible though if you also need to have other VALID_IF conditions such as making sure the selection in this column doesn't match the selection in another colum?