Email Script Not working

[JVINAY]

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

[Ankur Bawiskar · Accepted solution]

@JVINAY 

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

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

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

[JVINAY]

@Ankur Bawiskar 

It's coming CIT number ( task number)

But I want CIR Number - Central intake request number

Thank you for your responce.

[Ankur Bawiskar]

@JVINAY 

notification is on which table?

if notification is on Table A but you want to show Table B record then you need to use email script and use GlideRecord to show the current number and correct link

what's your use-case?

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

[JVINAY]

@Ankur Bawiskar 

The Notification in "u_cloud_intake_request " table

My requirement is:

I want to add Central intake platform (u_cloud_intake_request)  link  to the email notification

but this notification in the "u_cloud_intake_task" (Cloud task) table

Please help how can i achieve this

Thank you.

[Ankur Bawiskar]

@JVINAY 

then as I mentioned you need to use email script and use GlideRecord

Is intake task a child of intake request?

if yes then do this in email script, give correct u_parent field on task which refers to request

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

    // Add your code here

    var taskRec = new GlideRecord('u_cloud_intake_task');
    taskRec.addQuery('u_parent', current.sys_id); // give here the correct field which holds parent
    taskRec.query();
    if (taskRec.next()) {
        var url1 = gs.getProperty('glide.servlet.uri') + 'u_cloud_intake_request?sys_id=' + taskRec.getValue('sys_id');
        template.print('<a href="' + url1 + '">' + taskRec.getValue('number') + '</a>');
    }

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

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

[JVINAY]

@Ankur Bawiskar 

I have updated this Code

But not working showing CIT number

Brief explanation :

This notification in the Cloud task table : u_cloud_intake_task  

Parent of this Cloud task in Cloud account request

Cloud account request table name  :  u_cloud_intake

But I want to add in the notifications  u_cloud_intake_request (central intake request) in the Email body

Thank you