Is there a way to add record reference link in exported excel report?

[RKumar3]

Hi All, I have a requirement wherein I need to export an excel report on problem table. I am able to export the report appropriately except the fact that I am not able to export the link to problem records. I am only getting the Problem record number in the xls but not the reference link so that user can click the reference link directly from the excel and open the problem record in ServiceNow. Anyone has done something like this before? Many thanks in advance. Regards, Rajnish Kumar

[akashsharma]

Hi Angus that link is working but I don't want that link to be on the excel sheet instead of that I want incident number to be attached to that link.So that when I click on that incident number it should redirect to that link attached page.

[amacqueen]

Been scratching my head about that I can't thing of any way off the top of my head.

[amacqueen]

I have finally managed to come back to this and have reviewed the new comments since my last post however despite that I'm still having a problem getting a valid URL in an export.

I have created a URL field and then added a dictionary entry to make the field calculated and added the calculation:-

"https://myinstance.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=" + current.sys_id + "%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true"

However when I export a list of incidents that includes the URL field every URL I select returns me to my home page, see below:-

https://myinstance.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=4ee3176b0f43f10055b138b362050e...

Can anyone see where I'm going wrong please?

[RKumar3]

Hi William, Thanks for the response. It gives me the URL in the field and I can use this in the report. But I wanted   ticket number to be the link to the ticket so that if I click on the number of the ticket it should redirect me to the URL you have setup. Is there a way to do this? Thanks again. Rajnish

[williamsun]

Hmm, so you want this to be default on the Excel export, so that it adds the link to the actual number?

Not sure if this is possible.

I tried with some w3schools help and got this:

"<a href=\"https://instance.service-now.com/nav_to.do?uri=table.do%3Fsys_id=" + current.sys_id + "%26sysparm_stack=table_list.do%3Fsysparm_query=active=true\">" + current.number + "</a>"

But the link shows up just like that on the list view and export.   It only works as desired on the form view if you add it.