cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Contains Formula

Hi

I successfully created a formula yesterday which I use in a rule to hide an item in my form -

!contains(namedcontrol,"text")

However I would now like to change the above to saything like

!contains(namedcontrol,in("text1","text2"))

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

Form Rule Formula Examples

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.

Karen

0 Kudos
Reply
1 Reply
Highlighted
Not applicable

Re: Contains Formula

Hi

I have been looking into this and found this site

https://ootbtutorials.com/2016/02/19/rule-formula-examples-for-nintex-forms/

It helped a great deal with formulas.

My formula I used was

!contains(NamedControl,"Other")&&!contains(NamedControl,"Unregulated")

This has worked successfully.

Karen

0 Kudos
Reply