Skip to main content
Nintex Community Menu Bar

Best practice: 7,000 item list lookup

  • June 13, 2019
  • 1 reply
  • 8 views

arielle_kay
Forum|alt.badge.img+1

We have multiple fields on a list to populate a charge code scenario below: 

  1. First the user selects the Department they are ordering from 
  2. Then a drop down appears for them to select a Charge Code Category associated with the Department
  3. From there another drop down appears for them to selected an associated Charge Code Description 
  4. After those 3 are selected the actual CHARGE CODE should appear for what they are purchasing 

The problem is the charge code list has about 7,200 items.   What is the best way to achieve our goal here?  

THANK YOU IN ADVANCE!

1 reply

Forum|alt.badge.img+11
  • Nintex Partner
  • July 4, 2019

Assuming the Charge Code list has all 3 selected data items (as text column) as well, you could consider having a calculated column concatinating the 3 selected criteria and use in your form a lookup with the 3 selected values concatinated as filter....

Otherwise the somewhat complexer solution of using JavaScript is also a possibility.