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.

0 2 172
2 REPLIES 2

Steve
Platinum 4
Platinum 4

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!

Top Labels in this Space