Sort Hyperlink fields by Friendly Text, not by HTML - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
640  Points
Idea has been posted. Give it an upvote or downvote.

Sort Hyperlink fields by Friendly Text, not by HTML

Operational Reporting

Currently if you have a formula field that is a hyperlink and you try to sort it in a report, it sorts on the URL, not the friendly text. This means that hyperlink fields are unsortable in reports. Example: If you have a formula field called Full Name for a Contact. It concatenates the first and last name together with a space between. When you sort this field it will sort on the text of the name as it should. Aaron Smith Alan Jones Bob James ... If in the formula field, you wrap that name in a hyperlink to that Contact's record, when you sort it in a report things are weird. The sort gets evaluated on the URL, which displays the names out of order. Bob James Aaron Smith Alan Jones ... It would be great if the sort were evaluated on the friendly name as noone would ever want to sort on the URL, but often would want to sort on the name.

Merge Idea · Flag

  • Upvotes
  • Downvotes



from AppExchange


No results found.

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.