Sys id displayed instead of Name in email notification

[kun1]

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.

[Charles G]

Hi Kun

You should start learning to write a simple glide Record script mate, so that you can do your own work and get paid for it.

[Harsh Vardhan · Accepted solution]

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);

[Lukasz Bojara]

Hi,

Try adding getDisplayValue() after Type.

If my answer helped you in any way, please then mark it as helpful. If this solved your case please mark it as correct answer. Thank You.

Best regards,
Łukasz

[kun1]

after adding getdisplayvalue, it provide me "undefined"

[Lukasz Bojara]

Have you ensured that names of the fields and also the getDisplayValue() is ok, no typo, no big letters instead of small and no small letters instead of bid? Java Script is Case Sensitive so it must be written exacly the same way like it was created.

Also what type of object is current? Is it a RITM?