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
  • 2228 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
    PollyCo
    Level 9
    May 18, 2017
    Hi Adina, I'm testing the method you've provided and it does work on a custom field on a project form but I'm testing the same method against a regular note field eg threadID and it won't make it a clickable link. I'm just wondering why the method couldn't work on a regular field. Similar to Matt May's post, I have a long link that I want to shorten and because it cannot be a custom field (it's actually a url construct using the notes threadID), I'm trying to understand how the other link codes work. What values are allowed in customDataLabelsAsString( Alfresco Edit URL ), is it always a field, can this be an expression or the value itself eg www.google.com?
    JoeSalas
    JoeSalasAuthor
    Level 3
    May 17, 2017
    Hi Adina, Thank you so much for sharing your code, my report now looks beautiful! I was able to modify your code and test my report. The column value went from a 100+ character count to an eleven character hyperlink! The report no longer runs off the template and is easy to view. Thanks again! Best regards, - Joe
    AdinaPi1
    Level 9
    May 16, 2017
    Hi Joe! I have code from one of my columns but it's pretty messy, but works! In this example, my custom field is called DE: Alfresco Edit URL. The line that has what I wanted to replace the text with is: case.0.comparison.truetext=Doc Central Link Basically, to get the code for the replacement text, I went to Advanced Options -> Add Column Rule. For my filter I used Project > Alfresco Edit URL -> Is not Blank. In the Show the field like this options, I checked the Show Text box and put what I wanted in there. I then saved, then went into text mode and added the other code included below. case.0.comparison.icon=false case.0.comparison.leftmethod=DE:Alfresco Edit URL case.0.comparison.lefttext=DE:Alfresco Edit URL case.0.comparison.operator=notblank case.0.comparison.operatortype=string case.0.comparison.righttext= case.0.comparison.truetext=Link description=Doc Central link.isnewwindow=true link.url=customDataLabelsAsString(Alfresco Edit URL) linkedname=direct listsort=customDataLabelsAsString(Alfresco Edit URL) name=Doc Central querysort=URL shortview=false stretch=70 styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:Alfresco Edit URL styledef.case.0.comparison.lefttext=DE:Alfresco Edit URL styledef.case.0.comparison.operator=notblank styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext= styledef.case.0.comparison.truetext=Doc Central Link textmode=true valuefield=Alfresco Edit URL valueformat=customDataLabelsAsString
      Terms & ConditionsAccessibility statement

      Loading footer...