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!
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
[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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
@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):
link.url=customDataLabelsAsString(fieldname)
Views
Replies
Total Likes
@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
Views
Replies
Total Likes
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
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)
Views
Replies
Total Likes
Views
Likes
Replies