Hello All ,
There is a requirement to display Variable Information in Approval Notifications for a Record Producer submitted in a Scoped Application, so for that we are using this email script somehow it is working , But variable details are showing up duplicate.
This is the script we use :
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
// Add your code here
if (current.source_table == "x_tmms7_finance_finance_ticket") {
template.print("Summary of Finance Ticket ");
}
template.print('<table border="1">');
var tbl_obj = new GlideRecord('x_tmms7_finance_finance_ticket');
tbl_obj.get('sys_id', current.sysapproval);
for (var key in tbl_obj.variables) {
template.print("<tr>");
if (tbl_obj.variables[key]) {
template.print("<td>" + getQuestionLabel(key) + "</td>\r\n");
template.print("<td>" + tbl_obj.variables[key].getDisplayValue() + "</td>\r\n");
template.print("</tr>");
}
}
template.print("</table>");
function getQuestionLabel(question) {
var vara = new GlideRecord('item_option_new');
vara.addQuery('name', question);
vara.query();
if (vara.next()) {
var question_label = vara.question_text;
return question_label;
}
}
})(current, template, email, email_action, event);
and these are the variables information that we had in a form while submitting a request.
This is the approval notification but there are duplicate variables are showing up, Please guide.
1 ACCEPTED SOLUTION
