I have a variable of type Lookup Select box which is refering to sys_user table. I want to autopopulate the selected user email in another text box field. How can i achieve this.
Thanks
1 ACCEPTED SOLUTION
Hi @Sanjay21 ,
You can write a onChange Catalog client script and use Client Side GlideRecord to get the user email, or you can use GlideAjax to get the user details and display in the other field.
But, The best practice is to use the GlideAjax and call a ClientCallable Script Include to get the user details.
You can use the following scripts, but make sure to change the field names in onChange client script to the one you are using.
Client Callable Script Include:
var CatalogUserData = Class.create();
CatalogUserData.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getUserEmail: function(){
var user = this.getParameter('sysparm_user');
var usrGr = new GlideRecord('sys_user');
if(usrGr.get('sys_id', user)){
return usrGr.getValue('email');
}else{
return '';
}
},
type: 'CatalogUserData'
});
onChange Client Script:
function onChange(control, oldValue, newValue, isLoading) {
if (!isLoading && newValue) {
var kbGa = new GlideAjax('CatalogUserData');
kbGa.addParam('sysparm_name', 'getUserEmail');
kbGa.addParam('sysparm_user', newValue);
kbGa.getXMLAnswer(populateEmail);
}
function populateEmail(answer) {
if (answer) {
g_form.setValue('user_email', answer);
} else {
g_form.setValue('user_email', '');
}
}
}
