Hi,
In order to achieve this you can write a Script Include and a OnChange Catalog Client Script which will Populate the User Phone Number when some User is selected in the User Variable as per the below Script:
Script Include:
var Requstor_Change = Class.create();
Requstor_Change.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getdetails : function() {
var result = this.newItem("result");
var user_detail = this.getParameter('sysparm_user_name');
var user_info = new GlideRecord('sys_user');
user_info.addQuery('sys_id',user_detail);
user_info.query();
while(user_info.next())
{
result.setAttribute("phone",user_info.phone);
result.setAttribute("email",user_info.email);
}
},
type: 'Requstor_Change'
});
2) Configure an OnChange Catalog Client Script on User Variable field as per the script below:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga = new GlideAjax("Requstor_Change");
ga.addParam("sysparm_name", "getdetails");
ga.addParam('sysparm_user_name',newValue);
ga.getXML(ajaxResponse);
function ajaxResponse(serverResponse) {
var result = serverResponse.responseXML.getElementsByTagName("result");
var phone = result[0].getAttribute("phone");
var email = result[0].getAttribute("email");
g_form.setValue('requestor_phone',phone);
g_form.setValue('requestor_email',email);
}}
Result:
Similarly you can have other field also updated in the above scripts which you want to pull from User Table.
Hope this helps.Mark the answer as correct/helpful based on impact.
Regards,
Shloke
