How to include variable editor variables in Email notification

Mrman · ‎01-06-2021

Hi All,

I have configured the variable formatter and added a Section on HR case record to show the Record producer variables submitted by employee on to the HR case as shown below .

Please help me with a requirement to include these variables under 'Case details submitted' section in the Email Notification sent to the employee when case is submitted .

I am not finding a way to call these variables in Notification , please guide.

Ankur Bawiskar · ‎01-07-2021

@ramamr

You need to use email script for this

Name: show_variables

Script:

(function runMailScript(current, template, email, email_action, event) {

	// Add your code here

	template.print('Variables: <br/>');
	
	var variables = current.variables.getElements(); 
	for (var i=0;i<variables.length;i++) { 
		var question = variables[i].getQuestion();
		var label = question.getLabel();
		var value = question.getDisplayValue();
		if(label != ''){
			template.space(4);
			template.print('  ' + label + " = " + value + "<br/>");
		}
	} 

})(current, template, email, email_action, event);

Then include it in the email notification like this

${mail_script:show_variables}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎01-07-2021

@ramamr

Example below using the above script

It should take the variables dynamically

Note: for MRVS you will have to enhance it

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Mrman · ‎01-07-2021

Thanks @Ankur Bawiskar for your response.

I tried the script you mentioned but I am seeing 'null' in the email notification for variables.

Please suggest.

Below is the variables in variable editor on HR Case:

Below is the Email Triggered :

Ankur Bawiskar · ‎01-07-2021

Hi,

so it is not getting the question label?

it worked fine for me

try adding logs

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Mrman · ‎01-07-2021

This solution worked for showing variables in email notification thanks @Ankur Bawiskar

Dillin Bradley · ‎11-11-2022

This works awesome for Variables, but how would i add Variable Sets and their Variables to this as well?