Skip to main content

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!


 

HI,

The first two rules look correct.
Make sure the rule is associated with the panel that it applies to.

@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"









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


Reply