1 ACCEPTED SOLUTION
Hi Anfield,
I recently answered a similar question. Feel free to copy and make adjustments.
Client:
function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
var saveAndClose = true;
//Type appropriate comment here, and begin script below
var gaRegion = new GlideAjax("cellEditHandler");
gaRegion.addParam('sysparm_name', 'getLocation');
gaRegion.addParam('sysparm_locIDs', sysIDs.join(","));
gaRegion.addParam('sysparm_newValue', newValue);
gaRegion.getXML(alertRegion);
function alertRegion(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
}
callback(saveAndClose);
}
Server Script Include:
var cellEditHandler = Class.create();
cellEditHandler.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getLocation: function () {
var locIDs = this.getParameter("sysparm_locIDs");
locIDs = locIDs.split(",");
var newValue = this.getParameter("sysparm_newValue") + '';
var strOutput = 'empty';
var grLocation = new GlideRecord('cmn_location');
if (grLocation.get(newValue)) {
var grIncident = new GlideRecord('incident');
grIncident.addQuery("sys_id", "IN", LocIDs);
grIncident.query();
while (grIncident.next()) {
grIncident.u_region = grLocation.u_region;
grIncident.update();
}
strOutput = grLocation.getDisplayValue();
}
return "Region updated to: " + strOutput;
},
type: 'cellEditHandler'
});
This also works if multiple are edited in the list at once. You can modify the second query part to fit your custom table.
In addition of the working script I must ask you. Why not do it in a Business rule? Before update of the record, set the value of the Region to the region you want. If it is a field on the location you could even dotwalk.
When to run:
Actions:
