imflowers
Forms Fledgling

Show panel if either is true

Jump to solution

I need help writing a formula for the following scenario.

I need the Hidden Panel to show 

1. When Do you like apples = No or

2. When Do you like apples = Yes + What color is your car = Black

What color is you car is also hidden and will display only when Do you like apples is Yes

___________________________________________________________

Do you like apples?

Yes

No

 

What color is your car?

Red 

Black

 

Hidden panel 

______________________________________________

 

0 Kudos
Reply
2 Replies
MegaJerk
Automation Master
Automation Master

Re: Show panel if either is true

Jump to solution

Should be fairly straight forward. 

Here I have a simple form with Two Choice Controls and One Panel:

MegaJerk_0-1613092720673.png

(note: the Choice Controls are named as shown) 

 

For the Panel, I have placed single Formatting Rule called "Hide Panel":

MegaJerk_1-1613092808016.png

 

Which contains the following Formula:

!({control_Choice_Apples} === "No" || ({control_Choice_Apples} === "Yes" && {control_Choice_CarColor} === "Black"))

(note: I have shown my Control References inside of Curly Braces {} to indicate where you need to replace those values with your own named controls. you do NOT need to enclose your references with curly braces!!! they are only for show!)


This essentially wraps the conditions of when we DO want the panel to show, and inverts the result so that it Hides whenever those conditions are not met. 

Ultimately it results in the following: 

MegaJerk_2-1613093533633.png

 

Panel being shown when Apples = No

MegaJerk_3-1613093547753.png

 

Panel being hidden when Panel = Yes, and Car Color doesn't = Black

MegaJerk_4-1613093555820.png

 

Panel being shown when Apples = Yes, and Car Color = Black

MegaJerk_5-1613093566798.png

 

 

 I hope that this helps you to accomplish what it is you're trying to do. 

 

View solution in original post

0 Kudos
Reply
imflowers
Forms Fledgling

Re: Show panel if either is true

Jump to solution

Thank you!!!

0 Kudos
Reply