How do I create a drop down where I control w...

expressions
(Daisy Ramirez) #1

How do I create a drop down where I control what the user see’s but it CAN allow other values?

I understand we can use the Valid_if to control the values with a SELECT expression but this prevents other background values from entering the column.

Thanks

(Praveen Seshadri (AppSheet)) #2

If you are using an Enum, there is an option in the column definition called ‘AllowOtherValues’ ?

(Daisy Ramirez) #3

Nn enum. Its a ref field

(Praveen Seshadri (AppSheet)) #4

If it is a ref field, it will give you the option to add a new entry in the referenced table.

It sounds like what you want is really just a text column or something with a dropdown of hints that come from a referenced table.

We don’t have this mechanism.