Hour Report: Help with text mode for custom column to provide link to the referenced timesheet | Community
Skip to main content
AndrewGr1
AndrewGr1
Level 3
November 10, 2023
Solved

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

  • November 10, 2023
  • 1 reply
  • 878 views

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!

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 skyehansen

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-url-in-a-report-using-text-mode/m-p/571401#M51587

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
November 13, 2023

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-url-in-a-report-using-text-mode/m-p/571401#M51587

    AndrewGr1
    AndrewGr1Author
    Level 3
    November 13, 2023

    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

    Terms & ConditionsAccessibility statement

    Loading footer...