We are using Shield Platform Encryption...
And we need to encrypt the content of some formula fields.(Formula fields can not be encrypted)
To solve it. It is necessary; Create a new field of some other type (Text / URL), and the functionality migrate it to a Workflow / ProcessBuilder / Trigger.
We cannot use Workflows because the "HYPERLINK" function does not exist there.
We did the test by creating a field type "TEXT" and a field type "URL" That are updated by a process builder.


* The first problem is that it returns a concatenation of the url + the friendly text + additional words:   “_HL_ENCODED_www.example.com_HL_friendly Text_HL__blank_HL_Undo”
* For a field of type "TEXT" we cannot click on the hyperlink. (because it is plain text).
*For the URL field the full address is shown, you cannot put a friendly text. (besides the extra words that the process builder puts.)


We need a solution to have a link but with a friendly text, without using formula fields or lighning compones / VFP.
Any ideas?

We are using Shield Platform Encryption...
And we need to encrypt the content of some formula fields.(Formula fields can not be encrypted)
To solve it. It is necessary; Create a new field of some other type (Text / URL), and the functionality migrate it to a Workflow / ProcessBuilder / Trigger.
We cannot use Workflows because the "HYPERLINK" function does not exist there.
We did the test by creating a field type "TEXT" and a field type "URL" That are updated by a process builder.


* The first problem is that it returns a concatenation of the url + the friendly text + additional words:   “_HL_ENCODED_www.example.com_HL_friendly Text_HL__blank_HL_Undo”
* For a field of type "TEXT" we cannot click on the hyperlink. (because it is plain text).
*For the URL field the full address is shown, you cannot put a friendly text. (besides the extra words that the process builder puts.)


We need a solution to have a link but with a friendly text, without using formula fields or lighning compones / VFP.
Any ideas?