Is there anyway in Nintex forms that one can show unique values from the lookup if there are duplicates?
For example if I have a list like this:
South Africa Cape Town
South Africa Johannesburg
South Africa Durban
In my first drop down I want to show countries but I only one to show 1 South Africa not 3. Is there a functionality like this on Nintex Forms?
Solved! Go to Solution.
The only way to achieve this is :
- Create a "Countries" list with unique entries
- Create a "Cities" list, with lookup "Country" column on first list
then your dropdown 1, based on Countries list will show unique values, and can be cascadind with second dropdown requesting CIties list.
Detailed sample here Cascading drop downs and Nintex Forms for SharePoint