Skip to main content
Nintex Community Menu Bar

Forms Lookup List - showing info from other columns

  • February 1, 2021
  • 1 reply
  • 10 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

hejones50
Forum|alt.badge.img+4
  • Novice
  • February 26, 2021

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.