Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Looking for Help to Create Clickable Hyperlink with Report Text Mode

Avatar

Level 2

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.0694X00000J1Kp1QAF.jpg

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

6 Replies

Avatar

Level 3

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

Avatar

Level 2

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

Avatar

Level 2

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

 

Avatar

Level 2

Anyone have any other ideas on how to accomplish this?

Avatar

Level 2

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.

Avatar

Level 2

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