Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Text Mode Help: Create Friendly URL using CONCAT(

Avatar

Level 3

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)

 

0 Replies