catalog client script

[Rosy14]

Hi,

I have a field on form company. Here if the value contain something based on it another field will auto populate, below script not working.

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    //Type appropriate comment here, and begin script below

    var gr = new GlideRecord('customer_account');
	gr.addQuery('sys_id',newValue);
	gr.query();
	g_form.addInfoMessage(gr); //not printing
    var company, x;
    while(gr.next()) {
        company = gr.name;
    }
    g_form.addInfoMessage(company); //not printing
    if (company.toString().indexOf("CASA") >= 0 || company.toString().indexOf("CASA") >= 0 || company.toString().indexOf("casa") >= 0 || company.toString().indexOf("LI & FUNG") >= 0)
        x = 2.5;
    else
        x = 0;
    g_form.setValue("u_commission_rate", x);

}

[Ratnakar7]

Hi @Rosy14 ,

Here's how you can achieve this:
Create a Script Include that will query the customer_account table:

var CustomerAccountUtils = Class.create();
CustomerAccountUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    getCompanyName: function(customerAccountId) {
        var gr = new GlideRecord('customer_account');
        gr.addQuery('sys_id', customerAccountId);
        gr.query();
        if (gr.next()) {
            return gr.name.toString();
        }
        return '';
    },
    type: 'CustomerAccountUtils'
});
​

Modify the Client Script to use GlideAjax:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    var ga = new GlideAjax('CustomerAccountUtils');
    ga.addParam('sysparm_name', 'getCompanyName');
    ga.addParam('sysparm_customerAccountId', newValue);
    ga.getXMLAnswer(function(response) {
        var company = response;
        g_form.addInfoMessage(company);

        var x;
        if (company.indexOf("CASA") >= 0 || company.indexOf("casa") >= 0 || company.indexOf("LI & FUNG") >= 0) {
            x = 2.5;
        } else {
            x = 0;
        }
        g_form.setValue("u_commission_rate", x);
    });
}

Thanks,

Ratnakar

[Rosy14]

It is returning empty. Nothing is returning from script include

[Trupti94]

have you checked client callable checkbox ?

[Rosy14]

yes