Is it possible to set the link text for a URL field type?

Is it possible to provide a "link text" for a URL field type such that displaying the URL-typed field shows the link text and not the URL stored in the URL field? 

Background: In a "parent" Opportunity / Account / Contact, we store a link to the last Task, Note, Email, Call, Meeting record created or updated against that related "parent". We also store the Task / Note / etc. Date Modified as a Last Activity Date for the "parent" record. This allows us to do some reporting on the Last Activity against a "parent" record and provide an easy way to see what that last activity was.

Here is a screenshot of the Last Activity Link (URL field type) showing the URL. We would like the link text to be some actual text...not having the link text be the actual URL. 

Parents
  • Hi ,

    I created what i think is exactly what you are asking in a few modules of ours.

    Its just a text fields using CONCAT and a big IFELSE statement...  In the example screenshot below DHL is selected, the first part is their tracking url, followed by the tracking number:

    And the first part of the Calculated Formula: 

     ifElse(
     contains($shippedvia,"DHL"),
    concat("___the dhl tracking url here___",$trackingnumber),
     ifElse(contains($shippedvia,"UPS"), ...  and so on...

    We then use this TEXT field to populate our URL field.  As  &  mention also:  the text field will be 'live' - before save it will change as I change the tracking number the courier in my example.    The URL field only populates after save.

    Anyway, hopefully an example helps...
    Luke.

Reply
  • Hi ,

    I created what i think is exactly what you are asking in a few modules of ours.

    Its just a text fields using CONCAT and a big IFELSE statement...  In the example screenshot below DHL is selected, the first part is their tracking url, followed by the tracking number:

    And the first part of the Calculated Formula: 

     ifElse(
     contains($shippedvia,"DHL"),
    concat("___the dhl tracking url here___",$trackingnumber),
     ifElse(contains($shippedvia,"UPS"), ...  and so on...

    We then use this TEXT field to populate our URL field.  As  &  mention also:  the text field will be 'live' - before save it will change as I change the tracking number the courier in my example.    The URL field only populates after save.

    Anyway, hopefully an example helps...
    Luke.

Children
No Data