Build dynamic option values for Nintex choice control

I am using Nintex classic form on SharePoint 2013 list.

Form has following fields in sequence which queries data from master list

1. Region: list lookup to master list

2. Country: list lookup to another master list where mapping between country and Region is available

3. Business unit: another independent master list

=====this is the one with issue====

I have a separate master list where mapping of mapping of region / country / Business unit / LeaseId is present.

4. LeaseID: How do i filter only those LeaseIds based on top 3 fields. Basically its a multicolumn filter.

I am trying to bind filtered LeaseIDs using javascript with no success..

+12

@rajkamal1 try the below approach:

In SharePoint create a calculated column and create a formula e.g. [Region]_[Country]_[bu]

Also in Nintex form, add a calculated control and calculate the formula in all 3 modes and using name control of Region, Country and BU create the same text as in step # 1

Now in your Lease ID lookup control apply the filter of step # 2 to get the items that are qualified

Sign up