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

[Brad Tilton]

You can also make this instance agnostic with a property call:

'https://' + gs.getProperty('instance_name') + '.service-now.com/nav_to.do?uri=incident.do?sys_id=' + current.sys_id;

[paul971]

Hey everyone --   this (^^ up there from Brad ^^) is the right answer.

thanks b-rad. i was fighting with the url/uri for two hours, i don't know why SN makes it so cumbersome.. but this did exactly as i needed. it's cool too bc you can update the table name to anything you need so it works on custom tables too, nice one man. thanks

[williamsun]

You need that extra " before the https to start the quote that ends after sys_id=

(I am testing it out and my subproduction instances are just s____o s____l____o____w...)

I also checked the URI that comes in with the email and there is an extra parameter needed.

This is the final one, I tested and it works:

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

[akashsharma]

I have also done it but in exported file it is showing a link of URL.I want to show the incident name and after I click on it ,my page should redirect to that URL page. I am unable to do it.

[amacqueen]

Akash I think I may have experienced the same thing as you if I understand your question.

Try to select the cell with the URL in it and then navigate away from that cell and you should find the URL then becomes a clickable link and can be selected.