Hyperlink in CSV Report

[MarjanA]

Hi,

I am generating a CSV report that lists certain records, I need a column that contains a hyperlink to open the record. Is this possible? Ideally the hyperlink will be the record number and it'll link to the record and be clickable in a CSV file. 

[Ankur Bawiskar]

@MarjanA 

How are you generating that csv report? is it via reports module and scheduled report?

If yes then OOB not possible to do.

You will have to store the record link in a custom URL field in that table and use that field as column during your CSV report generation

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@MarjanA 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MarjanA]

Hi yes, it is generated via the reports module. Is there any other way to create a CSV without attaching it to 1 particular record? 

I currently have stored the record link in a custom URL field in that table and used that field as column during my CSV report generation, however, the link is not clickable in excel and it isn't a hyperlink, is there a workaround? 

[MarjanA]

I am generating via reports module. Currently I am storing the record link in a URL field and using it as a column, however, it is not clickable in excel and it isn't a hyperlink, is there a workaround?