Skip to main content
New Participant
February 18, 2020
Question

Concat problems

  • February 18, 2020
  • 4 replies
  • 859 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

New Participant
March 17, 2020
Thanks Anthony...I was so close! (missing a couple of brackets) Harry Thompson Lowe's - Marketing
Kundanism
New Participant
February 19, 2020
A great input Anthony. Thanks for sharing. Regards Kundan. Kundan Kumar KGON - (Kverneland Group Operations Norway AS)
KevinHa1Author
New Participant
February 18, 2020
That's the ticket. Thank you so much! Kevin Habuda
imgrund
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