Requested Item as URL link in the Excel report

[Shree Nag]

Hello,

Appreciate your guidance in advance !

I have created a report, which has approvers names, email and the the requested number that is pending their approval. This report needs to be sent as an excel spreadsheet to all approvers through a scheduled job.

How can I make the report have the excel spreadsheet of the above information with requested number as URL link to the ServiceNow instance approval.

I followed along an article in the community forum to make the calculated value of the URL link on incident table to 

have this, but this is did not produce the URl link, when i downloaded as teh report as excel.

Please help !

(function calculatedFieldValue(current) {

//"https://myinstance.service-now.com/nav_to.do?uri=incident.do?sys_id=" + current.sys_id;"

//return '';  // return the calculated value

var url1=gs.getProperty('glide.servlet.uri')+"incident.do?sys_id="+current.sys_id;

return url1;  // return the calculated value

})(current);

[Shree Nag · Accepted solution]

I figured out my problem. I had to do the URl link on Approval table not incident table.

Thanks All