AnsweredAssumed Answered

Nintex Form: Lookup data from another list

Question asked by larry.saytee on Jun 17, 2016
Latest reply on Oct 13, 2017 by tposzytek

In short, I want to achieve this - https://walkingthestack.com/2013/11/18/lookup/

 

So I wish to do a lookup on a list on the same site and pull in a value. The name of the list is Products. It has Title and Price columns.

 

For the form, I created a drop down lookup field named Product (to represent Items), then I created a calculated column named Price with the formula ("parseLookup("Products", "Id", Product, "Price")"), Qty for quantity then Total (which is Qty times Price).

 

However, I am getting errors. The "Items" drop down works. The "Price" field shows "#Value!" and the Total shows "ID;#Item" as shown in the below screen grab.

nintex-lookup.png

 

 

 

 

 

 

 

 

 

 

 

 

 

I am seeing a lot of blog posts for older version of Nintex forms shows the formula starting with "lookup" rather then "parseLookup". I've even seen - parseLookup(lookup("MyList","ID", MyDropDownControl, "MyFillInColumn"), true).

 

Which is correct? What is the best way to use the parseLookup formula in a calculated field?

 

In short, I want to achieve this - https://walkingthestack.com/2013/11/18/lookup/

Outcomes