Skip to main content
V
VincentGo
New Participant
October 26, 2018
Question

Column with Calculated Field - Render Field as Clickable HTML Link

  • October 26, 2018
  • 15 replies
  • 3827 views
SITUATION: I have a calculated field that concatenates a field value with a hyperlink, to make a clickable hyperlink directly to a page (I put a Ticket Number into one field, and then the calculated field takes the ticket number and combines it with a URL structure, so I have a direct link to the Ticket). The custom field is a calculated field, format Text. WHAT I WANT: I want the field to render as a clickable HTML hyperlink in the report, instead of a text string. The default URL field renders this way in reports. On the object pages, it renders with a hyperlink. But not in reports. -- Here's the text mode of my columns valuefield=Ticket Link querysort=DE:Ticket Link valueformat=customDataLabelsAsString displayname= linkedname=direct namekey=Ticket Link The URL field renders as valuefield=url querysort=url valueformat=HTML displayname= linkedname=direct namekey=url -- I tried changing the value format from "customDataLabelsAsString" to "HTML" but that caused the field to be blank in my report. Do you have any suggestions? Thank you so much! Vincent Goodwin The Capital Group Companies
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    15 replies

    Show previous replies
    N
    NRYNR
    New Participant
    January 16, 2020
    Hi Christina, please try the following: displayname=Project URL shortview=true textmode=true valueexpression=CONCAT("https://ascensus.my.workfront.com/project/view?ID=",{project}.{ ID }) valueformat=HTML width=15
    Christina_Jarosz
    Christina_Jarosz
    New Participant
    January 16, 2020
    Hey @Narayan Raum - I'm trying to link to the project reference ID on a task report. It doesn't seem to take no matter what I update to (swapping out name with project ID. What am I missing? displayname=Project URL shortview=true textmode=true valueexpression=CONCAT("https://ascensus.my.workfront.com/project/view?ID=",{project}.{referenceNumber}) valueformat=HTML width=15
    N
    NRYNR
    New Participant
    October 26, 2018
    You're welcome. It was a copy and paste from my library, so no real effort involved!
    V
    VincentGoAuthor
    New Participant
    October 26, 2018
    Thank you so much! That answered my question & fixed my problem. And thank you for going the extra mile to make different versions based on the type of report. I realize I didn't specify that in my original post. Vincent Goodwin The Capital Group Companies
    N
    NRYNR
    New Participant
    October 26, 2018
    Here's what I have on creating links in reports... I suspect one of these will give you what you're after depending on the type of report. Friendly URL (Using Native URL Field) displayname=Link link.url=url linkedname=html(URL) textmode=true valueexpression={name} valueformat=HTML Friendly URL (Using URL Field on ISSUE Report) valueexpression=IF(ISBLANK({url}),"","View") linkedname=html(URL) valueformat=HTML displayname=Issue/Project link.url=url textmode=true Friendly URL (Using URL Field on PROJECT Report) valueexpression=IF(ISBLANK({URL}),"","View") linkedname=html(URL) valueformat=HTML displayname=Shortcut link.url=URL textmode=true Friendly URL (Using Custom Field with "Click Here" on Issue Report) displayname=Shortcut textmode=true valueformat=HTML value=Click Here link.url=customDataLabelsAsString(Custom Field Name) Friendly URL (Using Custom Field as Name on issue report) displayname=Shortcut link.url=customDataLabelsAsString(Document Path) textmode=true valueexpression=IF(ISBLANK({DE:Document Path}),"",{DE:Document Path}) valueformat=HTML Edit Custom Form Link in Report displayname=Click to Edit linkedname=direct namekey=category.name tile.name=component.objectcategories valuefield=objectcategoriesNamesString valueformat=HTML viewalias=category.name
    ------Original Message------ SITUATION: I have a calculated field that concatenates a field value with a hyperlink, to make a clickable hyperlink directly to a page (I put a Ticket Number into one field, and then the calculated field takes the ticket number and combines it with a URL structure, so I have a direct link to the Ticket). The custom field is a calculated field, format Text. WHAT I WANT: I want the field to render as a clickable HTML hyperlink in the report, instead of a text string.  The default URL field renders this way in reports. On the object pages, it renders with a hyperlink.  But not in reports. -- Here's the text mode of my columns valuefield=Ticket Link querysort=DE:Ticket Link valueformat=customDataLabelsAsString displayname= linkedname=direct namekey=Ticket Link The URL field renders as valuefield=url querysort=url valueformat=HTML displayname= linkedname=direct namekey=url -- I tried changing the value format from "customDataLabelsAsString" to "HTML" but that caused the field to be blank in my report. Do you have any suggestions?  Thank you so much! Vincent Goodwin The Capital Group Companies
      S
      SarahWilkersonCA
      New Participant
      July 31, 2020

      Thank you Narayan...black belt Workfront reporting wizard! You have once again saved me from the spinning wheel of death that is textmode. 😎

      N
      NRYNR
      New Participant
      August 3, 2020

      Wow @Sarah Wilkerson‚ , the fact that you were able to locate and decipher this to the point of being useful is impressive. In case you haven't seen it, here's some documentation on creating URLs you might find useful.

      Thanks,

      Narayan

        Terms & ConditionsAccessibility statement

        Loading footer...