Expand my Community achievements bar.

SOLVED

Hour Report: Help with text mode for custom column to provide link to the referenced timesheet

Avatar

Level 4

Accepted Answer:
displayname=Timesheet Link
textmode=true
valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/timesheet/", {timesheet}.{ID},"/overview")
valueformat=HTML

We have a report built to show any errors that occurred when using Fusion but the hour report doesn't provide a link directly to the timesheet where the referenced hours had an issue. 

Does anyone know if there's text mode possible to provide a link to the timesheet within an Hour report?

If it helps, in a Timesheet report, this is the text mode for the native column that you can use for this link:
link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=ID
link.linkproperty.0.valueformat=val
link.page=/timesheetOpenTime.cmd
link.valuefield=objCode
listsort=atDateAsAtDate(startDate)
namekey=daterange
querysort=startDate
valueexpression=CONCAT(DATENOTIME({startDate}),' - ',DATENOTIME({endDate}))
valueformat=val
width=80

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Level 4

When I open up any timesheet, the URL appears to be in the following format:

https://yourdomain.my.workfront.com/timesheet/GUID/overview

 

tentatively (not having tried this myself), I would probably say that you may end up needing to build this link by referencing the timesheetID from your hour entry and then concatting the rest of the URL around it. An example showing this kind of concat can be found in the following post response:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/is-it-possible-to-pull-project-...

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

When I open up any timesheet, the URL appears to be in the following format:

https://yourdomain.my.workfront.com/timesheet/GUID/overview

 

tentatively (not having tried this myself), I would probably say that you may end up needing to build this link by referencing the timesheetID from your hour entry and then concatting the rest of the URL around it. An example showing this kind of concat can be found in the following post response:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/is-it-possible-to-pull-project-...

Avatar

Level 4

Thanks!

This text mode seems to be doing what I want. 
displayname=Timesheet Link
textmode=true
valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/timesheet/", {timesheet}.{ID},"/overview")
valueformat=HTML