Skip to main content

I have SQL look up object that find list of names in a sql database and that works fine.  I want this field to be required but I found a bug where a user can pick a name and then go back and pick default blank user.  It will by pass validation on the field and I added validation in the rules and both of them didn't work making the field required.

Hi Craighton,

What formula did you use in your rule, what is the version of the form

I used this for the validation on the sql object

197982_pastedImage_1.png

Here is the rule I created

197983_pastedImage_2.png

Are you able to show the settings for your look-up?

I'm wondering if the blank is being picked up from your SQL list, or if the blank is input as a default by Nintex. If the latter, I think there's a custom text field there, so then you could instead say "if NotEquals{Self}" -- and if it's coming from SQL, maybe you can exclude it somehow, if the isNullorEmpty isn't picking it up?

Just thoughts for now happy.png

Hi all


 


Did anyone come up with a solution for this problem??


 


Thanks 


Ren

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings