I need to schedule an email notifications for Change request approval reminder fired 3 and 7 days before planned start date. How, please?

[gracjan]

I need to schedule an email notifications for Change request approval reminder fired 3 and 7 days before planned start date. I tried to use a workflow with sysapproval_group table but If I do I can't access planned start date from the change_request table and if I choose change_request table I can't add approvers in the notification. I tried to avoid coding. Please help.

[DirkRedeker]

Hi

This also no problem, if you go the "clean" way, as I described above. In the "clean" way, I would raise an event from within the workflow instead of sending the notification directly from the workflow activty.

Attach the Notification to the change_request table, so that you will have access to the record, which is firing the event.

From the Notification, you can run a mail script, which can add Recipients by doing a GlideRecord on the [sysapproval_approver] table for all records related / attached to your change_request.

There you will find the approvers, and on the approvers user record, you can find the email addresses.

That should work and bring you to the desired result.

Let me know if that answers your question and mark my answer as correct and helpful.

Enjoy & BR

Dirk

[gracjan]

Awesome! Would you be able to provide me with a sample of the mail scrip like that. I do not have that much experience with scripting.