Hello @Community Alums 

Please allow me some time to digest the code, as I don't have much experience with coding. Thank you.

hello @Community Alums 

I have attempted to create the tasks, and they were generated successfully. However, the newly created tasks were not linked to the existing RITM.

The use case involves a user submitting a service request with an attached Excel file.

The system parses the Excel file and creates tasks based on the number of rows in the spreadsheet. Based on the code you provided, how will it determine which RITM sys_id to target?

Please let us know if there is another way of achieving this.

Thank you

Hi @JessicaM6884345,

to link the SC tasks to the existing RITM record can be achieved by below script:

var task = new GlideRecord('sc_task');
	task.addQuery('request_item', target.sys_id);//request_item is field on SC TASK which stores the sysid of RITM
	task.query();
	if(task.next()){
		source.description = task.description;
		task.update();
	}

It is just raw script rest can be modified as per your requirement. I am writing this script in onBefore transform  map .Hope this will help you.

Please mark my answer correct and helpful if this works for you.

Thanks

Jitendra

Hi @Jitendra Diwak1 

Thank you for your help.  Let me give it a try and provide feed back.  Thank you