Skip to main content

New to Nintex (2013) and hopefully an easy one to answer - I have a cascading lookup list which works fine. It displays a list of Surnames, filtered by Dept. Problem is there are several people with the same surname. How can I show some extra details (first name, job role etc) either in the drop down list or shown elsewhere on the form when the surname is selected?

Two ways you can do this:



 



1) In your source lookup list, create a calculated column which concatenates all the details into one column. Then direct your lookup to that calculated column. 



 



2) Have a calculated control on your form and use the 'lookup' function within it. This works similar to a vlookup in excel. You can use your lookup control as the filter value to pull back the other values from your source lookup list.


Reply