My need is for Nintex form to dynamically populate the correct Coder and Approver based on matching to 3 columns in SharePoint list.
Nintex Form with:
Need to dynamically populate the Coder & Approver fields when drop downs are selected (changed) by comparing the values selected for "Location", "Department", and the amount entered in "Invoice Amount".
SharePoint list "Approver Detail" with columns:
If you have a coder and approver for above and below a dollar threshold(meaning two coders and two approvers for each location/department) It seems like you may want to do the amount first. After choosing an amount, you then display two of four lookup controls. If it's below the threshold, you show the controls that pull in the lower two people. If it's above, pull the upper. Unless the dollar threshold changes per location/department.