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  ||  9x 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  ||  9x 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  ||  9x 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  ||  9x 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader