Hyperlink Text for CONCAT URL in Project Report | Community
Skip to main content
Mikaela-Newell
Mikaela-Newell
Level 3
April 27, 2026
Question

Hyperlink Text for CONCAT URL in Project Report

  • April 27, 2026
  • 1 reply
  • 26 views

Hi all! I’ve looked over a variety of threads for this, but come up blank.

In a Project Report, this will successfully pull a link to the Project Details tab of any project listed:

displayname=Project Details

valueexpression=CONCAT("https://experience.adobe.com/#/@COMPANY/so:COMPANY-Production/workfront/project/",{ID},"/overview")

valueformat=HTML

 

The issue is that I cannot seem to shorten this CONCAT link to hyperlinked text in the way I’d be able to with a default URL field or a custom field. Examples of each:

System Field URL:

displayname=URL

link.url=URL

valueexpression=IF(ISBLANK({URL}),"","🔗")

valueformat=HTML

Custom Field URL:

displayname=Dropbox

link.url=customDataLabelsAsString(Dropbox link)

valueexpression=IF(ISBLANK({DE:Dropbox link}),"","🔗")

valueformat=HTML

 

I’ve tried a bunch of combos of all of the code above, but nothing is working. I’m not allowed to create custom fields, so I need a text mode only solution.

 

———

 

Hoping to carry the same solution over to a Document View as well, to create links to the Details, Updates, and Proofing Workflow sections.

1 reply

ninoskuflic
ninoskuflic
Level 4
April 27, 2026

Hi ​@Mikaela-Newell, here is the code that I have used on document reports to show proof URL.

 

valueexpression=IF(ISBLANK({currentVersion}.{proofID}), "Proof Not Created",CONCAT("https://instance.my.workfront.com/document/",{currentVersion}.{ID},"/proof/",{currentVersion}.{proofID},"/view"))
textmode=true
valueformat=HTML
displayname=Proof Link
shortview=true

This is then displayed as a clickable URL.:

 

 

The same code will work for project as well. 😃

If this solved your issue, please mark it as solved so others can find the solution faster.
ninoskuflic
ninoskuflic
Level 4
April 27, 2026

And sorry if I got it wrong - if you want to make the emoji clickable (shorter URL), AFAIK you cannot do that while using link.url as it won't accept a dynamic CONCAT expression (Workfront limitation).

 

However, if you do have a custom field on your project (or calculated field), this will work:

displayname=URL
shortview=true
textmode=true
valueexpression=IF(ISBLANK({DE:Project URL}),"","Click Here")
valueformat=HTML
link.url=customDataLabelsAsString(Project URL)

 

If this solved your issue, please mark it as solved so others can find the solution faster.
Mikaela-Newell
Mikaela-NewellAuthor
Level 3
April 28, 2026

Hi ​@ninoskuflic! Unfortunately, I am trying to shorten the URL, like you mentioned in your second reply. I’m going to leave this thread unresolved a bit longer in case anyone else has a solution, but I think you’re right

Terms & ConditionsAccessibility statement

Loading footer...