How to clear previous reference field value and then select new one on UI Page

[Vaibhav39]

Hello.
I have three reference fields on UI page: Company, Code & Type.
On click of UI action I'm able to populate those fields from form to UI page.
When I change company then the other two fields (values from fields) should get cleared. I'm able to achieve this using gel('<field>').value =''; and gel('sys_display.<field>').value='';

The issue is, when I select value from other two reference fields it is not showing. May be it gets cleared again.
I would really appreciate if I get any kind of help here.
TIA.

[Vaibhav39]

1) if the company is cleared then clear Urgency and Style - Agree

2) if the company is changed the allow the script to set the filter for Urgency and Style.

But there can be value which need to be cleared.

Please check below screen shot:

If user directly changes company then previous value i.e. PQR & XYZ should be cleared so that user can select another one.

[Ankur Bawiskar]

Hi,

then update as this

function showUrgencyAndStyle() {
    var companyId = gel('company').value;
    var urgencyLookUp = gel('lookup.u_urgency_code');
    var styleLookUp = gel('lookup.u_pcd_style');
    var urgencyArray = [];
    var styleArray = [];

    if (companyId == '' || companyId == 'null') {
        gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').readOnly = true;
        urgencyLookUp.style.display = "none";
        gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').readOnly = true;
        styleLookUp.style.display = "none";
        return;
    }
    else{

                gel('u_urgency_code').value = "";
        gel('sys_display.u_urgency_code').value = "";

                gel('u_pcd_style').value = "";
        gel('sys_display.u_pcd_style').value = "";

        //Filter for Urgency code based on company
        var grUrgency = new GlideRecord("u_fsmm_urgency_code");
        grUrgency.addQuery('u_active', true);
        grUrgency.addQuery('u_company', companyId);
        grUrgency.addQuery("u_urgency_code", "!=", "");
        grUrgency.query();
        while (grUrgency.next()) {
            urgencyArray.push(grUrgency.sys_id.toString());
        }
        urgencyLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen('u_urgency_code', 'not', 'u_fsmm_urgency_code', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + urgencyArray + "', '')");

        //Filter for Style based on company
        var grStyle = new GlideRecord("u_pcd");
        grStyle.addQuery('u_active', true);
        grStyle.addQuery('u_company', companyId);
        grStyle.addQuery("u_style", "!=", "");
        grStyle.query();
        while (grStyle.next()) {
            styleArray.push(grStyle.sys_id.toString());
        }
        styleLookUp.setAttribute('onclick', "mousePositionSave(event); reflistOpen( 'u_pcd_style', 'not', 'u_pcd', '', 'false', 'QUERY:u_active=true', 'sys_idIN" + styleArray + "', '')");
    }
}

Regards
Ankur

[Vaibhav39]

That highlighted code is the code which I wrote already. It is not working.

When Change company and then try to select urgency & style then the values will not get displayed.

When I select different urgency code (say LMN), then that value (LMN) is not showing in the urgency code field. Same for style field.

[Ankur Bawiskar]

Hi,

so are you saying it is clearing the Urgency and Style when Company is changed but not setting the filter for Urgency and Style?

Regards
Ankur

[Vaibhav39]

Filter is setting correctly.

But when I select value from filtered codes then it is not showing in those fields. Also that "i" icon/macro is not showing.

Please help.