Populate field value based on another field using GlideAjax

[Sagar_pawar]

Hello All,

I want to populate value based on field .

for ex: if I select employee all information related to employee will auto populate .

i wrote one code its working fine but one for single field .please check my once if I did any mistake while writing script .so please let me know.

SCRIPT INCLUDE :

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

getData:function()
{
var para1=this.getParameter('sysparm_data');
var gr=new GlideRecord('sys_user');
gr.addQuery('sys_id',para1);
gr.addNotNullQuery('name');
gr.query();
if(gr.next())
{


return gr.first_name;




}
if(gr.next())
{

return gr.last_name;

}
},







type: 'populatedata'
});

Client script:

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

var ga=new GlideAjax('populatedata');
ga.addParam('sysparm_name','getData');
ga.addParam('sysparm_data',newValue);
ga.getXML(populateGroup);
function populateGroup(response)
{
var answer=response.responseXML.documentElement.getAttribute('answer');

g_form.setValue('firstname',answer);


}
}

Thank You.

[Deepika18 · Accepted solution]

Hi Abhi, 

Please check the below script to know about how to return multiple values from Script include to Client script using JSON.

OnChange Client Script on user field :

var abc = new GlideAjax("Script Include Name");
abc.addParam("sysparm_name", 'FunctionName');
abc.addParam("sysparm_userID", newValue);
abc.getXML(Hello);

function Hello(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");

answer = JSON.parse(answer);
g_form.setValue("email", answer.firstName); //firstName is the obj name stored in Script include
g_form.setValue("department", answer.lastName);
g_form.setValue("manager", answer.Manager);
}
}

Client - Callable Script include:

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

myfunction: function(){
var name = {}; // to store multiple values
var usr = this.getParameter('sysparm_userID');
var tab = new GlideRecord("sys_user");
tab.addQuery("sys_id",usr);
tab.query();
if(tab.next()){
name.firstName = tab.getValue("first_name");
name.lastName = tab.getValue("last_name");
name.Manager = tab.getDisplayValue("manager");
}
return JSON.stringify(name);
},

type: 'Autopopulate'
});

In this way you can return multiple values using JSON.

Jus add data to the object. in above case it is "name". And call it in client script.

Please feel free to ask incase of any queries from the above script.

Please mark it as correct if it resolved your query.

Regards,

Deepika

[Deepika18]

Hi Abhi,

Could you please give me some info?

Do you want to populate both first name and last name in same field or 

Do you have 2 seperate fields for First name and last name and you are trying to populate both?

[Sagar_pawar]

i have two separate filed first name and last name

[Deepika18 · Accepted solution]

Hi Abhi, 

Please check the below script to know about how to return multiple values from Script include to Client script using JSON.

OnChange Client Script on user field :

var abc = new GlideAjax("Script Include Name");
abc.addParam("sysparm_name", 'FunctionName');
abc.addParam("sysparm_userID", newValue);
abc.getXML(Hello);

function Hello(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");

answer = JSON.parse(answer);
g_form.setValue("email", answer.firstName); //firstName is the obj name stored in Script include
g_form.setValue("department", answer.lastName);
g_form.setValue("manager", answer.Manager);
}
}

Client - Callable Script include:

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

myfunction: function(){
var name = {}; // to store multiple values
var usr = this.getParameter('sysparm_userID');
var tab = new GlideRecord("sys_user");
tab.addQuery("sys_id",usr);
tab.query();
if(tab.next()){
name.firstName = tab.getValue("first_name");
name.lastName = tab.getValue("last_name");
name.Manager = tab.getDisplayValue("manager");
}
return JSON.stringify(name);
},

type: 'Autopopulate'
});

In this way you can return multiple values using JSON.

Jus add data to the object. in above case it is "name". And call it in client script.

Please feel free to ask incase of any queries from the above script.

Please mark it as correct if it resolved your query.

Regards,

Deepika

[Deepika18]

Hi @Sagar_pawar ,

Is the above code working for you??

If yes,

Please mark it as correct.

Regards,

Deepika