In a report is it possible to label the text of the URL field as specific text instead of displaying the lengthy URL text? | Community
Skip to main content
T
TrishaGr
Level 2
November 17, 2020
Solved

In a report is it possible to label the text of the URL field as specific text instead of displaying the lengthy URL text?

  • November 17, 2020
  • 2 replies
  • 1858 views

I build a report and dashboard that displays the project URL field in the view and I want to show the data in the URL field as specific text instead of the URL text. Our company add the link to the Product brief for the specific project in the Project 'URL' field but when we pull this field into dashboard it takes up quite a bit of space because of the length of the URL. I would like to relabel the hyperlink URL to state 'Product Brief Link' so it minimizes the height of each row on the dashboard. Is this possible?

    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 Richard_Le_

    Hi Trisha,

    Sure, this is possible! The below text mode should do it.

    displayname=Product Brief

    link.url=String(URL)

    textmode=true

    valueexpression=IF(ISBLANK({URL}),"","Product Brief Link")

    valueformat=HTML

    Best Regards,

    Rich

    2 replies

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    November 17, 2020

    Hi Trisha,

    Sure, this is possible! The below text mode should do it.

    displayname=Product Brief

    link.url=String(URL)

    textmode=true

    valueexpression=IF(ISBLANK({URL}),"","Product Brief Link")

    valueformat=HTML

    Best Regards,

    Rich

      S
      SimonNa
      Level 2
      November 18, 2020

      Hi @Richard Leek‚,

      Thank you for your response, that is very helpful. Do you know if something similar would be possible for a calculated custom field on a form?

      We use the below calculated field on our users home page to take them to the subtask page of their task's deliverable (the parent.parent task). Currently, the full link displays on the Home pages, but if there would be a way to set a standard string to display instead that would be preferred.

      IF(ISBLANK(Parent.Parent.ID),"",CONCAT("https://osu.my.workfront.com/task/",Parent.Parent.ID,"/tasks")) [NOTE: this only works in the new WFE]

      Best,

      Simon Nabors

      R
      Community Advisor
      Richard_Le_Community Advisor
      Community Advisor
      November 18, 2020

      Hi Simon,

      This is also possible when referencing a URL from a custom field. You would create a new column in your report and use the following text mode code for that column.

      valueexpression=IF(ISBLANK({DE:Custom Field Name That Hosts URL}),"","Your Hyperlink Text")

      link.url=customDataLabelsAsString(Custom Field Name That Hosts URL)

      textmode=true

      valueformat=HTML

      displayname=Column Name

      Best Regards,

      Rich.

        E
        ErinEk
        April 10, 2021

        Does this solution still work in the new WF experience? I'm struggling to get my text to be clickable. Thanks!

        T
        TrishaGrAuthor
        Level 2
        April 26, 2021

        Yes it does. I actually decided to make my a circle icon instead of naming the url as text so not sure if the text works but I do know you can click Advanced settings for the column and add criteria for it to show an icon that is clickable.

        Terms & ConditionsAccessibility statement

        Loading footer...