Column with Calculated Field - Render Field as Clickable HTML Link | Community
Skip to main content
V
VincentGo
Level 5
October 26, 2018
Question

Column with Calculated Field - Render Field as Clickable HTML Link

  • October 26, 2018
  • 15 replies
  • 3813 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

    N
    NRYNR
    Level 10
    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
      SarahWilkersonCA
      SarahWilkersonCA
      Level 7
      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
      Level 10
      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

        V
        VincentGoAuthor
        Level 5
        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
        Level 10
        October 26, 2018
        You're welcome. It was a copy and paste from my library, so no real effort involved!
        Christina_Jarosz
        Christina_Jarosz
        Level 9
        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
        Level 10
        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
        Level 9
        January 16, 2020
        This is what it's giving me, vs. just displaying the ID #. Hmmm.
        N
        NRYNR
        Level 10
        January 16, 2020
        Hi Christina, I suggest you try this adjusted version with the https:// portion added. This should produce a clickable link in the output. displayname=Project URL shortview=true textmode=true valueexpression=CONCAT("https://"https://ascensus.my.workfront.com/project/view?ID=" title="https://ascensus.my.workfront.com/project/view?ID=">ascensus.my.workfront.com/project/view?ID=",{project}.{ ID }) valueformat=HTML width=15
        Christina_Jarosz
        Christina_Jarosz
        Level 9
        January 17, 2020
        Hmm that didn't do it either. Same thing.
        N
        NRYNR
        Level 10
        January 17, 2020
        I think I might be missing what the desired outcome is. Can you explain what you're trying to accomplish? Thanks, Narayan
        Christina_Jarosz
        Christina_Jarosz
        Level 9
        January 17, 2020
        Right now, the full project name and ID is in the column as a link. I am trying to make that link (to the project) as just the project ID. So on my task report, the column is only taking up 6 digits with vs. the whole long link or project name. This is to eliminate having to click on the task name, then click on the parent project, to get to the back to the list of tasks. (so ideally the only thing to show is 999999 that you can click on. (
        D
        DanPe1
        Level 2
        June 18, 2020

        Christina,

        Is this what you were looking to achieve?

        displayname=

        link.linkproperty.0.name=projectID

        link.linkproperty.0.valuefield=projectID

        link.linkproperty.0.valueformat=int

        link.lookup=link.view

        link.valuefield=project:objCode

        link.valueformat=val

        linkedname=direct

        namekey=project.referenceNumber

        namekeyargkey.0=project

        namekeyargkey.1=referenceNumber

        querysort=project:referenceNumber

        textmode=true

        valuefield=project:referenceNumber

        valueformat=HTML

        Show more replies
        Terms & ConditionsAccessibility statement

        Loading footer...