I successfully created a formula yesterday which I use in a rule to hide an item in my form -
However I would now like to change the above to saything like
Or something similar, Is this possible? Is there a in or inlist function?
I noted that there was an Inarray function -
!(inArray(ControlName, "Value") || inArray(ControlName, "Value"))
I looked at this post and the one they pointed too
However, when I tried the above it did not seem to work, when I previewed the form it became blank indicating an error. Unfortunately the formula builder does not have a parse button or anything like that to confirm if the formula is correct.
Is any one able to help.
I have been looking into this and found this site
It helped a great deal with formulas.
My formula I used was
This has worked successfully.