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.