How to using another abbreviation/String to represent the URL link in a Workfront report?

[JerryWu]

Hello Friends,

There is a URL link in my Wrokfront report, but due to the link is quite long (annoying), would like use another string/abbreviation to replace this URL link. But when i output the workfront report to Excel format, i wanted the URL link is there for my insert photo purpose. thanks!

[NicholeVargas]

[EDITED] You can add a column rule to say something like "Click here" so that the URL doesn't display, but in doing so, the link will not be clickable if you export to Excel. See reply below for instructions

[DominicTh]

Nichole,

I have attempted to follow your instructions listed above. Unfortunately, I have not been able to successfully change the URL text to "Click Here" and maintain the ability to actually use the link to redirect to another Webpage.

Here is my Textmode Code, did I miss a value that would help complete the link? 

case.0.comparison.icon=false
case.0.comparison.leftmethod=URL
case.0.comparison.lefttext=URL
case.0.comparison.operator=notblank
case.0.comparison.operatortype=string
case.0.comparison.righttext=
case.0.comparison.truetext=Click Here
linkedname=direct
namekey=URL
querysort=URL
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=URL
styledef.case.0.comparison.lefttext=URL
styledef.case.0.comparison.operator=notblank
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.righttext=
styledef.case.0.comparison.trueproperty.0.name=textcolor
styledef.case.0.comparison.trueproperty.0.value=1b878c
styledef.case.0.comparison.truetext=Click Here
textmode=true
valuefield=URL
valueformat=HTML
link.url=URL

[NicholeVargas]

@DominicTh Apologies for the confusion! I'm going to go ahead and delete my reply above since the link.url text mode works for custom fields, but I didn't realize that there was a different text mode for native fields. 

For native Workfront fields (ex: URL), you can use the following: 

displayname=URL
link.url=URL
textmode=true
valueexpression=IF(ISBLANK({URL}),"","Click Here")
valueformat=HTML

If you want to hyperlink a custom field, you would follow the instructions from above (re-pasted here):  

• Edit your report and click on the appropriate custom field column
• Select Advanced Options > + Add Column Rule
• Custom Field > Is Not Blank 
• Click on the Checkbox for "Show Text" and add the words, Click here
• Option to change the text color to blue
• Click Add Rule
• Switch to text mode and add the following line to the bottom. Keep in mind you would need to replace fieldname with the actual name of your custom field.

link.url=customDataLabelsAsString(fieldname)

• Save and run your report

[KariB93WI]

@NicholeVargas , the hyperlink from a custom field isn't working for me. I can see the words "click here", but they aren't linked.

I think I'm close. Do I have the wrong syntax for my field name "(DE:Notes URL Single Line)"? 

case.0.comparison.icon=false
case.0.comparison.leftmethod=DE:Notes URL Single Line
case.0.comparison.lefttext=DE:Notes URL Single Line
case.0.comparison.operator=notblank
case.0.comparison.operatortype=string
case.0.comparison.righttext=
case.0.comparison.truetext=Click Here
link.url=customDataLabelsAsString(DE:Notes URL Single Line)
linkedname=direct
namekey=Notes URL Single Line
querysort=DE:Notes URL Single Line
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=DE:Notes URL Single Line
styledef.case.0.comparison.lefttext=DE:Notes URL Single Line
styledef.case.0.comparison.operator=notblank
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.righttext=
styledef.case.0.comparison.trueproperty.0.name=textcolor
styledef.case.0.comparison.trueproperty.0.value=0c6aca
styledef.case.0.comparison.truetext=Click Here
textmode=true
valuefield=Notes URL Single Line
valueformat=customDataLabelsAsString

[brittanylang]

Hi there! 

I had this same problem. I changed that "link.url=customDataLabelsAsString(DE:Notes URL Single Line)" to just "link.url=DE:Notes URL Single Line" and that seemed to fix it for me. I hope it works the same for you. 

Thank you all for this helpful thread!  

Brittany

[NicholeVargas]

You can either do what @brittanylang mentioned below, or remove the DE: from your link.url field, so instead it would look like this

link.url=customDataLabelsAsString(Notes URL Single Line)