Hi Team,
I have a database which stores document data of Appian.
The database table stores DOCUMENT ID of the product.
it is like
TaskOwnerName Document ID
A 356234
B 321434
C 413434
D 431431
Now I want a excel export of the above data but instead of document ID i want document hyperlink. I can do this easily on the grid. But I am unable to do that in Excel Export
Can you please help me, It is very urgent
Discussion posts and replies are publicly visible
I don't know if there's currently any supported way of doing this, however you might have some luck with the method suggested here (if it even works, which I'm not in a position to test at the moment). Note that the cell value would just need to be the entire URL, i believe, as I don't think there's a way to turn a cell into a hyperlink (at least without some sort of super complicated workaround).
There's actually an easier way to get the link to the document now too - you can just use the document() function and use the "url" property like this:
document(123, "url")
ooh, nice, i must've missed that one.
In Application it can be done easily, but how to transfer that link to Excel?
It kinda depends on which method you're using to generate your Excel file, which you didn't mention.