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
______________________________________________
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.
Thank you!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.