How to add comments in email notification from another table?

[Amol Pawar]

Hi All,

I have a requirement as mentioned below. Please go through and give some ideas to achieve this:

I have two tables, suppose 'request' and 'incident. They are related in such a way that once a request gets rejected, the incident also gets rejected. I need to send a notification when an incident gets rejected by adding a rejection comment on the request. How can I add that comment from the request table to the notification on the incident table?

Also, that comment field is of a type of Journal field which removes whatever we add in that field once we we save the request.

If email script is the option where we can glide the record from one table to another table, Please provide me some demo script as well.

Thanks in advance,

Amol.

[Niklas Peterson]

Hi,

I think the easiest way would be to have the rejection of the Request to trigger an update of the Incident and passing the Request comment as a comment on the Incident. Then you can trigger a notification based on the Incident being updated with a comment.

Regards,
Niklas

[Amol Pawar]

Hi @Niklas Peterson,

Thank you so much for your reply but could you please elaborate or provide me something to refer to?

Regards,

Amol