question Auto populate user details through script include and glide ajax in ITSM forum

Auto populate user details through script include and glide ajax

hemathsnow002 — Fri, 08 Sep 2023 08:05:32 GMT

Auto populate user details through script include and glide ajax

Re: Auto populate user details through script include and glide ajax

Community Alums — Fri, 08 Sep 2023 15:49:28 GMT

Hello @hemathsnow002 ,

Please refer the below link.

https://www.servicenow.com/community/developer-articles/auto-populate-user-details-using-ajax/ta-p/2315390

Regards,

Namrata

Re: Auto populate user details through script include and glide ajax

Mark Roethof — Fri, 08 Sep 2023 15:57:10 GMT

Hi there,

Here you go:

- 2020-01-10 - Article - Client Side Scripting: Go for GlideAjax (with getXMLAnswer)!

Re: Auto populate user details through script include and glide ajax

Raghu3 — Fri, 08 Sep 2023 18:36:59 GMT

Refer below code and change it as per your need, Make sure you mark client callable true on script include

Client script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue === '') {

return;

}

var ga = new GlideAjax("userDetailsUtil");// Script include name

ga.addParam('sysparm_name', 'getUserDetails');//Script include function name

ga.addParam('sysparm_usersysid', newValue);// newValue object in onchange client script always return changed value of the field

ga.getXML(getDetails);//Calling call back function to convert response and set values

function getDetails(response) {//call back function

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

var objval = JSON.parse(answer);

g_form.setValue("u_department",objval.department);

alert(objval.department);

}

Script include:

var userDetailsUtil = Class.create();

userDetailsUtil.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getUserDetails:function(){//Function declaration

var obj = {};//json to collect the information

var usersysid = this.getParameter('sysparm_usersysid');

var gr=new GlideRecord('sys_user');//glide user table

gr.get(usersysid);

obj.email=gr.getValue('email');//map values

obj.department=gr.getValue('department');

var json = new JSON();

return json.encode(obj);

type: 'userDetailsUtil'

});

Re: Auto populate user details through script include and glide ajax

maroon_byte — Fri, 08 Sep 2023 21:50:25 GMT

Is it for catalog item variables? or is it for form in Core UI?

If it's for catalog item variables, then why use scripts? Instead, use 'Service catalog data lookup'

https://docs.servicenow.com/en-US/bundle/vancouver-servicenow-platform/page/product/service-catalog-management/concept/c_ServiceCatalogDataLookup.html

Re: Auto populate user details through script include and glide ajax

Siva Jyothi M — Sat, 09 Sep 2023 08:42:18 GMT

Hi @hemathsnow002,

We can take a simple scenario here- based on the user selected on the form level, we need to auto populate the user's email ID.

User - form variable name is - form_user

Email - form variable name is - form_email

Script Include -

Client Script-

There is another way where we don't use script include, you can directly write on-change client script on user variable.

Mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.