evaluate multiple columns with contains function

  • 6 December 2017
  • 3 replies
  • 1 view

Badge +5

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?


3 replies

Badge +8

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

Badge +5

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.

Userlevel 5
Badge +14

try:

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

Reply