Related list field populated on a form field

Abinash
Kilo Contributor

I have this impacted services related list in my incident form.

I want the "managed by" field which is a reference field of user table to be populated to a custom field in my INC form. Kindly help me to

achieve this. Developer Community bawiskar

Thanks in advance

find_real_file.png

1 ACCEPTED SOLUTION

Not sure how you are going to pull that off but here is code for adding users to a list field that relates to the sys_user table. Adding or removing an Affected CI in the related list will trigger an update of the List field and add assigned to from all the related CI's to the u_service_owner field.



List field on Incident table called u_service_owner referencing sys_user table.


Business rule on task_ci table. Runs after on Insert, Update and Delete.



Script:


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



  // Add your code here


  var inc = new GlideRecord('incident');


  inc.addQuery('sys_id',current.task);



  inc.query();


  if(inc.next()){


  inc.u_service_owner=''; //Clear service owner list



  var ci = new GlideRecord('task_ci');


  ci.addQuery('task',current.task);


  ci.query();


  while (ci.next()){


  inc.u_service_owner   += ',' + ci.ci_item.assigned_to;   //Add CI assigned to



  }



  inc.update();


  }


 


})(current, previous);


View solution in original post

27 REPLIES 27

BALAJI40
Mega Sage

You want to populate the managed by field with custom field on incident form?



if so in the dictionary override of managed by of impacted services, put the default value as javascript:parent.<custom_field>


Abinash
Kilo Contributor

Hi Balaji,


In the override table which table has to be mentioned??


Tell me one thing,



you need based on related list values changes incident custom fields need to populate or other scenario??????


Abinash
Kilo Contributor

I will explain you clearly. Like we have a custom field in INC form that needs to store the value of "managed by" field present in the related list "impacted services". and now if i remove the user from managed by then automatically the custom field should also get blank