cancel
Showing results for 
Search instead for 
Did you mean: 
khalidinio
Nintex Newbie

Check if checkbox is checked in formula in a form variable

We are using SharePoint 2013 with Nintex 2013. I have a form with a panel. Inside the panel I have 2 controls. The target is that if one of these 2 controls in the panel is selected the "description" control will be visible. For the dropdown it is working fine, but not for the checkbox. How can I check in a formula if a checkbox is checked?

 

This is my formula expression at this moment. It returns if panel1 is completed or uncompleted.

 

If(isNullOrEmpty(DropDownControl1), uncompleted', 'completed')

 

I try to extend this expression with something like this but it dont work:

 

If(not(isNullOrEmpty(DropDownControl1)) || CheckBoxControl1, 'completed', 'uncompleted')

 

nint.png

Labels: (1)
0 Kudos
Reply
6 Replies
mlauer
Nintex Newbie

Re: Check if checkbox is checked in formula in a form variable

a Yes/No control evaluates to true if checked otherwise to false. So use control name in formula:

 

If(not(isNullOrEmpty(DropDownControl1)) || CheckBoxControl1

0 Kudos
Reply
khalidinio
Nintex Newbie

Re: Check if checkbox is checked in formula in a form variable

Hi @mlauer , I try this but dont work:

 

If(not(isNullOrEmpty(DropDownControl1)) || CheckBoxControl1, 'completed', 'uncompleted')

0 Kudos
Reply
mlauer
Nintex Newbie

Re: Check if checkbox is checked in formula in a form variable

Following formula is working in a calculated value Control or in a forms variable:

If(not(isNullOrEmpty(DropDownControl1)) || CheckBoxControl1, 'completed', 'uncompleted')

You have to insert named controls by formula builder. So they are shown in red.

0 Kudos
Reply
khalidinio
Nintex Newbie

Re: Check if checkbox is checked in formula in a form variable

Hi @mlauer ,

 

I did use the formula builder and the controls are red. So at this moment I dont see a differance between your example and mine.

0 Kudos
Reply
khalidinio
Nintex Newbie

Re: Check if checkbox is checked in formula in a form variable

Does someone know why it is not working? Or can someone reproduce this problem?

0 Kudos
Reply
Automation Master
Automation Master

Re: Check if checkbox is checked in formula in a form variable

 The target is that if one of these 2 controls in the panel is selected the "description" control will be visible

 

so I guess you're talking about formatting rule's formula, right?

in that case the formula should look like (note the formatting rule hides the control)

 

isNullOrEmpty(DropDownControl1) && not(CheckBoxControl1)

 

0 Kudos
Reply