Refreshing Parent UX Cascading Dropdown

[psamuels56]

OK, here's a fun one...

I have a UX with cascading dropdowns (First you select Company. Then, you pick the "Contact")... You can see what it looks like here:

Contacts.jpg

It's working perfectly, but here's my challenge. As you can see, there's a button to add another contact. Clicking that button opens a simple grid (Modeless Popup, linked to the customer that was already selected in the first dropdown) where the user can add as many contacts as they want for that customer.

If they add a new "contact", I want the cascading list to show the new contacts that were added, so that the user can select it.

I've added this javascript in the "onhide" property of the window that opens (I tried to get the code to wipe out the Company Lookup, which the user would have to re-select... very cumbersome: I'd really just like the cascading Contact list to be refreshed)
var po = {dialog.object}.getParentObject();
po.setValue('COMPLOOKUP','');
po.refresh();

... anyway, every variation I've tried isn't working.

If you have any thoughts, I'd love to learn something new.

Thanks.

Phil

[Davidk]

Re: Refreshing Parent UX Cascading Dropdown

I think you have to kind of fake this one out a bit. Get the current value of the Company dropdown. Then perform a refresh on the Contact dropdown but filter it with the current Company value. I don't know what your Company dropdown key is so I used CompanyId. Whatever is in the Contact dropdown for Company... use that.

Edit: I usually test code I post but I didn't this time. Lesson learned... again. The onHide event is running from the UX... not from the Grid. There is no reason to go after a parent object. This code is tested and works from the onHide event

var currDDValue = {dialog.object}.getValue('Company');
var arr = [];
arr.push({ controlName: 'Contacts', dynamicFilter: 'CompanyId = \'' + currDDValue + '\''});
var json = JSON.stringify(arr);
{dialog.Object}.refreshDropdownBoxChoices(json);

If you were to select a new Company to work with, the cascading dropdown stuff would now kick in and all is still good.

[psamuels56]

Re: Refreshing Parent UX Cascading Dropdown

HI David-

Thanks so much for responding... I just have to become more skilled in javascript.

Anyway, the code you sent caused an error (I'm sure it's something I entered incorrectly... though it appears ok to me).

First: The first "dropdown" control is called "CompLookup" and the second, cascaded dropdown control is "Contact". The linking variable is "Company". Based on your suggestion, here's what I entered:

var po = {dialog.object}.getParentObject();
var currDDCompany = po.getValue('COMPLOOKUP');
var arr = [];
arr.push({ controlName: 'Contact', dynamicFilter: 'Company' = \'' + currDDCompany + '\''});
var json = JSON.stringify(arr);
po.refreshDropdownBoxChoices(json);

When I try to save the code, I get this error:

Contacts2.jpg

Like I said, I'm sure I'm entering something wrong, but I can't figure it out... It seems that the code doesn't like the "Contact" control, but I'm not sure.

Thanks again for helping.

Phil

[psamuels56]

Re: Refreshing Parent UX Cascading Dropdown

One more thing... since the error said that it was on line 4 column 63... that's where the "single quote" was for Company. So, I eliminated the single quotes, but the function doesn't appear to do anything. Hope that helps.

Phil

[Davidk]

Re: Refreshing Parent UX Cascading Dropdown

Sorry Phil, my mistake on the parent stuff... re-read my post because I've changed the code there. You don't need to access a parent object from where you are. The onHide is running from the UX... not the Grid... so all code is UX based. Dump that code I originally posted and put in the new stuff.

[psamuels56]

Re: Refreshing Parent UX Cascading Dropdown

Hi David-

I can't believe you felt the need to apologize... you are so generous to offer your time to help those of us who are still learning (especially javascript.. I have a long way to go). I am so appreciative of the you and the Alpha Community who is always there to step in and help.

Anyway, your revised code worked perfectly, EXACTLY what I wanted to accomplish. I've already uploaded it to the server, so that my customer can test it.

THANK YOU so much.

Phil