Solved

Show panel if either is true

  • 11 February 2021
  • 2 replies
  • 55 views

Badge +3

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 

______________________________________________

 

icon

Best answer by MegaJerk 12 February 2021, 02:34

View original

2 replies

Userlevel 5
Badge +14

Should be fairly straight forward. 

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



(note: the Choice Controls are named as shown) 


 


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



 


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: 



 


Panel being shown when Apples = No



 


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



 


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



 


 


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


 

Badge +3

Thank you!!!

Reply