Exporting fields as active hyperlinks in an Excel file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2019 08:58 AM
When exporting data into an Excel file how can I format a file path in a source string field so that the resulting cell in the exported Excel file is an active hyperlink to the file path rather than static plain text?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2019 12:49 PM
You can create a URL field to house the URL. Populate the field by concatonating the URL from the sys_id and add to list views / reports.
https://YOURINSTANCE.service-now.com/nav_to.do?uri=incident.do%3Fsys_id%3Dba416fe013003f00cc0173076144b0b7
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2019 12:59 PM
The way we did it is creating a new field of type URL and made it a calculated field.
In the calculation section, you have to put this line. This will do the trick.
'https://' + gs.getProperty('instance_name') + '.service-now.com/nav_to.do?uri=dmn_demand.do?sys_id=' +current.sys_id ;
Please mark my response as correct and helpful if it helped solved your question.
-Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2019 11:06 AM
Thanks for the feedback so far but I may have not explained this too well....
What I currently have is a data set that lives in Excel that use used by many people to drive a process.
We are migrating this to ServiceNow so that all this data is managed and maintained in ServiceNow and not in a spreadsheet
One of the columns of the current Excel sheet contains a hyperlink to a shared file location (UNC path) - e.g. \\<server name (FQDN)>\<folder>\<folder>\<folder>\filename.docx
I have tried storing this as a string in the table both as above and also with the following syntax:
file://\\<server name (FQDN)>\<folder>\<folder>\<folder>\filename.docx
Both ways, when I export the record into an excel sheet, the cell is flat text rather than an active hyperlink.
I have offered a workaround in that the following easy steps get the link active again:
Open the exported file
Select the cell
Press F2
Press Enter
Click the 'now' active hyperlink to open the file in the shared folder
Unfortunately the recipients of this new functionality see this as a big issue and don't accept the above steps as a workaround.
Their ask is - can the shared folder path be stored in a format in the form where it's an active hyperlink to the required folder path and then when the records are exported into an Excel doc, the same active hyperlink be already active and 'clickable' in the sheet?
One thought I have had is an HTML format field??
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2019 12:29 PM
Instead of storing your field in string field, why not store it in a URL field type in servicenow
Please mark my response as correct and helpful if it helped solved your question.
-Thanks