How to update a field value on other table field which is a reference field on current table.

[Pravallika14]

Hello Team,

I have a reference field ("First reported by") on Problem ticket, which has an Incident Number (PFA) from Incident table. I want to set the value of "Contact type" field to "None" on Incident Form of this old Incident, whenever the Incident Number changes to a new incident on Problem ticket form.

Please help me on how to capture the SysID of the previous incident in "First reported by" field, when it changed to new incident, to set the value of  "Contact type" field to "None" on the Previous incident .

I wanted to use , Before Business rule for the same. But I am not sure how can we capture the previous values of a reference field using previous object .

Thank you!!

[The SN Nerd]

If you are not familiar with coding, you could achieve this using Flow Designer.

Trigger: Problem is updated

Condtion: First reported by changes and Firest reported by is not empty

• Action:Update Record (Problem.First reported by)
• Contact type = none

[The SN Nerd]

If you are set on business rules, you must use an after rule.

It is generally considered best practice to consider low/no code approaches first.

[Musab Rasheed · Accepted solution]

Hi Pravalika,

Write After business rule on problem table like below

Condition :

current.first_reported_by_task != previous.first_reported_by_task

Code :

(function executeRule(current, previous /*null when async*/) {

	gs.addInfoMessage('Current '+ current.first_reported_by_task + ' Previous '+ previous.first_reported_by_task);
	// Add your code here
	var gr = new GlideRecord('incident');
	gr.addQuery('sys_id', previous.first_reported_by_task);
	gr.query();
	if(gr.next())
		{
			gs.addInfoMessage("Going inside");
			gr.contact_type = '';
			gr.update();
		}

})(current, previous);

Screenshot of condition and code :

Mark my answer as correct or hit like

[Musab Rasheed]

Hi,

If your issue is resolved, Please mark my answer as correct and close the thread.

Regards