Add HTML link to Incident ID for exported report

[StevenITSM]

Hi

I have created some incident reports which are scheduled to export. Once the data is exported in to CSV or Excel it loses any HTML hyperlinks. I would like to have a field for each incident that retains an HTML link to the ticket as it appears in ServiceNow.

Here the link is clickable and takes me to the incident. How can I retain this link at export or create a field that has a link.

I have seen that I can add additional fields with URL or Hyperlink functionality, but I am unsure what information to add to have that field contain the relevant incident ID of the ticket.

If you can help that would be appreciated.

Thanks

[maheshkhatal]

@StevenITSM it will update the incident in the following manner see the screenshot for the reference , make sure you make the field as read only

[StevenITSM]

Thanks for the feedback, I am going to test it this week and will confirm if successful.

[StevenITSM · Accepted solution]

Unfortunately I have been unable to get this working correctly, I have tried following the steps above but am unable to get the URL field to display the correct information. I am closing the case for now, as I am changing the way we create reports.
Thanks for your help