Create a Business Rule:
- Navigate to System Definition > Business Rules in your ServiceNow instance.
- Create a new Business Rule, for example, Send Approval Notification.
Configure the Business Rule:
- Set the When to run condition. In this case, it would be when the approval_status field changes.
- Set the Advanced field to run on the u_approval_table table.
Write the Script:
(function executeRule(current, previous ) {
// Check if the approval status is 'rejected' or 'selected'
var approvalStatus = current.approval_status;
if (approvalStatus == 'rejected' || approvalStatus == 'selected') {
// Define the notification message
var notificationMessage = "Approval status changed to: " + approvalStatus;
// Create a GlideEmailOutbound object
var email = new GlideEmailOutbound();
// Define email parameters
email.setSubject("Approval Status Change");
email.setBody(notificationMessage);
email.addTo("recipient@example.com"); // Specify the recipient email address
// Send the email
email.send();
}
})(current, previous);
Link the Script to the Business Rule:
- In the Business Rule configuration, set the Script field to the script you've written.
Workflow:
- Update an approval record in u_approval_table to have a status of 'rejected' or 'selected'. This should trigger the Business Rule, which will in turn send an email notification
Mark my answer helpful or correct id applicable.
Thanks & Regards,
Sayali Gurav
