Want to pull full Workfront project/request URL into custom form field | Community
Skip to main content
K
KateBehnen
Level 2
January 23, 2023
Solved

Want to pull full Workfront project/request URL into custom form field

  • January 23, 2023
  • 1 reply
  • 1028 views

Hello,

 

We're prepping to migrate to another existing instance of Workfront. We will be moving existing projects and requests over, along with their data. As part of that, I'm trying to find an easy way to be able to reference the original project or request in its original instance. 

 

My goal would be that if we have Project X with URL xyz.workfront.com/projectxID, the field would pull in that exactly: "xyz.workfront.com/projectID" - that way when someone is in the new instance and they go to this field, they'd be able to quickly click "xyz.workfront.com/projectID" and go to the original project in the old instance (old instance will be kept open for archival purposes). 

 

1) does this make sense? and 2) does anyone have any ideas on how we could pull this information? Thank you!

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

Sure. In the calculated field, it would be:

 

CONCAT("[your workfront instance].my.workfront.com/project/",{ID})
 
Replace the [your workfront instance] with whatever your Workfront instance is.

1 reply

ChrisStephens
Community Advisor
ChrisStephensCommunity Advisor
Community Advisor
January 23, 2023

Do you have access to Fusion or some other automated tool? If so, it could do this for you. You could add a custom field to the projects, and then with Fusion or your tool of choice, have it iterate thru your projects and build the string {old workfront instance}.my.workfront.com/projects/{project ID in old workfront instance}, then when you migrate over, just copy that field as part of your overall migration.

 

Another option would be to use a calculated field in the old instance that concatenates together the link (same as above), then when you migrate over populate the calculated value into a text field in the new instance.

 

Alternatively, you could have your migration tool build out the link as well, and populate it in your new project somewhere, and not add anything to your existing project.

K
KateBehnenAuthor
Level 2
January 24, 2023

Thanks, Chris! I appreciate the suggestions. Because I'm not super familiar with the second option, off the top of your head to you know of a resource I could look at to build the CONCAT calculation? I realize that's likely a stretch, so totally fine if not!

ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
January 24, 2023

Sure. In the calculated field, it would be:

 

CONCAT("[your workfront instance].my.workfront.com/project/",{ID})
 
Replace the [your workfront instance] with whatever your Workfront instance is.
Terms & ConditionsAccessibility statement

Loading footer...