cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
craighton
Nintex Newbie

Sql Lookup tool and Making it required field

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.

0 Kudos
Reply
3 Replies
sojanm
Nintex Newbie

Re: Sql Lookup tool and Making it required field

Hi Craighton,

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

Reply
craighton
Nintex Newbie

Re: Sql Lookup tool and Making it required field

I used this for the validation on the sql object

Here is the rule I created

Reply
Automation Master
Automation Master

Re: Sql Lookup tool and Making it required field

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

Reply