Concat problems | Community
Skip to main content
February 18, 2020
Question

Concat problems

  • February 18, 2020
  • 4 replies
  • 860 views
Hello All, I'm trying to create a report that includes a column that will return a link to the proof of a document. I've been trying to concatenate something like "https://xdomain.com/proof/",{Document GUID},"/",{Proof ID},"/view", but I can't figure out the formatting for the text editor in the reporting tool. This is my first attempt at something like this, so it's very likely that I'm missing something obvious. These are the two attribute fields that I'm trying to concatenate with the URL strings: linkedname=currentVersion namekey=view.relatedcolumn namekeyargkey.0=currentVersion namekeyargkey.1=proofID querysort=currentVersion:proofID textmode=false valuefield=currentVersion:proofID valueformat=HTML displayname= linkedname=direct namekey=ID querysort=ID valuefield=ID valueformat=HTML Kevin Habuda
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

imgrund
Adobe Employee
Adobe Employee
February 18, 2020
I'm assuming this is a document report you are using. If so I believe you want displayname=Proof Link valueexpression=CONCAT("https://xdomain.com/proof/",{ID},"/",{currentVersion}.{proofID},"/view") valueformat=HTML Anthony Imgrund FCB
KevinHa1Author
February 18, 2020
That's the ticket. Thank you so much! Kevin Habuda
Kundanism
Level 10
February 19, 2020
A great input Anthony. Thanks for sharing. Regards Kundan. Kundan Kumar KGON - (Kverneland Group Operations Norway AS)
Level 2
March 17, 2020
Thanks Anthony...I was so close! (missing a couple of brackets) Harry Thompson Lowe's - Marketing