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.

[Ankur Bawiskar]

@JVINAY 

you added wrong code code log.

add this at the beginning i.e. just above the IF

gs.info('table is' + current.getTableName());

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

Output :

CIR number is empty , Please suggest modifications

Thank you.

[Ankur Bawiskar]

@JVINAY 

you can directly include link to record without email script in email body itself

check this

1) use the insert link option

2) then add details like this in that link

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

[JVINAY]

@Ankur Bawiskar 

Is it working statically or dynamically? We have three environments: DEV, TEST, and PROD. Suppose a notification is triggered in the TEST environment—it should redirect to the corresponding record on the Test Platform. Similarly, for DEV and PROD, it should redirect to their respective platform records

Thank you for your responce

[Ankur Bawiskar]

@JVINAY 

it will work in all environments as the URL is relative and not static and will pick the instance name etc automatically.

You can hover over that link and see it adds DEV instance automatically.

If you see I haven't included any instance name etc so it will work in all DEV, TEST and PROD.

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