Text Mode Help: Create Friendly URL using CONCAT( | Community
Skip to main content
Level 5
December 7, 2022
Question

Text Mode Help: Create Friendly URL using CONCAT(

  • December 7, 2022
  • 1 reply
  • 917 views

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)

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 2
January 18, 2024

Any chance someone got input on this?