Skip to main content
Nintex Community Menu Bar

Need a Yes/No Checkbox to be required based off column list field selection

  • August 28, 2019
  • 19 replies
  • 349 views
  • Translate All

Forum|alt.badge.img+3

I created an onboarding form in Nintex which I need to have a checkbox (outlined in the below) be required when the user changes the form status from Open to Completed. 

4149iF23E4848195EDD93.jpg

19 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23

Hi,

All that would be required would be to have a rule on the Check Box. In my rule "Status" is the name of the control which has the choice.

equals(Status,"Completed")

Please see my sample form attached if required.

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • August 28, 2019

I added that into a rule for the checkbox, but it doesn't make it required if the status equals Completed.  It still allows me to save the form without checking it.

 

I wasn't able to open your example, but I've included a screen shot of the rule I setup as you recommended.  Clearly, I am missing something. :)

  4156i448FDAC9F03A86B7.jpg

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
Hi,
The rule type needs to be Validation and not Formatting.
Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • August 29, 2019

Hi again,

 

Thanks for the clarification.  I switched it to validation and then added an error message for users.  It triggers appropriately on the form, but won't let me save it once I check the Yes box.  Screen shot included.

 

4169iD360A3720EE4C65A.jpg

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
Hi,
What is the rule that you are using now?
What was the issue importing my test form?
Can you provide an export of your form?
Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • August 30, 2019

Hi - below is a photo of the rule.  When I tried to open your zip file it opened as an HTML and I couldn't decipher what it was saying.

 

4180iD46F01DFED81F208.jpg

 

 

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
Hi,
To view my sample form you will need to unzip it.
Then in SharePoint open the Nintex forms designer and select Classic Form.

From the ribbon click import and then import the file you extracted from the zip.
You can now bring up the rules panel and see how I have configured things.
Preview the form to test or publish and test on your list.
Your rule looks correct but it may not be associated to the correct control.
Following the process above you can open your form in the Nintex forms designer and click the Export button from the ribbon to export your form. Save it and zip it and attach it to a post on this thread and I can look at it for you.
Translate

USMCdave
Forum|alt.badge.img+3

The green check to the right of the rule name indicates it's associated with any controls selected on the left.  If any field other than the checkbox is selected, it won't work (even if the checkbox is ALSO selected).

Try deleting the rule, then selecting the checkbox only, them recreating the rule.

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • September 3, 2019

Hello,

 

I was able to import your example; however, I still had the same issue with the form not saving even if I check the Yes box.  You can see in the screen shot below that even when I select Completed for the Status and check the Yes box, it still shows as an error and won't save the form.

 

4230iBDCA4EF66F537364.jpg

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • September 3, 2019

Hello,

 

The rule is only associated to that checkbox.

 

Thanks

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • September 3, 2019

Hi,

 

The rule only needs to be associated with the text box as this is the requred control.

I have redone the test form.  I made a mistake where I was only looking at the choice control and forgot to look at the checkbox as well.

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • September 4, 2019

Hi Simon,

 

I was able to import your Checkbox Validation and it works as designed; however, I am still not able to get my form to work.  I've attached the export file to this thread for you to review. Let me know if you need anything else.


Thanks,
Katie

Translate

Forum|alt.badge.img+16

I think your issue is that you are validating when Status = Completed only.  You need to be validating when Status = Completed AND checkbox is unchecked:

and(not(chkConfirm), equals(ddStatus, "Completed"))

4251iBB0B441AFD833A4D.png

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • September 4, 2019

Can you explain what the chkConfirm and ddStatus mean?  I entered this into my form exactly as you wrote it and it still isn't working as I would like it to :(

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • September 5, 2019

Hi,

 

Your rule was not working because you still had custom validation in the control configuration itself which was overriding the rule. Also the "Yes" in your rule was not red so it looks like it was not referenced.

I fixed it up and attached your form.

Translate

Forum|alt.badge.img+3
  • Author
  • Nintex Partner
  • September 9, 2019

It works!!!  Thank you so much!

Translate

Forum|alt.badge.img

Hi,

I am trying to check yes/no box whenever users click on choice drop down. Please see the screen shot.

 

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23

@vishalshyam unless you use Javascript and a classic form you cannot check a Ye/No control based on a Choice control in Nintex forms on-premise.

Translate

USMCdave
Forum|alt.badge.img+3

Others are correct, that you need JavaScript in classic forms.  However, it looks like, from your screenshot, your check box is an affirmation by the user.  Kind of like a terms of service agreement.  In this case, automatically checking the box will nullify the purpose of it.  Unless I misunderstand the purpose...

Translate