Hi Manoj,
We have a custom table in servicenow [u_schedule_plan: Schedule plan].
If the 'Created by' user of the schedule plan record is an inactive user, then we have to send email notification to the manager of the created by person.
Notification content:
The created by person of the schedule plan record is inactive and please provide an approval for deactivating the schedule record.
'Approve' button
Note: Approve button needs to add in the Notification content.
Once the Manager click on Approve button then an outlook window should open and manager will send a response to ServiceNow.
Then deactivate the schedule plan record once ServiceNow get a response from manager.
This is the requirement which we have.
We are implementing this in schedule job.
We have created Event and Notification. In the Notification content we have added the Approve button.
Once manager click on Approve button, it is redirecting to outlook page and manager can send response to ServiceNow also.
But the received email having error string: findProcessor Did not find a matching email processor. and also schedule record is not getting changed to inactive.
Email Script used here is :
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
var flag = "Approve";
var emailbod = "I approve the request";
var emailbody1 = "Note: While replying please do not change the subject and body of the email";
var instance = gs.getProperty("instance_name");
var link = "https://" + instance + ".service-now.com";
var mark = email.watermark;
var number = current.u_number;
var emailAddress = instance + "@service-now.com";
var mailLink = "";
mailLink = '<a href="mailto:' + emailAddress + '?subject=Re: Approval for deactivating the schedule plan records of user ' + current.sys_created_by + '&body=' + '<p>' + emailbod + '</p> <p>' + emailbody1 + '</p>' + '%0D%0A' + '%0D%0A' + mark + '" style="border: none; color: white; padding: 6px 12px 6px 12px; text-align: center; text-decoration: none; display: inline-block; font-size: 9pt; margin: 4px 2px; cursor: pointer; background-color: #28a745; border-color: #28a745; font-family: Arial; border-radius: 7px;"> ' + flag + ' </a>';
template.print(mailLink);
})(current, template, email, email_action, event);
Inbound email action:
Condition Script: (email.subject.indexOf('Approval') >=0 )
Business rule :
gs.include('validators');
var emaiId = email.subject;
var n = emailId.split(" ");
var userEmail = n[n.length - 1]; // have email id
var schPlan = new GlideRecord("u_schedule_plan");
schPlan.addEncodedQuery('sys_created_by=' + userEmail );
schPlan.query();
while(schPlan.next()){
schPlan.u_active='false';
schPlan.update();
}
Type: Reply
Target table: u_schedule_plan table
Thank you!
