How to add a field value from one table into a filed on another table?

[Alex D Great]

Hi

I want to add the number field of a record (if it exists) into a field in another table. Is it best to run a business rule, or to specify this in the dictionary entry for the reference field? Then next questions is, how do I do this?

All help is highly appreciated 🙂

[Alex D Great]

@Naga Ravindra R and @AnubhavRitolia  To further explain, I need the field populated so I make this BR effective, but maybe you know how I can reference the related list instead of the form field to achieve this?

Current br dependant on u_request field:

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

var grr = new GlideRecord('sc_request');
grr.addQuery('sys_id',current.u_request); // this is the field name where change number is getting saved in case record
grr.query();
if(grr.next())
{
gs.addInfoMessage('Comment inserted from case to req');
grr.comments= "Inserted from Request Item: " + current.comments.getJournalEntry(1);
grr.update();
}
})(current, previous);

[AnubhavRitolia]

Hi @Alex D Great 

Related List will automatically track all Requests which are created through that case (i.e., where Parent of Request is that Case Number).

OOTB, 1 Case can have multiple Request so Related List is best way to track all Request. Even in case of 1 request, it is always suggested to use OOTB features only at Max.

Your BRs are making little Confusing. Can you explain in words that what is the exact requirement of your Business Rule. What you want to achieve using Business Rule?