I am trying to hide/show a panel based on two different columns. I have a columns called Inquiry Topic with 5 options and another column called Size with 2 options. Both columns are choice fields. If a user selects Inquiry Topic = Option 1 and Size = Small then I want to show panel but if they select Inquiry Topic = Option 1 and Size = Large then I want to show a different panel and keep the other hidden. I have tried a number of rules and haven't been able to get this to work so hoping someone here can help.
Nintex Form Rule to Hide Panel based on multiple columns
+1
+12@sf1173nyc .....you'll have to use and and not function
Hide Panel 1: not(and(Topic == "Option 1",Size == "Small")) - This will hide the panel 1 if both options are not true.
Hide Panel 2: not(and(Topic == "Option 1",Size == "Small")) - This will hide the panel 2 if both options are not true.
Now if your choice columns allow multiple values then instead of equal you'll have to use contains.
+1Thanks for your help I tried your first example for a rule on my first panel and its does hide it but it doesn't show when statement is true. This is what I have:
not(and(Topic=="General",Size=="Small"))
When I preview the form the panel is hidden but when I select General for Topic and Small for Size it doens't show up.
+1I should have used contains as you noted in the buttom on your post. I finally got it to work using the following:
not(and(contains(Topic,'General'),contains(Size,'Small')))
and using this for the other panel:
not(and(contains(Topic,'General'),contains(Size,'Large')))
Thanks for your help it is much appreciated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.