Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.

0 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

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.