Exporting fields as active hyperlinks in an Excel file

Dave Rose
Tera Contributor

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?

 

6 REPLIES 6

rlatorre
Kilo Sage

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

Prateek kumar
Mega Sage

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 ;

 

find_real_file.png


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Dave Rose
Tera Contributor

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

 

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