+ Start a Discussion
Rich13Rich13 

SDFC record links in the Report

Hi,

I would like create a report with SFDC links to the respective records as a seperate column. How can I creat such kind of report?

Please suggest. Thank you
Best Answer chosen by Rich13
Ramu_SFDCRamu_SFDC
You can accomplish this using formula field. Follow the steps below

1. Create a custom Formula field with datatype as Text.
2. Enter field label, field name
3. In the formula criteria, enter the formula as below

HYPERLINK( Id , "URL" ,'_blank')

_blank will open the record in a new tab, URL is a friendly name which gets hyperlinked to the record url.

Please mark this as a solution if this resolved your issue for others benefit.

All Answers

Ramu_SFDCRamu_SFDC
You can accomplish this using formula field. Follow the steps below

1. Create a custom Formula field with datatype as Text.
2. Enter field label, field name
3. In the formula criteria, enter the formula as below

HYPERLINK( Id , "URL" ,'_blank')

_blank will open the record in a new tab, URL is a friendly name which gets hyperlinked to the record url.

Please mark this as a solution if this resolved your issue for others benefit.
This was selected as the best answer
Rich13Rich13
Thnanks Ramu. This has helped me. I just tweeked the formula little further and got the required output.
Luke PleseLuke Plese
I'd like to have a column on an account report that has the direct URL to pull up that report. I tried the above and had no luck. By chance Rich did the tweek you did accomplish this?