Link generation for column values in export to excel functionality

Question

Hi, 
 I have implemented a report which has a!exportDatastoreentitytoexcel for export to excel functionality from database view. 
 Now the requirement is to have link type to one of the column values so that on click of that link, user should navigate to the record dashboard. 
 Since this is report, there is no inbuilt functionality for having links in the excel sheet. 
 Please let me know how to achieve links for the exported column fields. 
 Thanks, 
 Saicharan

Mike Schmitt · Answer

I don't believe any of the existing Excel Export tools (either OOB or plug-in) have the capability of creating dynamic in-cell hyperlinks within the Excel document. If I were you I'd consider other approaches, perhaps something in-Appian if possible.

riteshp509 · Answer

Hi,

There are a few ways to implement.

1. Use process model to build and download report via a!startProcessLink.
2. Use webApi to build and download the report as CSV.

In both cases, you can manipulate the column value which you want as a hyperlink. Generate link with a!recordLink, wrap it with excel function "=HYPERLINK(""&a!recordLink.....&"""&user_freindly_displly_value&")".

This should work.