Sys id displayed instead of Name in email notification

kun1 · ‎10-16-2019

Mail script:-

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

template.print(current.variables.property_authorization_card.Type+ '\n\n'+"<br/> Property card Details");

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

here issue is it provide me the sys id of Type. How to populate name instead of sys id.

hvrdhn88 · ‎10-16-2019

search on google , you will find plenty of reference regarding the style .

try with below code.

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

var arr =[];

var variableArray = JSON.parse(current.variables.property_authorization_card);

for(var i=0; i < variableArray.length; i++) {

var gr = new GlideRecord('table name');

gr.addQuery('sys_id','IN',variableArray[i].Type);

gr.query();

gs.log('Row count'+ gr.getRowCount());

while(gr.next()){

arr.push(gr.name);

}

template.print(arr+ '\n\n'+"<br/> Property card Details");

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

View solution in original post

hvrdhn88 · ‎10-16-2019

try now

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

template.print(current.variables.property_authorization_card.Type.getDisplayValue()+ '\n\n'+"<br/> Property card Details");

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

kun1 · ‎10-16-2019

after adding getdisplayvalue, it provide me "undefined".

hvrdhn88 · ‎10-16-2019

Type field is a reference field ?

field name should be in small letter.

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

template.print(current.variables.property_authorization_card.type.getDisplayValue()+ '\n\n'+"<br/> Property card Details");

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

kun1 · ‎10-16-2019

Type field is reference field and backend value is "Type".