Update custom table record based on RITM variables when one of the tasks is marked as closedcomplete

[Lakshmi Sharma]

Hi,

I am trying to update a custom table record with RITM variables when task is closed as complete. I have a catalog item where I pick this record (ex:Incident) I will fill in variables and expectation is once my task in the flow is marked as complete by support team, I want variables to automatically update my incident fields with variable values submitted by requestor.

I am trying to achieve through run script but failing to update the (incident) record. Additionally I would need to verify the task state and only if state is closed complete this update must happen. My run script queries incident table with the variable  used to select target record. Once found the record I trying to map variables with incident fields but that dosent work as well.

Any sort of help is much appreciated, Thanks in Advance!!

[Ankur Bawiskar]

@Lakshmi Sharma 

so what script did you start with? please share that

[Lakshmi Sharma]

@Ankur Bawiskar 

My script is like below: 

var TargRec = current.variables.target_record;
var UndRec = new GlideRecord ('table');
UndRec.addQuery('number',TargRec);
UndRec.query();
UndRec.short_description = current.variables.shrt_desc; (field 1)
UndRec.description= current.variables.desc; (field 2)
UndRec.update();

[Ankur Bawiskar]

@Lakshmi Sharma 

use this

var TargRec = current.variables.target_record.getRefRecord();
TargRec.short_description = current.variables.shrt_desc; //(field 1)
TargRec.description= current.variables.desc; //(field 2)
TargRec.update();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Lakshmi Sharma]

Hi @Ankur Bawiskar, Unfortunately the above script dint update the target record. Used exact same script as suggested.