Thread Details
  • State Suggested Answer
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 367 subscribers
  • Views 3177 views
  • Users 0 members are here
Forum Actions

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

Vince Outlaw

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. 

  • 0

    I believe it is a simple customization.

    Template detail.hbs inside UrlField evaluate the attribute 'isClickable'.

    You may need to create a custom UrlField and override the method format accordingly.

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 Sugar Employee Badge in reply to André Lopes

    Another option would be to create a new TextField type field calculating from your URL type field and then use that field in the Record view instead. 

    The downside is that you will need to re-save the existing records to have the field being calculated. 

  • 0

    Hello,
    +1 to   suggestion regarding additional TextField - that is configurable with no-code and text refreshed on rec saving shouldn't be an issue.

    However, let me ask why is it chosen to use links? The link does not emerge the content for the user until is clicked...
    Also, the physically latest activity in many cases could be non-meaningful from a CRM perspective - e.g. is it correct to treat e.g.internal task regarding the parent record as the last CRM activity.

    Isn't that the recent activities and future activities representation on the pane, one the users may immediately benefit from when observing the record?

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

  • 0

    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.

  • 0 in reply to Francesca Shiekh

    I read this thread and I think the OP is asking for something completely different than what everyone responded. My understanding is that he would rather have the field be hyperlinked text (i.e. the activity's actual name/subject) rather than being a URL. He mentions reporting as his use case, so I thought he wanted the last activity date accompanied with the title of the last activity performed rather than a non-descript URL. If my understanding is accurate, it would definitely take customization to achieve.

    In any event, he hasn't been active in the community in years so we will likely never know Laughing

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year