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

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

0 3 291
3 REPLIES 3

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

Nn enum. Its a ref field

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.

Top Labels in this Space