AnsweredAssumed Answered

lookup function with parseLookup on Nintex Form 2013

Question asked by kbsitz on Sep 12, 2018
Latest reply on Sep 21, 2018 by kbsitz

I'm using a "Calculated Value" form control with a lookup function along with the parseLookup function to pull information from a Vendor list.  Sometimes the Vendor list does not have values in all the fields (ie:  "Contact Name" or "Fax" may be empty) which results in #Value! on my form.

 

I have unsuccessfully tried IsNullorEmpty(ControlName) rules to hide any blank answers.

 

Examples of my lookup function:

lookup("PReq XTbl Vendor", "Name - Biz Partner No", parseLookup(Vendor), "Contact Name")

 

Question:

How can I either hide the #Value! on my form when there is no returned value from the lookup function

-or-

How can I only run the lookup when there is a value to return

 

Either of the above should be viable solutions in my scenario.

Outcomes