Loading

Combine Text Fields and External URL Links Using the HYPERLINK Formula in Salesforce

Veröffentlichungsdatum: Jun 19, 2026
Beschreibung

In Salesforce, you can use a formula field with a return type of Text to combine data from text fields and generate clickable hyperlinks from URL fields. This is useful when you need to display a user-friendly label that links to an external URL stored in a Salesforce URL field.

Lösung

For example, you have a URL field called 'URLfield__c' that has a value of 'www.salesforce.com' and a text field that has a field name of 'Textfield__c' with a value of 'Test'.



This is the sample formula that you can create:

         HYPERLINK("https://"+ URLfield__c, Textfield__c,'_blank')

 

In this formula, URLfield__c is the API name of your URL field and Textfield__c is the API name of your text field. The '_blank' parameter opens the link in a new browser tab. Replace these field names with the actual API names of your fields.

The expected results on the formula field:
Test (with a clickable link that opens up a new tab from your current browser to take you to the link that you have specified in the URL field)

Nummer des Knowledge-Artikels

000381087

 
Laden
Salesforce Help | Article