Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Email Script Not working

JVINAY
Tera Contributor

Hello,

 I have written below Email script 

----------------------------------

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template, /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action, /* Optional GlideRecord */ event) {

    // Add your code here
    if(current.getTableName() == 'u_cloud_intake_task') {
        var url1 = gs.getProperty('glide.servlet.uri') + 'u_cloud_intake_request?sys_id=' + current.getValue('sys_id');
        template.print('<a href="' + url1 + '">' + current.getValue('number') + '</a>');
    } else if(current.getTableName() == 'u_cloud_intake_request') {
        var url2 = gs.getProperty('glide.servlet.uri') + 'u_cloud_intake_request?sys_id=' + current.getValue('sys_id');
        template.print('<a href="' + url2 + '">' + current.getValue('number') + '</a>');
    }
--------------------------
 
I have added this email script in One notification body , 
Out put :

it getting CIT number , I want CIR number,

Please help me .

Thank you

2 ACCEPTED SOLUTIONS

@JVINAY 

earlier you said the notification is on u_cloud_intake_request  table so I gave script accordingly

AnkurBawiskar_0-1754481565153.png

 

If notification is on u_cloud_intake_task and you want to show REQ then simply use this and no email script required

Use the correct field name on the u_cloud_intake_task which refers to the Intake Request

AnkurBawiskar_1-1754481898414.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

@JVINAY 

is the field name "u_cloud_intake" on intake task referring to intake request?

share field configuration screenshot

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

22 REPLIES 22

@JVINAY 

earlier you said the notification is on u_cloud_intake_request  table so I gave script accordingly

AnkurBawiskar_0-1754481565153.png

 

If notification is on u_cloud_intake_task and you want to show REQ then simply use this and no email script required

Use the correct field name on the u_cloud_intake_task which refers to the Intake Request

AnkurBawiskar_1-1754481898414.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

@Ankur Bawiskar 

I have updated this 

 

JVINAY_0-1754484049315.png

Email look like this 

JVINAY_1-1754484131276.png

But I click the CIR number it will redirect to new record, not existing record.

When I click the CIR number it will redirect to the existing same record, not new record.

 

Thank you.

 

 

 

Thank you

@JVINAY 

is the field name "u_cloud_intake" on intake task referring to intake request?

share field configuration screenshot

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

@Ankur Bawiskar 

I made small changes.

JVINAY_0-1754919885098.png

Thank you for your support.

@JVINAY 

Glad to help.

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