Export Button in Record Grid (Long URL links in Excel file)

Question

I am using the export button in a record grid field. However, when the Excel file is downloaded, some of the fields have long URL links in parentheses next to them. I am not sure how to get rid of the URL links. I think this is because one of the links is a a!recordLink() component and another link is created through a personalized expression rule. Wanted to see if anyone else had insight about this on getting the link to show as normal rather than a super long URL. I have provided a screenshot of what the Excel file looks like below.

Sanchit Gupta (Xebia) · Answer

Aight, got your issue now. 
 You are trying to add a link to a richTextIcon and due to accessibility issues the icon is not getting displayed in the resulting Excel. Alternatively, you can use altText parameter in richtextIcon() to display an alternate text when icon is not accessible.

Laurens Weijzig · Answer

I usually do not recommend enabling this feature for multiple reasons for which this can be one. 
 My advise would be to disable the export to excel button and instead build your own functionality for which you can completely control the Excel output itself, as well as who may access it.

Sanchit Gupta (Xebia) · Answer

How you have configured that grid column? 
 You can pass that generated link from ER in a a!safeLink() and use it an a richTextDisplayField() 
 a!gridColumn(
 label: "Test",
 value: a!richTextDisplayField(
 value: a!richTextItem(
 text: "Test",
 link: a!safeLink(uri: "https://www.youtube.com/")
 )
 ),
 align: "START",
 width: "AUTO"
 )

Export Button in Record Grid (Long URL links in Excel file)

Top Replies