Skip to main content
Nintex Community Menu Bar
Question

Nintex form validation based off another fields input


Forum|alt.badge.img+1

Hello,

 

I am trying make one of my fields required based off of the input in another field. 

I would like for the C4C OPP ID# (highlighted in green) to be mandatory if the Estimated Quote Amount (highlighted in yellow) is greater than or equal to 25000. 

 

I have been googling solutions and reading a bunch of validation wikis, but I can’t seem to get it to work. I am new to Nintex and have been assigned the “admin” role within my company, so I have users coming to me to fix their forms or make changes. 

 

I have the following rule setup, but it doesn’t seem to give me the result I am looking for:

I put this rule on the C4C OPP ID# control since this is the field I want to make required based on the input of the other field.

 

Does anyone have any solutions or recommendations?

Translate
Did this topic help you find an answer to your question?

6 replies

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 463 replies
  • March 24, 2023

You are on the right track. Try the Condition below in your Validation rule. It works for me.

and(isNullOrEmpty(C4C OPP ID),greaterThanOrEqual(EstimatedQuoteAmount,25000))

 

 

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • 3 replies
  • March 24, 2023

@bamaeric Thank you for such a quick response!

 

I tried the solution you mentioned above and I am still not receiving a pop up message letting users know that the C4C OPP ID# box is required at that $ limit:

Note: I did try using {Self} instead of ‘C4C OPP ID’, but both produced the same result.

 

I did not receive the error message that I put into that box, nor did it stop me from submitting in this preview mode.

 

Is it possible that something on the SharePoint side is preventing me from using this validation or should Nintex override any SharePoint rules?

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 463 replies
  • March 24, 2023

What are the names and field types of the C4C OPP ID# and Estimate Quote Amount fields?

Did you just copy my condition formula or did you add the controls to the formula via the Named Controls tab?

Below are the results I see from the form in Preview mode using the configurations in my screenshots:

 

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • 3 replies
  • March 24, 2023

@bamaeric 

In SharePoint, these are the names and format: 

 

I manually typed the formula and chose the controls from the ‘named controls’ tab.

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 463 replies
  • March 24, 2023

You’re correct in that controls in the formula should come from the Named Controls tab. Could you add screenshots of the Control Settings of the two controls so I can see their configurations (Name, Connected to, etc.)?

Does anything happen when you enter a number less than 25000?

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • 3 replies
  • March 24, 2023

@bamaeric 

C4C OPP ID Control settings:

 

EstimatedQuoteAmount Control Settings:

 

I do not receive anything different/new when entering in a number less than 25000 either.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings