- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2019 06:33 AM
Hi,
Please find below screenshots of my catalog item. Requested for is a reference field to table sys_user. When I select a user's name in requested for, the user's values on the fields on right side should be automatically populated from sys_user table.
For eg - abel tuter is selected so first name, last name etc should be populated from sys_user table. The values which are not present should remain empty.
Please help me on how to do this with the code as I am new to ServiceNow and not very good at scripting..
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2019 06:44 AM
Hi
You need to create a onChange client script and client callable script include for this purpose. See below :-
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
var id = g_form.getValue('u_reference_1');//newValue
var ga = new GlideAjax('GetUserDetailsAjax');
ga.addParam('sysparm_name','getInfo');
ga.addParam('sysparm_user_id',id);
ga.getXML(CallBack);
function CallBack(response)
{
var answer = response.responseXML.documentElement.getAttribute("answer");
var user=JSON.parse(answer);
//g_form.setValue('req_email', user.email);
//g_form.setValue('req_phone', user.phone);
//g_form.setValue('address1', user.street);
alert(user.location);
//g_form.setValue('city_state_zip', user.location);
}
}
Client Callable Script Include :-
var GetUserDetailsAjax = Class.create();
GetUserDetailsAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getInfo: function(){
var obj={};
obj.location='';
obj.email='';
obj.phone='';
obj.street='';
var id=this.getParameter('sysparm_user_id');
var gr= new GlideRecord('sys_user');
if(gr.get(id)){
if(gr.location!='')
obj.location=gr.location.city.toString();
obj.zip=gr.zip.toString();
obj.street=gr.street.toString();
obj.phone=gr.phone.toString();
obj.email=gr.email.toString();
//here you will get all the required fields from sys_user that you want to show on your form.
}
return JSON.stringify(obj);
},
type: 'GetUserDetailsAjax'
});
Let me know.
Regards,
Omkar Mone.
www.dxsherpa.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 01:16 PM
I'm new to Servicenow , this maybe a stupid question; Could you please let know, in which table i need to create this client script , Me also trying to get only User id, Department ,Title and Company to be filled once user filled the requested for, because i'm confused how this script work in both Service portal and Catalog item?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-01-2019 12:37 AM
Clear cache and try once,
cache.do
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-01-2019 01:25 AM
Hi shweta,
I tried it, still first names for them are not coming up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-01-2019 07:01 AM
You can use simple javascript and set that in variable's default value instead of using client script . for vendor part client script will do the job
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2019 10:50 AM
Hi, i'm sorry I do not know, can you explain in detail according to my requirement how can I do that?