Skip to main content
Nintex Community Menu Bar

Sql Lookup tool and Making it required field

  • January 24, 2017
  • 4 replies
  • 7 views

Forum|alt.badge.img+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

Forum|alt.badge.img+10
  • January 27, 2017

Hi Craighton,

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


Forum|alt.badge.img+3
  • Author
  • January 27, 2017

I used this for the validation on the sql object

197982_pastedImage_1.png

Here is the rule I created

197983_pastedImage_2.png


rhia
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • January 29, 2017

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


Forum|alt.badge.img+1
  • July 16, 2020

Hi all

 

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

 

Thanks 

Ren