post One daily email reminder that contains all approvals which can be approved or rejected in ServiceNow AI Platform articles

One daily email reminder that contains all approvals which can be approved or rejected

David Whaley — Tue, 22 Nov 2022 02:39:34 GMT

Approve all outstanding approvals from ONE email notification.

Re: One daily email reminder that contains all approvals which can be approved or rejected

M_iA — Thu, 12 Jan 2023 17:30:39 GMT

Thanks for posting this @David Whaley . This is just what I needed as some of my users had quite a few outstanding approvals. So collate into one email is a great step forward.

One thing I have noticed though is that once the notification is sent, it is attaching all of the notifications to just one record in the target field:

If you go onto that target record, it has every notification that was sent out regardless whether its related or not.

Any ideas? Did you encounter this?

Re: One daily email reminder that contains all approvals which can be approved or rejected

David Whaley — Thu, 12 Jan 2023 18:37:52 GMT

Yes, that is an issue I have and currently I have not found a resolution. I have tried to update it with query from the sys_watermark table but as of yet I have not been successful. The behavior is less than optimal but doesn't affect the approvals. We determined it was acceptable and our users preferred to have these in one email rather than our approvers getting multiple emails. I have not had any issues with this behavior. When I have a resolution I will be sure to post it.

Re: One daily email reminder that contains all approvals which can be approved or rejected

Joakim St_ckel — Wed, 22 Feb 2023 15:01:24 GMT

Hi @David Whaley,
I'm looking to implement this solution, but for Knowledge Articles. It seems like I should just have to edit the sc_req_item to kb_knowledge if I'm not mistaken, correct?

Re: One daily email reminder that contains all approvals which can be approved or rejected

David Whaley — Mon, 27 Feb 2023 22:16:39 GMT

Hi @Joakim St_ckel

Correct, in the script where you get your approvals for the requested items if you edit it with kb_knowledge. I did the same thing with Change Requests and just copied the section for requested items to reflect the change_request table.

Re: One daily email reminder that contains all approvals which can be approved or rejected

jparman — Wed, 15 Nov 2023 08:59:40 GMT

Hi @M_iA ,

Were you able to resolve the issue?

Re: One daily email reminder that contains all approvals which can be approved or rejected

DianaBTX — Wed, 28 Aug 2024 18:53:30 GMT

Hi David, thank you for this. i am testing and even though i have Hello ${approver}, in the email notification, all the emails are getting addressed to Hello Zach

Re: One daily email reminder that contains all approvals which can be approved or rejected

jacobspacek — Tue, 10 Sep 2024 14:53:18 GMT

@David Whaley

Thank you for such a wonderful detailed post!

Re: One daily email reminder that contains all approvals which can be approved or rejected

David Whaley — Wed, 18 Sep 2024 19:32:01 GMT

Hi @DianaBTX

Sorry about the late response. You would need to add a mail script in place of the salutation instead of

Hello ${approver},

you would have something like ${mail_script:open.approval.reminders.salutation}

The email notification script,

Name of the email notification script: open.approval.reminders.salutation

Script:

mailto = 'mailto:' + gs.getProperty("glide.email.user"); //Get Requested Items needing approval var app = new GlideRecord('sysapproval_approver'); app.addQuery('state','requested'); app.addQuery('approver', event.parm1); app.addQuery('sysapproval.sys_class_name','sc_req_item'); app.setLimit(1); app.query(); while(app.next()){ var ritm = new GlideRecord('sc_req_item'); ritm.get(app.sysapproval); //Salutation template.print('<table style="width:100%; border-collapse:collapse;">'); template.print('<tbody>'); template.print('<tr>'); template.print('<td colspan="2"; style="text-align: left; margin: 3px; font-size: 10pt; font-family: Montserrat, sans-serif; ">Hello: ' + app.approver.getDisplayValue() + '</td>'); template.print('</tr>'); template.print('</tbody>'); template.print('</table>'); }

Re: One daily email reminder that contains all approvals which can be approved or rejected

DianaBTX — Thu, 19 Sep 2024 13:37:54 GMT

Thanks David, my boss wants to go a different direction now 🙂

Re: One daily email reminder that contains all approvals which can be approved or rejected

Ravi Chandra_K — Sat, 21 Sep 2024 12:56:17 GMT

This is super useful David on such an important use case!!!

Bookmarked!

Kind Regards,

Ravi Chandra

Re: One daily email reminder that contains all approvals which can be approved or rejected

luv2learn702 — Mon, 16 Mar 2026 22:34:45 GMT

This is awesome, thank you for sharing!! @David Whaley were you able to figure out a solution for the following behavior: "once the notification is sent, it is attaching all of the notifications to just one record in the target field"