Hi All,

This lab is simple and easy to understand. this will give you idea about returning multiple value from script include to client side.

Requirement

when we select any user in form, all the details of that user should get auto-populated.

Design

Created form with 5 fields

-User (referring to sys_user table)

-User Department (referring to cmn_department table )

-User Email (type String)

-User Location (referring to cmn_location table)

-User Company (referring to core_company table)

Development

1. Client Script

Name: AutoPopulateUserData

Table: u_test

UI: all

Type: onChnage

Field: user

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

    var ga = new GlideAjax('AutoPopulateUserData');
    ga.addParam('sysparm_name','populatedata');
    ga.addParam('sysparm_userID',newValue);
    ga.getXML(callback);

 function callback(response)
    {
        var ANSWER =response.responseXML.documentElement.getAttribute('answer');
        var parsedVal = JSON.parse(ANSWER);

        g_form.setValue('u_department',parsedVal.dept);
        g_form.setValue('u_user_location',parsedVal.loc);
        g_form.setValue('u_user_email',parsedVal.eml);
        g_form.setValue('u_user_company',parsedVal.cmp);

    }

    //Type appropriate comment here, and begin script below

}

2. Script Include

Name: AutoPopulateUserData

Client Callable: Checked

var AutoPopulateUserData = Class.create();
AutoPopulateUserData.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    populatedata:function()
    {
        var obj={};
        var id=this.getParameter('sysparm_userID');
    var gr=new GlideRecord('sys_user');
    gr.addQuery('sys_id',id);
    gr.query();
    if(gr.next())
    {
    obj.dept=gr.getValue('department');
    obj.eml=gr.getValue('email');
    obj.loc=gr.getValue('location');
    obj.cmp =gr.getValue('company');
}
    return JSON.stringify(obj);

    },

});

If you find this article helps you, don't forget to log in and "like" it!

Thanks,

Shrutika