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!
User | Count |
---|---|
40 | |
29 | |
22 | |
20 | |
15 |