Salesforce.com allows you to create a custom field with type URL. However, sometimes you may want to create a custom URL for your special requirements.
For example, you have a separate application call Human Resource Management (HRM)
Your Salesforce application contains a custom field call EmployeeID__c in Contact object
Contact tab layout:
-------------------------------------------------------
Contact name | EmployeeID| E-mail | ...
-------------------------------------------------------
Thao Truong | 000111 | abc@yahoo.com |
--------------------------------------------------------
John Peter | 000112 | abc@gmail.com |
---------------------------------------------------------
When user clicks on EmployeeID cell, you would like it can be linked to your HRM application with the link like that:
http://YourHRM/Employees.aspx?ID=000111
or http://YourHRM/Employees.aspx?ID=000112
In this case, you could create a new custom field EmployeeIDURL with Formula type
Formula syntax:
HYPERLINK("http://YourHRM/Employees.aspx?ID=" + EmployeeID__c, EmployeeID__c, "_blank")
That's all.
For example, you have a separate application call Human Resource Management (HRM)
Your Salesforce application contains a custom field call EmployeeID__c in Contact object
Contact tab layout:
-------------------------------------------------------
Contact name | EmployeeID| E-mail | ...
-------------------------------------------------------
Thao Truong | 000111 | abc@yahoo.com |
--------------------------------------------------------
John Peter | 000112 | abc@gmail.com |
---------------------------------------------------------
When user clicks on EmployeeID cell, you would like it can be linked to your HRM application with the link like that:
http://YourHRM/Employees.aspx?ID=000111
or http://YourHRM/Employees.aspx?ID=000112
In this case, you could create a new custom field EmployeeIDURL with Formula type
Formula syntax:
HYPERLINK("http://YourHRM/Employees.aspx?ID=" + EmployeeID__c, EmployeeID__c, "_blank")
That's all.
Comments
Post a Comment