Enum Dropdown New Values & Valid_If

[Cmath06]

Hey All,

I currently have a form with an input. The input type is an enum. I have it set to allow new values. I am trying to make it show the previous values used in the enum field. I only want the values that pass a valid If to show. The problem I’m running into is that i also want to be able to add new values to that enum field. With my current expression, I can get the previously used values but can add new.

This is the value that passes the valid if but doesn’t allow new values.

My current valid_if expression is this"
SELECT(RA Active Status[RA Number], [Active] = 1)

Looking for it to be:
SELECT(RA Active Status[RA Number], [Active] = 1) - OR allow new values

This function is true when the active status for a previously used value is 1. When it is 0 for that specific RA number it won’t show in the enum list. Is there a way to modify my expression that says if the value is 1 then show but also allow new values? Any insight would help as I am lost.

[Cmath06]

Cmath06:

SELECT(RA Active Status[RA Number], [Active] = 1)

I may have fixed it with the suggested values section.

[Cmath06 · Accepted solution]

This did the trick!

[Bahbus]

VALID_IFs don’t work that way. Try Suggested Values.

Edit: oh, you got it, right as I posted it.