10 Replies Latest reply: Oct 27, 2015 4:33 AM by Alex Hamilton McLeod RSS

    Exporting hyperlink from a table to Excel

      We have a table that contains a URL which is stored in our database.  Rather than show the full URL, there is a hyperlink (imaginitively named 'Link').  The formula looks like this:

       

      ='Link'&<url>'&PageTable.PageURL
      

       

      This works like a treat in the application but when users export the table to Excel, they just see the text 'Link' and no URL. 

       

      Is there a way to export this and keep the hyperlink, so it says 'Link' in Excel and the link still works?  Naturally we could just use the PageTable.PageURL field, but it looks messy in the report.

       

      Thank you for your suggestions.