How to get Hyperlink in excel?

Certified Senior Developer

Previously we were using a hyperlink as a record link to open up a summary view,as per the  customer's requirement the design has been restructured (not using record and record link)and currently we are using dynamic link as a hyperlink to open up a summary interface.The Problem here is that,when we use appian's inbuilt export functionality, as we are not using the record link as a hyperlink,it is just appearing as a text instead of link.Is there is any other suggestion you would give here in order to get back that link in the exported data?

  Discussion posts and replies are publicly visible

  • Create a link to a web page
    On a worksheet, select the cell where you want to create a link.
    On the Insert tab, select Hyperlink. 
    Under Display Text:, type the text that you want to use to represent the link.
    Under URL:, type the complete Uniform Resource Locator (URL) of the webpage you want to link to.
    Select OK.

    Regards,

    Rachel Gomez

  • To retain the hyperlink as a clickable link in the exported data, you can add a custom function to format the dynamic link as an HTML hyperlink in the exported data. You can do this by creating a custom function that takes the dynamic link as an input and returns a string that contains the dynamic link formatted as an HTML hyperlink.

    Here's how you can create a custom function in Appian to format a dynamic link as an HTML hyperlink:

    1. Create a new expression rule in your Appian application.

    2. In the expression rule, define a custom function that takes the dynamic link as an input and returns the dynamic link formatted as an HTML hyperlink. Here's an example of what the function might look like:

      function formatLink(link) {
        return "<a href='" + link + "'>" + link + "</a>";
      }
    3. In your summary interface, use the custom function to format the dynamic link as an HTML hyperlink. 

    4. When you export the data from Appian, the dynamic link will now appear as a clickable HTML hyperlink in the exported data.

    This should solve the issue of the dynamic link not appearing as a clickable link in the exported data.