AnsweredAssumed Answered

Duplicate Removal

Question asked by burnsmh on Nov 29, 2018
Latest reply on Nov 30, 2018 by flocke

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?

Outcomes