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?
