When the value of a particular field changes , work notes should populate the change on Incident table

[sonita]

I have a field on the incident table . the type is string , When the value of a the field changes or a value is added ,   work notes should populate the change on Incident table.

I have created a business rule for that on insert and update. but i think there is a problem that it does not work:

this is the condition:

current.work_notes = u_change_tracking;

Any help would be appreciated.

[aswinsiddaling2]

Hi Soni,

Why do you want to copy the change to the Work notes field? If you want to see those changes in the Incident form, you can add this field in the Activity Log formatter and you can see the changes made to this field.

Let me know if this helps.

Thanks and Regards,

Aswin Siddalingam

[sonita]

That's a very good point Aswin , but this is a requirement from the customer!

[aswinsiddaling2 · Accepted solution]

Ok so may be you can write a script like this:

current.work_notes = 'The value of Change tracking # field changed from ' + previous.u_change_tracking + ' to ' + current.u_change_tracking ;

current.update();

Let me know if this helps.

Thanks and Regards,

Aswin Siddalingam

[Inactive_Us1014]

I don't think you want to use current.update(), won't that create a duplicate record on each insert/update?