Change approvals with change request details

[Moedeb]

I want to be able to send a copy of the change details with the notification that is sent requesting they approve the change.

I would be happy to either send the details directly in the body of the email notification or for the change request to be added as a pdf (or something similar) and attached to the notification.

Tried to update the notification to include the change request fields, but as it runs from the change approval table the fields available are limited.

Any ideas?

[AnubhavRitolia]

Hi @Moedeb 

As Approval field is reference of Task table and not Change Request table, you will get limited fields which specifically belongs to Task table.

You can use Email Script for this. There you can GlideRecord('change_request') and filter with current.document_id, and than you can get field values of Change request which you can print using template.print() function.

Just call this email script on your notification.

[Moedeb]

Thanks @AnubhavRitolia ,

I can do that, the only thing I still need though is the ability to have the fields display in a formatted way - ie: the implementation plan field for instance is over multiple lines and using the display field option in an email script it displays as one line and is very hard to read.

eg: I am going to do this. Then I'm going to do that. Followed by doing some other stuff. Then even more stuff and then it might work, if not I will try the following three things: 1. insert A 2. Insert b 3. Remove a and b

When it should look like this:

I am going to do this.

Then I'm going to do that.

Followed by doing some other stuff.

Then even more stuff and then it might work, if not I will try the following three things:

1. insert A

2. Insert b

3. Remove a and b

Ideas?

[AnubhavRitolia]

Hi @Moedeb 

Can you show the Email Script you have written for it?

[AnubhavRitolia · Accepted solution]

Hi @Moedeb 

As 'Approval For' is reference to Task table, it will show only Task fields.

To get fields values of Change request, you can try below link in your 'Message HTML' field of Email Notication:

${sysapproval.ref_change_request.implementation_plan}

Same way you can get other field values of Change Request like below:

${sysapproval.ref_change_request.<hange request field name>}

This won't require any email Script to be called.