Cascading Lookup Fails When Criteria Is Set Using Javascript

[scheevel]

Thank you in advance for any help you can offer.  Here is a description of the problem.

A List Lookup control has the following properties
And it has these filter-by values - Control: 'sltCompany' - Column: 'lpCompanySpecific'
Positive test works as expected... - filter value = results
Negative test works as expected… - no filter value = no results
…until I start setting the control value programatically using Javascript
After function set the control value, no results are returned. Even manually retyping the filter value, the filter no longer works
Reload the form, manually type the filter value, and the filter works again.
Then execute the Javascript to override the typed control value...
...and again the filter no longer works, even manually retyping the value, no results
Normal Javascript, nothing extravagant

[rhia]

Hi Neville Scheevel‌ !

I think this might solve your issue:    

Let me know if it works out!

Cheers,

Rhia

[scheevel]

I updated by code to this...

function SetCtrlValue () {
NWF$ ( '#' + ctrlCompany ).val( 'ABC Company' )
var ctrl = NWF$ ( '#' + ctrlCompany )
NWF.FormFiller.Functions.ProcessOnChange( ctrlCompany );
}

...and it produces the following Javascript error

[rhia]

Hmm interesting! And this is On-Prem not O365, right?

[scheevel]

Correct, 2013 on-prem.

[rhia · Accepted solution]

I think I got it!

function SetCtrlValue () {
NWF$ ( '#' + ctrlCompany ).val( 'ABC Company').trigger('change');
 }

Try this out This worked for me in my trials.

Cheers,

Rhia

[scheevel]

Brilliant! That fixed it! Thanks so much!