Hello,
I have a requirement to get the variable value & check in my custom table for matching record & then to update the state value to 'completed' in my custom table.
I am using a OnSubmit catalog client script but it is not updating my custom table field state.
Type:OnSubmit
Catalog Item: Source Form Details
Script:
function onSubmit() {
//Type appropriate comment here, and begin script below
var sId = g_form.getValue('source_id'); // variable value
var gr = new GlideRecord('u_customtable'); // custom table
gr.addQuery('u_source','=',sId); // checking source id is available in my custom table
gr.query();
if(gr.next()){
var sts = gr.u_state;
g_form.setValue(sts,'Completed'); // setting the value of my custom table to 'Completed' but not working.
gr.update();
}
else{
// do nothing
}
}
Is this a correct approch or iam missing something. Plz help.
Thx,
JR
