Hi All, I have a catalog item with a drop down field 'REGION' and reference field 'Property Name' which references 'cmn_location' table and populates the name field of the MARSHA.
So if user doesn't select any value from 'REGION' field , the region present in 'Property Name' of MARSHA will populate in the 'REGION' field.
I have written a client script and script include to populate Region of MARSHA in the 'REGION' field if user doesn't select any value from 'REGION' field and it is working fine.
Client Script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
if (g_form.getValue('REGION') == '') {
var a = g_form.getValue('switch_property');
alert(a);
var b = new GlideAjax('PopulateRegion');
b.addParam('sysparm_name', 'getRegion');
b.addParam('sysparm_marsha', a);
b.getXML(getRegion);
function getRegion(serverResponse) {
var cc = serverResponse.responseXML.documentElement.getAttribute("answer");
g_form.setValue('REGION', cc);
}
} //Type appropriate comment here, and begin script below }
Script Include:
var PopulateRegion = Class.create(); PopulateRegion.prototype = Object.extendsObject(AbstractAjaxProcessor, { getRegion: function () {
var a = this.getParameter('sysparm_marsha');
gs.info('SS2' + a);
var gr = new GlideRecord('cmn_location');
gr.addQuery('sys_id',a);
gr.query();
if (gr.next()) {
var mreg = gr.u_region;
gs.info('SS1' + mreg);
return mreg; }
else {
return '';
}
},
type: 'PopulateRegion'
});
But the issue is if the user again changes a Property Name, it is not changing the value of Region field.
How to fix this?
