gaelyvin999
Scholar

Remove duplicates - cascading drop down lookups

Good day,

 

I tried multiple things before writting, but i'm stuck on removing some duplicates on my form.

 

As you can see, i have 3 lookup columns that are getting there informations from multiple lists. Those column are meant to get the value of one another when i select them as im going down on the form..

 

I tried this solution : https://community.nintex.com/t5/Community-blogs/Three-Tier-Cascading-Drop-Downs-Do-Go-Chasing-Waterf...

 

but it gets me multiple value in my lists which could be confusing if we have to add some items.

 

Also, does someone have solution to get items from one lists instead of multiple.

 

0 Kudos
Reply
2 Replies
ajcrow
Scholar

Re: Remove duplicates - cascading drop down lookups

Hello,

 

What duplicates are you seeing in the output?

Is it coming from the Course or Date list?

One way around having multiple lists,

  • Make 1 master list of data.
  • Use choice columns on your SharePoint list and add them to your form. (You could do this with Courses and Premises)
  • You can pass values from these choice fields into your list lookup(s) on the form.
  • Create a new list view(s) that returns the specific values you need.

I have not done this with 3 tiered cascading lists, but I know it will remove the duplicates from a 2 tiered list.

If you can apply a view to your source master list, you may be able to achieve a 3 tiered cascade easier. I have had success using this method, but I think I had to use the Group By function in creating my custom view in order to pull back 1 value of each.

You can also try the below Javascript article that I found helpful.

https://community.nintex.com/t5/Community-blogs/Remove-Duplicates-from-cascade-lookup-column/ba-p/81...

 

 

0 Kudos
Reply
gaelyvin999
Scholar

Re: Remove duplicates - cascading drop down lookups

it does work with that java :

 

NWF$(".lookupinput").on('mousedown', function() {
var usednames = {};
NWF$(".lookupinput option").each(function() {
if (usednames[this.text]) {
NWF$(this).remove();
} else {
usednames[this.text] = this.value;
}
});
});

 

+ the java input : «lookupinput». altought, there is one control that once i select one entry, the other one doesnt see it, but when i select something else in the same control, it does work perfectly.. My lookup list is perfectly filled. once i selected java in my name column, it doesnt work. But then i selected the other course i got and it worked

0 Kudos
Reply