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

[ty-simpson]

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?

[ty-simpson]

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.

[Richard_Le_ · Accepted solution]

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. 

[Kiersten_K]

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