Is It Possible To Pull Project URL in a Report Using Text Mode? | Community
Skip to main content
ty-simpson
ty-simpson
Level 2
February 2, 2023
Solved

Is It Possible To Pull Project URL in a Report Using Text Mode?

  • February 2, 2023
  • 3 replies
  • 1374 views

I use reports I build in Workfront for some more enhanced data visualization that combines data from other systems outside of Workfront with Workfront Projects. 

Our org uses Google Sheets, and I've figured out how to extract the URL from the Project Title field with a simple app script. I then used the HYPERLINK function to create clickable text that's compatible with the data visualization tool I'm using (Looker Studio). However...the app script isn't always on. So when I refresh the data, the link disappears until I go into the spreadsheet itself so that the script will run again and pull the urls. 

I think that this would be easier if I just had the Project URL baked into the report - no hyperlinked Subject just a clean URL, so no need to run any scripts in Sheets. Is it possible to do that using something like Text Mode when creating columns?

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 Richard_Le_

Hi,

 

Yes this is possible. The project URL always follows the same format of https://YOURDOMAIN.my.workfront.com/project/IDOFYOURPROJECT

 

A simple text mode view to append the project ID to the URL would give you what you need. The text mode needed for the ID will vary depending on what type of report you are running, but as an example, the below would work for a project report

displayname=Project URL textmode=true valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/project/",{ID}) valueformat=HTML

 

Your report can then be exported as a tab delimited file direcly from Workfront.

 

Hope this helps!

 

Best Regards,

Rich. 

3 replies

ty-simpson
ty-simpsonAuthor
Level 2
February 2, 2023

I also prefer to extract TSVs over Excel files. TSVs do not retain the hyperlinked title, so having a clean URL would be beneficial to me in that regard as well.

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
February 2, 2023

Hi,

 

Yes this is possible. The project URL always follows the same format of https://YOURDOMAIN.my.workfront.com/project/IDOFYOURPROJECT

 

A simple text mode view to append the project ID to the URL would give you what you need. The text mode needed for the ID will vary depending on what type of report you are running, but as an example, the below would work for a project report

displayname=Project URL textmode=true valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/project/",{ID}) valueformat=HTML

 

Your report can then be exported as a tab delimited file direcly from Workfront.

 

Hope this helps!

 

Best Regards,

Rich. 

    KierstenKollins
    Community Advisor
    KierstenKollinsCommunity Advisor
    Community Advisor
    February 2, 2023

    We used this text mode to return our project URL's in a report:

     

     

    displayname=Project URL
    textmode=true
    valueexpression=CONCAT("https://yourcompanynamehere.my.workfront.com/project/view?ID=",{ID})
    valueformat=HTML

      Terms & ConditionsAccessibility statement

      Loading footer...