Creating Custom Hypertext | Community
Skip to main content
MATTHEW450
MATTHEW450
Level 2
November 18, 2022
Solved

Creating Custom Hypertext

  • November 18, 2022
  • 2 replies
  • 979 views

I'm trying to find a way to create custom hypertext to clean up my reports. We use text fields for people to dump their links, then we pull these fields into a report. I'm trying to find a way to turn these long links into something short like "click here". I've found I can use "value=<a href="https://google.com" target=_blank>Click Here</a>" to create a functional link, but I don't know how to insert the custom text. If this is not a feature, I think finding a way to create a custom link with conditional formatting or a new field type would be useful

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Rafal_Bainie

In one of the reports I use following column to convert URL field to a custom "click here":

displayname=More Info
link.url=URL
linkedname=html(URL)
textmode=true
usewidths=true
valueexpression=IF(ISBLANK({URL}),"","Click here")
valueformat=HTML

2 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity AdvisorAccepted solution
Community Advisor
November 21, 2022

In one of the reports I use following column to convert URL field to a custom "click here":

displayname=More Info
link.url=URL
linkedname=html(URL)
textmode=true
usewidths=true
valueexpression=IF(ISBLANK({URL}),"","Click here")
valueformat=HTML
    MATTHEW450
    MATTHEW450Author
    Level 2
    November 29, 2022

    I got it to work! Thank you so much for the suggestion. I used your structure, and substituted the "URL" in the "link.url=URL" with

    link.url=customDataLabelsAsString(Custom Field Name)

     and the "URL" in the if is blank statement with my custom field to make it work. I did not need a "DE:" in the "link.url"

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    November 21, 2022

    Here are some alternate methods as well:

    Friendly URL (Using Native URL Field)

     

    displayname=URL
textmode=true
valueformat=HTML
value=Click Here
link.url=html(URL)

     

     

    Friendly URL (Using Custom Field)

    displayname=URL
textmode=true
valueformat=HTML
value=Click Here
link.url=customDataLabelsAsString(Custom Field Name)
      Terms & ConditionsAccessibility statement

      Loading footer...