Hello.
Within a catalog item, we have two fields. One is for the user's name the other for their email address.
I've used the table 'sys_user' for both fields. When the user's name is populated, I have it automatically adding their email address to the specific email field, both with 'List Collector' as their variable type.
Issue I am having, is if multiple users are added to the User field, no email address (even previously displayed for the first user) will be displayed. How do I get each additional email address to be displayed in the List Collector / email field?
Writing glide record in client side scripting is not a good practice.
I would suggest use glide ajax and do the glide record part inside client callable script include.
Sample Code:
Script Include:
var HelloWorld = Class.create();
HelloWorld.prototype = Object.extendsObject(AbstractAjaxProcessor, {
helloWorld: function(){
var et = this.getParameter('sysparm_user_name');
var res = et.split(',');
var abc = [];
for(var i=0;i<res.length;i++){
var gr = new GlideRecord('sys_user');
gr.get('sys_id',res[i]);
abc.push(gr.getValue('email'));
}
return abc.join(",");
},
type: 'HelloWorld'
});
Screenshot:
Catalog Client script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
//Type appropriate comment here, and begin script below
var ga = new GlideAjax('HelloWorld');
ga.addParam('sysparm_name', 'helloWorld');
ga.addParam('sysparm_user_name', g_form.getValue('test').toString());
ga.getXML(HelloWorldParse);
function HelloWorldParse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
g_form.setValue('test1',answer);
}
}
Screenshot:
Result:
Note: set the variable name correctly in client script, i test and working perfectly.
If my answer helped you, kindly mark it as correct and helpful.
Hi
