Print this page

Formula that refers to text field is displayed as hyperlink

Knowledge Article Number 000220235
Description Formula field that refers to a text field is displayed as hyperlink, even though the field is displayed as text in originating field.
Resolution This is working as designed and can be tested by following the steps below.

The recommendation would be to test this in sandbox or developer environment.

Step 1: Create a custom field in account object by following the steps:

1. Click on Setup | Build | Customize | Accounts | Fields
2. Scroll down to Account Custom and fields and Relationships and click on New
3. Select the data type as 'Text' and click Next
4. In next screen enter the Field Label as "Test Text" or any name of your choice
5. Enter 36 in the length. Click Next
6. Make the field visible only to required profile as this is only a testing
7. Click Next
8. Select the required layout and Click Save (Since it is testing you can select all layout)

Open a test account (Let us call it ABC Labs) and populate the value 'www.salesforce.com' in then newly created field. Upon saving you can notice that the website URL is not displayed as hyperlink

Step 2: Create a custom field in contact object by following the steps:

1. Click on Setup | Build | Customize | Contacts | Fields

2. Scroll down to Contact Custom and fields and Relationships and click on New
3. Select the data type as 'Formula' and click Next
4. In the next screen enter the field label as "Test Text acc lookup" or any name of your choice
5. Choose the formula return type as 'Text'. Click Next
6. In the formula screen, click on Insert field and select Contact> Account> Test Text. Click Insert
7. Click Next. Make the field visible only to required profile as this is only a testing

8. Click Next
9. Select the required layout and click save (Since it is testing you can select all layout)

Open account ABC Labs and scroll down to Contact related List.

Click on any of the contact and you can notice that 'Test Text Acc Lookup' contains the value 'www.salesforce.com' and this is displayed as hyperlink. This is an expected functionality.




promote demote