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!
Solved! Go to Solution.
Views
Replies
Total Likes
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:
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:
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