How do I make the value within the column an active URL to click on? | Community
Skip to main content
JoeSalas
JoeSalas
Level 3
May 16, 2017
Question

How do I make the value within the column an active URL to click on?

  • May 16, 2017
  • 13 replies
  • 2215 views
Hello Workfront Community! Within a report is a column that features a URL Value. There are two challenges in a report where 1.) a value (URL text string) is very long and 2.) not active to click on like a URL link. For each record/row It would be nice to reduce real estate by making the text read "CLICK HERE", when the user clicks on this link they will be directed to an external page. How do I make the value within the column an active URL to click on? Thanks for your support!
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    13 replies

    Show previous replies
    B
    BenettaPe
    Level 9
    June 23, 2017
    Matt, I have attached everything. Thank you.
    M
    MattMa2
    Level 5
    June 23, 2017
    Benetta, The initial problem I notice is that you need to update the calculated field with your domain. Right now you still have mine: CONCAT("https:// streamco .my.workfront.com","/","project/view?ID=",ID,"&activeTab=form-customdata") Change the bold part to your Workfront domain. After you make the update, be sure to scroll down and check the "Update Previous Calculations" box . . . then click DONE. And then Save & Close on whole form. Finally, just for good measure, I make the project that I'm testing with recalculate its timeline as well. Take these steps first and see if it works then. In Reply to Benetta Perry:
    Matt, I have attached everything. Thank you.
    R
    RichardPe1
    Level 2
    July 11, 2019
    Hi, I'm trying to do the same thing, and have spent a few hours trying to achieve what was provided by Matt and Benetta, but I just can't it to work. I will describe what I'm trying to acheive and what I have got in place. I'm creating an issue report. I have a custom field on the Project called "Termsheet Location". In the "Termsheet Location" field on the project I am storing a URL that is a link to a Sharepoint folder. On the issue report I want to have a column called "Termsheet Link" that will have a shorten link to the URL. The clickable value in the column should be called "Link" The conditional logic part is working, and when a URL is populated in the project custom form field (Termsheet Location) the work "Link" is appearing in the Termsheet Link column on the issue report. The only problem is that the "Link" value on the report is not a hyperlink and i can't click it. I will attach the text mode that I'm using, and I believe this is an exact copy of what Matt shared, so i'm not sure why it isn't working. Can anyone advise where I'm going wrong? It's frustrating that I appear to be very close. Is it possible that I have to reference the URL via a calculated field? Thanks Richard Richard Petley Coretexa
    Terms & ConditionsAccessibility statement

    Loading footer...