jimneal_ky
Design Dabbler

Trouble using Lookup on repeating section on Nintex Form 2016

Jump to solution

I have a list of Computers that we are being billed for. I have a Nintex form that I have a repeated section that will display all the computers assigned to a particular person (Display Name). On the form, it calculates the Display Name. I attempted to create rules that would populate the computer Make/Model, Serial Number and questions to verify computer info is accurate

Audit_Frm.jpg

 

The List

List.jpg

 

The properties of the calculated field that shows current user:

currentuser.jpg

 

I created the following rule on the Make/Model field

Rile.jpg

 

When I attempt to preview the form the value above does not display - instead I get a #Value error. What am I doing wrong?

 

0 Kudos
Reply
3 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Trouble using Lookup on repeating section on Nintex Form 2016

Jump to solution
Hi,

The third parameter DisplayName does not look like its using the named control as its not coloured red.
As you have the same user multiple times in your list which item would you expect to be returned?

View solution in original post

Reply
jimneal_ky
Design Dabbler

Re: Trouble using Lookup on repeating section on Nintex Form 2016

Jump to solution

Thank you - that worked!

 

Any idea on why only one computer is displaying as opposed to multiple?

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Trouble using Lookup on repeating section on Nintex Form 2016

Jump to solution

Try adding the fifth parameter for the lookup runtime function 'true'.

Example

lookup("theList","theColumn",filtercontrol,"returnColumn",true)

Reply