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.
Discussion posts and replies are publicly visible
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.
How did you manage to do this? When I use this it puts a single quote in front of the = sign and treats it as text instead of formula
I am facing the same issue, were you able to find the solution for this? Thanks in advance
© 2023 Appian. All rights reserved.