Copy fields from Securkty Incident to Response Task

[Community Alums]

I have two tables: Security Incident and Response Tasks.

There are about 20 fields I want to copy down to the response task when created. What is the best way to relate the two to be able to add the fields to the response task?

[Dr Atul G- LNG]

Hi @Community Alums 

I think the best way to create property and call that property in UI action, like we have on Incident table , copy incident.

[Maddysunil]

@Community Alums 

You can follow below approach:

1. Create a Reference Field:

   • In the Response Tasks table, create a reference field that refers to the Security Incident table. This will establish a relationship between the two tables.

2. Configure the Reference Field:

   • Configure the reference field to point to the Security Incident table. This can be done by setting the "Reference" field on the reference field configuration.

3. Create Business Rule:

   • Create a business rule on the Response Tasks table that triggers when a new record is inserted.
   • In the business rule script, use the GlideRecord API to query the corresponding Security Incident record and copy the desired fields.

   Example Business Rule Script:

(function executeRule(current, previous /* , gs */) {
    if (current.operation() == 'insert') {
        var securityIncident = new GlideRecord('security_incident');
        if (securityIncident.get(current.security_incident)) {
            // Copy fields from Security Incident to Response Task
            current.field1 = securityIncident.field1;
            current.field2 = securityIncident.field2;
            // ... copy other fields as needed
        }
    }
})(current, previous);
​

Please mark my response correct/helpful, if it helps you!

[Maddysunil]

@Community Alums 

If my response is useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.

Thanks

[AshishKM]

Hi @Community Alums,

You can read the incident data and pass the values to response task in the same process which is creating this response task, this incident & response task must be related using some column on response task table(form).

-Thanks,

AshishKM