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?
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.
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?
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
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?
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |