How to get Hyperlink in excel?

Question

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?

mobiw5611 · Answer

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: Create a new expression rule in your Appian application. 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 "" + link + ""; } In your summary interface, use the custom function to format the dynamic link as an HTML hyperlink. 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.