Topics help categorize Community content and increase your ability to discover relevant content.
Thank you Narayan...black belt Workfront reporting wizard! You have once again saved me from the spinning wheel of death that is textmode. 😎
Views
Replies
Total Likes
Wow @Sarah Wilkerson‚ , the fact that you were able to locate and decipher this to the point of being useful is impressive. In case you haven't seen it, here's some documentation on creating URLs you might find useful.
Thanks,
Narayan
You're a genius! Wherever you are, thank you for this! 👏
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Christina,
Is this what you were looking to achieve?
displayname=
link.linkproperty.0.name=projectID
link.linkproperty.0.valuefield=projectID
link.linkproperty.0.valueformat=int
link.lookup=link.view
link.valuefield=project:objCode
link.valueformat=val
linkedname=direct
namekey=project.referenceNumber
namekeyargkey.0=project
namekeyargkey.1=referenceNumber
querysort=project:referenceNumber
textmode=true
valuefield=project:referenceNumber
valueformat=HTML
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Hello Everyone,
I would like to implement one of the following External URL Hyperlink solutions for Package Shipment Tracking Numbers - including multiple Split Shipment Tracking Numbers in the same Field:
+An Issue Report Text Mode Code that converts one or more URLs placed in a Custom Paragraph Text Field into one or more corresponding Hyperlinks (preferably shorter).
+A Calculated Custom Field that takes one or more URLs in a Custom Paragraph Text Field and converts into one or more corresponding Hyperlinks (preferably shorter).
The Issue Report’s current working Non-Hyperlink Text Mode Code is:
displayname=
linkedname=direct
namekey=Tracking Number
querysort=DE:Tracking Number
textmode=true
valuefield=Tracking Number
valueformat=customDataLabelsAsString
On WFPro, there are the following two chunks of Text Mode Code:
---1---
Issue Report – Custom Text
valueexpression=IF(ISBLANK({url}),"","View")
linkedname=html(URL)
valueformat=HTML
displayname=URL (Custom Text)
link.url=url
textmode=true
---2---
Issue Report – Custom Field – Custom Text
valueexpression=IF(ISBLANK({DE:IA Template URL}),"","Click Here")
link.url=customDataLabelsAsString(IA Template URL)
textmode=true
valueformat=HTML
displayname=URL in Custom Field (Custom Text)
The WFPro Description for the above 2 options states:
“Present links in URL or custom fields in a user-friendly manner.”
I tried Option 1 in the Custom Field by itself and the Field would not show anything, even though there were URLs displayed previously. Do you know how I might revise my current working Issue Report Text Mode Code, so that it might work? Also, do you know what the Code would be to work this out using a Calculated Custom Field? Thanks so much for your time and any help you may give.
Seth
Views
Replies
Total Likes
Hi Seth, if you're up for a crash course in clickable hyperlinks from custom forms, let's get a quick call and screen share going. I've got a ton of functional examples to rely on for a WFPro text mode crash course. Bring a friend if you want. https://wf-pro.com/contact
Views
Replies
Total Likes
Narayan showed me the answer and was super helpful! Here is the solution for converting a single URL into a clickable Hyperlink:
https://wf-pro.com/textmode/text-mode-views/#display-field-as-text
Issue Report – Custom Field – Custom Text
valueexpression=IF(ISBLANK({DE:IA Template URL}),"","Click Here")
link.url=customDataLabelsAsString(IA Template URL)
textmode=true
valueformat=HTML
displayname=URL in Custom Field (Custom Text)
STEPS:
+Create a Custom Field in an Issue Report.
+Copy and paste the above Text Mode Code into the Custom Field.
+Replace every instance of “IA Template URL” with the Name of the Custom Field containing the URL.
+Also, “Click Here” can be changed to whatever the Text needs to Display or a Function.
+Lastly, the Text“URL in Custom Field (Custom Text)” can be altered to Display a Custom Column Name.
For example, my Code is below and is referencing my URL Custom Field entitled “Tracking Number”:
valueexpression=IF(ISBLANK({DE:Tracking Number}),"","View Shipment")
link.url=customDataLabelsAsString(Tracking Number)
textmode=true
valueformat=HTML
displayname=Tracking Number Link
Thanks again Narayan!