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

Is this issue solved ? If yes, then how ?

Dave Rose
Tera Contributor

Thanks for the suggestion. Unfortunately a url field was my starting point. The first issue was that the link failed to work full stop from within the form and the second issue is that the value in the url field got converted by the export mechanism so that resulting string in the excel cell also failed to work completely.

 

Any advice you might have on how to set the right syntax for a unc path within a ServiceNow url field would be greatly appreciated!