addItems to Dropdown avoiding duplicates

Question

Sir.Link to the actual file  https://www.dropbox.com/s/0508by0lmlf77rc/repeatable%20Dropdown%20to%20another%20Dropdown%20which%20is%20also%20repeatable..pdf?dl=0 I have 2 dropdowns     1st is in a repeating table  and 2nd one is in a repeatable subform1st dropdown has options  say  Option1, Option2 ...... 2nd Dropdown is empty when intialized I want when user selects any option in dropdown 1  it should be populated in dropdown2  avoiding duplicatesso if user adds say 3 rows  and select in1st Row : Option12nd Row : Option23rd row : Option3 then Dropdown2 should have the following options for the user to select fromOption1Option2Option3if user goes back and deletes any row then that option should be removed from Dropdown2    and  duplicate items should be avoided.  Thanks

radzmar · Accepted Answer

This needs a combination of two loops. One to fetch the selected value and one to compare those already used.

 form1.MSF.SF_Notable.SF1.RB::enter - (JavaScript, client)

var oRows = Table1.resolveNodes('Row2.[Cell1 ne "  -Select-"]'),
	oNode, oItems, i, j, n, cValue;
this.clearItems();
for (i = 0; i < oRows.length; i += 1) {
	oNode = oRows.item(i);
	oItems = this.items.resolveNodes('#text[*]');
	n = 0;

	if (oNode.Cell1.rawValue === "  Example Other Member" ) {
		cValue = oNode.Cell2.rawValue;
	} else {
		cValue = oNode.Cell1.rawValue;
	}
		
	for (j = 0; j < oItems.length; j += 1) {
		if (cValue == oItems.item(j).value) {
			n += 1;
		}
	}

	if (n === 0) {
	    this.addItem(cValue);
	}
}

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded