Skip to main content
arshbirs0002
New Participant
Mar 23, 2022 4:03 PM UTC
Question

How to get product Hyperlinks in Excel export

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

    5 replies

    mikes0011
    mikes0011
    Brainy
    Mar 23, 2022 4:09 PM UTC

    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).

    The Expression Guru
    peter.lewis
    peter.lewis
    Employee
    Mar 23, 2022 4:59 PM UTC

    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")

    mikes0011
    mikes0011
    Brainy
    Mar 23, 2022 5:00 PM UTC

    ooh, nice, i must've missed that one.

    The Expression Guru
    Terms & ConditionsAccessibility statement