That's a good start, but based on your description, it sounds like this may be closer.
function onChange(control, oldValue, newValue, isLoading) {
if (newValue == "") {
g_form.clearValue("phone_number_reserved");
}
var utilsLandlineAJAX = new GlideAjax("INV_ITSM_MobilePhoneCheckAjax");
utilsLandlineAJAX.addParam("sysparm_name", "mobileDefaultPhoneNumber");
utilsLandlineAJAX.addParam("sysparm_employee", newValue);
utilsLandlineAJAX.getXMLAnswer(function(answer) {
alert(answer)
if (answer) {
g_form.setValue("phone_number_reserved", answer);
} else {
g_form.clearValue("phone_number_reserved");
}
});
}
You can add alert lines in the Client Script, and gs.addInfoMessage lines in the Script Include temporarily to see how far the script is getting, the record retrieved by the GlideRecord, etc so you can see where it's going wrong. On the Script Include, make sure the Client callable box is checked, then it sounds like the script should be more like this:
var INV_ITSM_MobilePhoneCheckAjax = Class.create();
INV_ITSM_MobilePhoneCheckAjax.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
mobileDefaultPhoneNumber: function() {
var answer = '';
var usr = this.getParameter("sysparm_employee");
gs.addInfoMessage('usr = ' + usr)
var gr = new GlideRecord('u_cmdb_ci_phone_number');
gr.addQuery('assigned_to', usr);
gr.addQuery('number_state', 'IN', 'reserved, assigned');
gr.addQuery('type', 'mobile');
gr.query();
if (gr.next()) {
gs.addInfoMessage('record found ' + gr.name)
answer = gr.name;
}
return answer;
},
type: 'INV_ITSM_MobilePhoneCheckAjax'
});
- depending on your field names and values in your custom table...
