Enum and Valid_if add new value

What is the trick is the trick to get the add value operational when using enum and valid_if? #stumped

It looks like I can do it as a Ref…is this the only way? This should be satisfactory as I can also sort in a validity statement.

I’m guessing you want a dropdown menu that allows the user to choose from the list of existing (non-Ref) values, while also allowing the user to enter a value that doesn’t already exist. To do that, set the Suggested values property to an expression that produces a list of existing values.


I needed this same capability. I haven’t used Suggested values much. @Steve’s instruction worked for me. I simply moved my expressions from the Valid_If to the Suggested Values and I get the filtered list but can still add new values!