Skip to main content
Nintex Community Menu Bar

evaluate multiple columns with contains function

  • December 6, 2017
  • 3 replies
  • 1 view
K
Forum|alt.badge.img+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

    R
    Forum|alt.badge.img+8
    • rogerb
    • December 6, 2017

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

    K
    Forum|alt.badge.img+5
    • koolgeex
    • Author
    • December 6, 2017

    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.

    E
    Forum|alt.badge.img+14
    • emha
    • Scholar
    • December 6, 2017

    try:

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

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement