Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Concat problems

Avatar

Level 1
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
Topics

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

4 Replies

Avatar

Level 10
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

Avatar

Level 1
That's the ticket. Thank you so much! Kevin Habuda

Avatar

Level 10
A great input Anthony. Thanks for sharing. Regards Kundan. Kundan Kumar KGON - (Kverneland Group Operations Norway AS)

Avatar

Level 2
Thanks Anthony...I was so close! (missing a couple of brackets) Harry Thompson Lowe's - Marketing