url to incident

[Joe78man]

Hello guys.

I've created an external report and would like to be able to link (add a hyperlink) to the given incident. I noted the URL (the address in the web browser) does not include the incident. 

Is there a way to have a link to the ticket (inc or task) that can be either pulled in a report or formulated? if the URL included the incident number it would be as easy as concatenating everything but the incident number + the cell that contains the incident.

Any ideas of how to do something like this?

Thanks,

[sachin_namjoshi]

You can export directly from URL for your report requirements.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/exporting-data/task/t_ExportDirectlyFromTheURL.html

Regards,

Sachin

[Joe78man]

You clearly didn't read

[Prateek kumar]

You can do this by creating a calculated field of type URl on incident table.

Try below:

1. Create a field

Type: URL

Calculated tab: calculated-- checked

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

once the field is created, add it in your report and download the report. Now you should be able to navigate directly to the incident from the Excel.

[Joe78man]

Thanks for the advise Prateek,

I wouldn't know how to do that. Where do I do it?