Remove Duplicates from cascade lookup column

Unfortunately, I cannot think of any reason a value would be appearing in the view on the list, but not coming through in the List Lookup using that view. Perhaps you can try removing the view filter in the List Control, removing or commenting out the JavaScript, and simply have the List Lookup return absolutely everything just to see if it comes through without any filters anywhere. If it still doesn't come through, I'm really not sure what to tell you. However, if it does, then you know it's somehow being caught by a filter somewhere.

Solved the problem. To see all possible values in that field, I had to leave the Source View blank and have Filter set to Display all items.  Then, in the connected Project ID control, I can apply the Source view (to only show Active Projects) and have it filter based on the Resource control.

I'm guessing, I can either filter that control using java to remove the duplicates or via Source view.  But it doesn't like the combination, which is fine since the Source view can be applied to the Project ID control to produce the same effect:  Showing only Active project IDs for a specific person.

Thanks so much for all your help.

I'm guessing I missed a step in your solution (I switched to classic from responsive!). 

I added the script to the form settings:

Then I updated the control css class on the drop down(s):

Any idea what I am doing wrong? Duplicates continue to show up. 

Ahh okay. Yes I put it in the correct place. But now it won't show anything. When I select Product, the other drop downs don't update. 

I apologize for not getting back to you sooner. I don't remember receiving a notification for your question.

To answer your question, since the lookup fields are being repopulated from each other, the code isn't being rerun each time. The code currently only runs on page load. If you'd like to have it run every time, you'll have to add in another type of listener.

I would suggest an on click or on change listener of some sort. I don't have time to create an example for you right now, but I will post one so it can help others too.

One really nice feature of the code is that it's in a function so, you can call it as many times and from as many different areas of your code as you need.

Love it!! but sadly it does not work on Filtered lookup fields... 

I'm very glad to hear you were able to get it to work. 
In the past, I was able to use the $ by itself, but now it seems NWF$ has to replace it whether you use a Nintex JavaScript variable or not. I'm not sure if that has changed in a recent update.

I can't get rid of the duplicates in a lookup dropdown field. Any help would be appreciated. I've added "duplicates" to control CSS class and the code into Custom Javascript in Settings.

I am having the same issue as a few others where the javascript will not work as soon as I apply filters on the lookup. Has anyone found a solution for this? I am not great at javascript, so if someone could provide an example, that would be great.

I have tried this two ways:

NWF.FormFiller.Events.RegisterAfterReady(function(){
     $('.duplicates').each(function(){Update(this.id);});
});
function Update(control){
     var usednames={};
     $("select[id="+control+"]>option").each(function(){
          if(usednames[this.text]){$(this).remove();}           
          else{usednames[this.text]=this.value;}  
     });
}

with filter of

I have also tried the following with same filter as above:

NWF.FormFiller.Events.RegisterAfterReady(function(){

 NWF$(document).ready(function(){   

 });   var txtsite_var =
txtsite.replace("_hid", "");

 NWF$("#"+txtsite_var).on('mousedown', function(){

 var usednames={};

 NWF$("select[id="+txtsite_var+"]>option").each(function(){

 if(usednames[this.text]){                

 NWF$(this).remove();           

 }           

 else{               

 usednames[this.text]=this.value;           

 }   });

 });

});

As soon as I remove the lookup filter, it works great to remove the duplicates.