Skip to main content
Nintex Community Menu Bar

Required field based on several separate entries

  • May 14, 2019
  • 2 replies
  • 14 views

Forum|alt.badge.img+1

Is there a way to make a field required based on if any of previous questions is a certain value? For instance, I have 10 or so questions on a form that have the choice of "OK" or "Issue" to select from. Can I have a comment field at the bottom of the form be required if any of those 10 questions are answered with "Issue"?

2 replies

bamaeric
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • May 14, 2019

 

You can accomplish this in Nintex Forms using a Validation rule on the Comments control. Here are the steps:

  1. Select the Comments control and add a Rule.
  2. Give the rule a Name (for example "Require Comments").
  3. Change the Rule Type to "Validation".
  4. Use the formula below in the Condition setting (red underlined fields are your question control names):

    equals(Q1, "Issue") || equals(Q2, "Issue") || equals(Q3, "Issue") || equals(Q4, "Issue") || equals(Q5, "Issue") || equals(Q6, "Issue") || equals(Q7, "Issue") || equals(Q8, "Issue") || equals(Q9, "Issue") || equals(Q10, "Issue")
  5. Add some text to the Message to display if the Comments control is required.
  6. That should cause the Comments field to be required if "Issue" is selection in any of the question fields.

2120i573282CE2EDB8A20.png

2121i5E6DC662AD65CB39.png

 

 


Forum|alt.badge.img+1
  • Author
  • May 15, 2019

Awesome! Got it to work, although for some reason I had to take out the "equals" in the code. Otherwise worked like a charm. Thanks!