Skip to main content

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


9403i9B9A0619E6BAE508.jpg


 


The List


9404i185EFDB1E2048E74.jpg


 


The properties of the calculated field that shows current user:


9405i9006486B8A75DA60.jpg


 


I created the following rule on the Make/Model field


9406i2C0DFB98900818A9.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?


 

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?

Thank you - that worked!


 


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


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


Example


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


Reply