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

[williamsun]

I did something similar to this with my homepages table.

1. Create a new field on the problem table of type URL

2. Make it a "Calculated" field

3. Put the following line in the "Calculation"

"https://your_instance_name.service-now.com/nav_to.do?uri=problem.do?sys_id=" + current.sys_id

Please let me know if it works as I have not tried it yet for this table

(I changed the line, forgot you want to export and use this link from outside of ServiceNow)

[amacqueen]

Rajnish I hope you don't mind me partially hijacking your thread.

William I tried this to get the same sort of output from incident but when I exported the data I got nothing (nor could I see the data in SN)

See above for my dictionary entry.

Thanks

[RKumar3]

Hi Angus, If you add the quotes in the beginning of the URL it will work. It worked for me and I can see the double quotes missing in your calculation. Rajnish

[amacqueen]

And I thought the quotes were a typo as they weren't closed off at the end 🙂