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.
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.
Solved! Go to Solution.
I may have fixed it with the suggested values section.
This did the trick!
VALID_IFs don’t work that way. Try Suggested Values.
Edit: oh, you got it, right as I posted it.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |