Sql Lookup tool and Making it required field

  • 24 January 2017
  • 4 replies
  • 1 view

Badge +3

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.


4 replies

Badge +10

Hi Craighton,

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

Badge +3

I used this for the validation on the sql object

197982_pastedImage_1.png

Here is the rule I created

197983_pastedImage_2.png

Userlevel 6
Badge +15

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

Badge +1

Hi all

 

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

 

Thanks 

Ren

Reply