cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Duplicate Removal

I am using the responsive version of Nintex Forms with Sharepoint.

The problem I am having is this.

(LIST) Facility: 

Public School

Private School

University

(LIST) Room Number:

101 

102

203

204

305

306

FORM

Pick a Facility:

(DROP-DOWN SELECTION)

Pick a room number:

(DROP-DOWN SELECTION)

I need the Facility not to contain duplicates but I cant filter them out with Javascript because the responsive forms dont let you use javascript. What ends up happening is I build the Room Number list out with an additional column that links to the facility.

(UPDATED LIST) Room Number

101 - Public School

102 - Public School

203 - Private School

204 - Private School

305 - University

306 - University 

What ends up happening is this:

Pick a Facility:

(DROP-DOWN SELECTION)

Public School

Public School

Private School

Private School

University

University

Pick a room number:

(DROP-DOWN SELECTION)

- TL;DR it doesn't filter this part correctly.

BUT

if I do it in the reverse and tell it to do 

Pick a room number:

(DROP-DOWN SELECTION)

Pick a Facility:

(DROP-DOWN SELECTION)

It works fine, because I am assuming, the room numbers are a unique value. But I need it to sort the facility first then give me my options for room number.

I would I could send screenshots but my company is super confidential.

Anyone run into this? How have others solved the duplication issue?

0 Kudos
Reply
3 Replies
Workflow Hero

Re: Duplicate Removal

This is confusing. 

Are you using a List Lookup Control, or a basic Choice Control set to 'Dropdown'? 

Can you perhaps make a Test Form that has the same issue but with fake data / names so as to not break confidentiality. 

It seems like a fairly simple cascading drop-down, so I must figure that it's something tiny that is just tweaked a little wrong somewhere. 

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Duplicate Removal

Hi

I had the same struggle some time ago. 

There are 3 Lists for me.

1. Art.Nr

2. Position

3. Merged list with two lookup column from Nr.1 and Nr.2

Then i made a Site worklfow form to query the merged list. 

Rule from the lookup field:

replace(lookup('LISTNAME', 'COLUMN TO FILTER ON', perselookup(NAME FROM DROPDOWN, true), 'OUTPUT COLUMN', true), '[0-9]*;#','')

Then you should see the unique values.

Hope it helps

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Duplicate Removal

I'd say that's matter of improper design...

your design should look like:

- list of facilities (single/unique entry per each facility), eg

Public School

Private School

University

- list of rooms (single/unique entry per each room), eg

101 

102

203

204

305

306

- list of rooms per facility (single/unique entry per each combination of facility and room). room number field and facility field have to be lookup fields connected to list of facilities and list of rooms respectively.

eg.

101 - Public School

102 - Public School

203 - Private School

204 - Private School

305 - University

306 - University 

- facility form control should be populated from list of facilities (or from a lookup list field connected to list of facilities)

- rooms form control should be populated form list of rooms per facility (or from lookup list field connected to list of rooms per facility) and filtered by facility control on FacilityLookup field

this concept is being refered to as 'cascaded dropdowns'. you can search through the forum on that, there are plenty of good examples.

see eg. two of them - very detailed

 

Three-Tier Cascading Drop Downs: Do Go Chasing Waterfalls! 

0 Kudos
Accept as Solution Reply