Showing unique data in a list lookup

  • 9 November 2015
  • 1 reply
  • 22 views

Badge +6

Hi Guys


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:

Country.           City

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?


Regards


Bhuti


1 reply

Badge +7

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

Reply