I know this is an old post, but I ran into the same problem.
The reason the notification is being sent more than once (or one per each question) is because the query is running against the asmt_metric_result, and so each time a record is inserted the notification will trigger.
I came across the same issue, to resolve it, I ran the query againts the asmt_assessment_instance table, then I used the asmt_metric_result and got the instance display value. I needed the display value to compare it to the string (number) value from asmt_assessment_instance table.
Now after I found all the matches, I can add them to the email notification based on
Here is the modified script (mail script).
I tested this and it only sends once (even though the survey has 4 questions
(function runMailScript(current, template, email, email_action, event) {
// Add your code here
var astGR = new GlideRecord("asmt_assessment_instance");
astGR.addQuery("number", current.number); // this value is a string not a sys_id
astGR.query();
if (astGR.next()) {
var gr = new GlideRecord("asmt_metric_result");
gr.addQuery("source_id", 'SYS_ID OF SOUCE GOES HERE'); // you can use any other identifer this is just to run the query and filter the records
gr.query();
while (gr.next()) {
var asmtMR = gr.instance.getDisplayValue(); // instance is a reference field, so you want the "display value" not the sys_id to compare to astGR string number
if (asmtMR == astGR.number) { // compare the string number with the instance display value
template.print(gr.metric.getDisplayValue() + ": " + gr.string_value + "<br />"); // this will add each answer to the notification
}
}
}
})(current, template, email, email_action, event);Output:
