Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Text Mode Help: Create Friendly URL using CONCAT(

Avatar

Level 4

Hey community - does anyone know of a way to use the CONCAT feature combine elements to form a hyperlink but only show a shortened view in the report? I would like to do this without using a custom field.

 

displayname=User Directory
link.isnewwindow=true
linkedname=direct
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=emailAddr
querysort=owner:emailAddr
textmode=true
usewidths=true
valueexpression=CONCAT("https://userdirectory.company.com/users/",{owner}.{uniqueUser})
valueformat=HTML

 

at the moment it shows:

what I want to show:

  • uniqueuser (but retain the link)

 

1 Reply

Avatar

Level 2

Any chance someone got input on this?