Hello, I have a leave request form that has a tick box needs to be ticked when employee require flight tickets. I need to add a field that is only visible when the employee ticks the box. I have added the filed in a control panel and as I know I need to add formula to it. Any suggestions?
Hiding and showing fields in a form
+2
+5Hi @FatmaQ,
Select the panel, then click Add Rule. Name it something like, "HideNoFlight". It's a formatting rule. Enter the formula not(TickBoxControlName=="Yes"), then check the box below that says, "Hide".
Select the panel, then click Add Rule. Name it something like, "HideNoFlight". It's a formatting rule. Enter the formula not(TickBoxControlName=="Yes"), then check the box below that says, "Hide".
+2Hello @cherylshah, thanks for your help. I have entered the formula you provided and now it is hidded but when I click on the checkbox the field doesn't appear.
+5Sorry about that @FatmaQ - I can never remember exactly how checkbox values work. Try:
not(TickBoxControlName=="1")
and see if that works?
not(TickBoxControlName=="1")
and see if that works?
+5Also, please use the formula builder button (in red box in this screenshot):
In the Formula Builder, use the Named Controls tab to pick the name of your checkbox control
So the formula will look something like this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.