Looking for Help to Create Clickable Hyperlink with Report Text Mode | Community
Skip to main content
J
JamesMi
April 21, 2022
Question

Looking for Help to Create Clickable Hyperlink with Report Text Mode

  • April 21, 2022
  • 3 replies
  • 2472 views

I have a Documents report that lists all documents from all Projects within a Program.

I want to make the column Project: Converted Request Name a clickable link so user can easily get to the originating Request.

I tried the code from this discussion, but unfortunately, it did not work.

Any help is appreciated.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    J
    J_Hobbs
    April 21, 2022

    Give this a try. I pulled it from the 2021 Reporting Cookbook.

    More Info Column Text Mode:

    The following text mode will take the URL entered on your tasks and embed it into a clickable

    ‚Äòclick here’ within your report.

    displayname=More Info

    link.url=URL

    linkedname=html(URL)

    textmode=true

    usewidths=true

    valueexpression=IF(ISBLANK({URL}),"","Click here")

    valueformat=HTML

    width=50

    J
    JamesMiAuthor
    April 21, 2022

    Unfortunately, that did not work either.

    I linked the wrong discussion in my OP. The original discussion I reviewed was this one.

    This code seems close, but it does not work either.

    displayname=

    linkedname=convertedOpTask

    namekey=view.relatedcolumn

    namekeyargkey.0=convertedOpTask

    namekeyargkey.1=name

    querysort=convertedOpTask:name

    textmode=true

    valuefield=convertedOpTask:name

    valueformat=HTML

      undu82
      undu82
      July 17, 2023

      This one works if you are using the link

      URL=shortview=true displayname=Original Request Link textmode=true valueexpression=CONCAT("https://someURL",{convertedOpTaskOriginator}.{ssoUsername}) valueformat=HTML width=15

       

        J
        JamesMiAuthor
        May 12, 2022

        Anyone have any other ideas on how to accomplish this?

        J
        JamesMiAuthor
        May 12, 2022

        A colleague helped with this code that appears to be pretty close:

        URL=shortview=true

        displayname=Original Request Link

        textmode=true

        valueexpression=CONCAT("https://ZZZ.my.workfront.com/issue/view?ID=",{project}.{convertedOpTask}.{ID})

        valueformat=HTML width=15

        This results in a new tab with the following text:

        The url doesn't pull in the issue ID: https://ZZZ.my.workfront.com/issue/view?ID=

        The Request no longer exists

        You may have mistyped the web address. Double check it and try entering the address again.

        MarieClara
        MarieClara
        October 23, 2024

        Hello Super League!

         

        I found an easy way to call the URL and create hyperlink directly in the report using text mode.

        You can check my solution via this discussion: Building a List with Hyperlinks in the Dashboard - Workfront

         

         

         

        Terms & ConditionsAccessibility statement

        Loading footer...