Forms Lookup List - showing info from other columns

  • 1 February 2021
  • 1 reply
  • 4 views

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?


1 reply

Badge +4

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