Getting RITM number and short description into survey mail notification
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-18-2024 01:54 PM - edited 09-18-2024 01:55 PM
I am having trouble with setting up a survey mail notification email script for a RITM request that shows the short description and RITM number I would love assistance if anyone is available. So this is an notification fired from the assessment table i believe and needs to know the target of the survey which is a Request Item:
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template, /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action, /* Optional GlideRecord */ event) {
// Initialize variables for the related request item's number and short description
var requestNumber = '';
var requestShortDescription = '';
// Check if the current assessment record has a related request item via the correct reference field
if (current.u_request_item) { // Replace 'u_request_item' with the actual reference field name
var requestGR = new GlideRecord('sc_req_item'); // Query the Request Item table
if (requestGR.get(current.u_request_item)) { // Retrieve the related Request Item record
requestNumber = requestGR.getValue('number'); // Retrieve the request item number
requestShortDescription = requestGR.getValue('short_description'); // Retrieve the short description
}
}
// Start the email body
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Hello,'));
template.print('</font></p>');
// Add the request number and short description to the email
if (requestNumber && requestShortDescription) {
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Request Number: ') + requestNumber);
template.print('</font></p>');
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Short Description: ') + requestShortDescription);
template.print('</font></p>');
} else {
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Request details are not available.'));
template.print('</font></p>');
}
// Continue with the rest of the email content
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('We have recently resolved your IT New Hire request.'));
template.print('</font></p>');
// Example button link for survey
var ess = gs.getProperty("glide.servlet.uri") + 'people_operations?id=take_survey&instance_id=' + current.sys_id;
template.print('<a href="' + ess + '" style="background-color: #FCC000; border: 1px solid #FCC000; color: #ffffff; font-size: 16px; font-family: calibri; text-decoration: none; border-radius: 3px; display: inline-block; padding: 5px;">');
template.print(gs.getMessage('Take me to the Survey'));
template.print('</a><br>');
// End the email body
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Thank you for taking the time to share your experience and feedback.'));
template.print('</font></p>');
template.print('<p><font size="3" color="#000000" face="calibri">');
template.print(gs.getMessage('Vituity Service Desk'));
template.print('</font></p>');
})(current, template, email, email_action, event);
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2024 03:48 AM
Hello,
On which table are executing this, incase it is sc_request then you do not have field for RITM. Meaning the line -
if (current.u_request_item) { // Rep
will not work.