Question

Nintex form validation based off another fields input

  • 24 March 2023
  • 6 replies
  • 256 views

Badge +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?


6 replies

Userlevel 5
Badge +13

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))

 

 

Badge +1

@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?

Userlevel 5
Badge +13

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:

 

Badge +1

@bamaeric 

In SharePoint, these are the names and format: 

 

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

Userlevel 5
Badge +13

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?

Badge +1

@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.

Reply