Skip to main content
Nintex Community Menu Bar

Form - Hide panel based on look-up column selection

  • October 29, 2020
  • 3 replies
  • 35 views
DannyC
Forum|alt.badge.img+1

Hi All

I am not very good at rules yet and I cant seem to find any cheat sheets  - so hoping someone can help me...

I have a 'product area' field, which is a look-up field (choice value options).

It has multiple values: Banking, Insurance, Investments 

When a user selects any of the values, i want a panel containing information on the other other 2 to hide.

Can anyone advise of the right formula to use for this rule? Or what steps I need to take? 

 

To hide a panel which contains banking information, I have tried hiding based on the following formula's with no luck...

 

1) Product Area!="Banking"

2) not(equals(Product Area, 'Insurance'))

3) not(Product Area, 'Insurance'))

 

Please help!

 

    3 replies

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • October 29, 2020
    HI,

    The first two rules look correct.
    Make sure the rule is associated with the panel that it applies to.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Forum|alt.badge.img+11
    • Nunezma
    • Scholar
    • November 3, 2020

    @DannyC Add a calculated control fx: 

     
    parseLookup(Yourlookupcontrolname,true) and then add a rule to the panel you want to hide, use the calculated control name instead of the lookup  calculatedcontrolname!="Banking"
    Forum|alt.badge.img+12
    • kunalpatel
    • Scholar
    • November 3, 2020

    @DannyC , @SimonMuntz Since the field allows multiple choices, equals won't work. Try using Contains instead.

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