cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
koolgeex
Nintex Newbie

evaluate multiple columns with contains function

Jump to solution

I have column A (It is a choice type column with 3 options - Z, X, or Other)

I have column B (it is a choice type column with 3 options - U, K, Other)

I have coluimn C (It is a single line of text column)

If Column A OR Column B has "Other" checked off, then column C should show.

I have tried this rule applied to the panel for columns C:

  • not(contains(ColumnA, "Other")) || not(contains(ColumnB, "Other"))

What's the proper syntax?

Reply
3 Replies
rogerb
Nintex Newbie

Re: evaluate multiple columns with contains function

Jump to solution

I have tried the syntax above and the rule always resolves to true.

0 Kudos
Reply
koolgeex
Nintex Newbie

Re: evaluate multiple columns with contains function

Jump to solution

Right now i have that as a rule and it only shows my panel if BOTH column A and B have Other marked at the same time. I need it to work if Either OR is selected, not both.

0 Kudos
Reply
Automation Master
Automation Master

Re: evaluate multiple columns with contains function

Jump to solution

try:

not(contains(ColumnA, "Other") || contains(ColumnB, "Other"))

Reply