Adding Planned (Resourced) Hours to the Time Sheet Page

[phil_bool_unifi]

When you're creating a time sheet, you can choose Projects and Project Tasks.  If there is a Resource Assignment aligned to the work you're doing and an allocation has been created for you, then my understanding is that there would be daily allocations for the number of hours you're expected to do, aligned to each of those tasks, in the resource_allocation_daily table. 

I would like to display those daily allocations in the daily boxes in the Time Sheet row (Time Card) as the user fills those in.  

I appreciate not every row will have an aligned resource plan, but my feeling is the page HTML has space to accommodate an additional number in each day's box, so showing the planned effort based on the resource _allocation_daily record associated to the assigned task (if present) might be possible.  

Has anyone tried anything similar and lived to tell the tale?

[kaushal_snow]

@phil_bool_unifi ,

You can display planned (resourced) hours in the daily boxes of the Time Sheet row by retrieving the values from the resource_allocation_daily table (which stores the daily allocation hours tied to a resource assignment) and then customising the Time Card UI in ServiceNow Time Sheet Portal (by adding an additional field/label in each day cell and writing a client-script or UI script to map the task/project row to the corresponding resource assignment and pull the hours from resource_allocation_daily) because this kind of enhancement is not provided oob, you’ll need to build and maintain the UI logic for this display.....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[phil_bool_unifi]

Yes, thanks.  My question is really, has anyone done it, and if so, how'd it go?  Was there much latency when loading the resource assignment after the task was selected?  Were there any issues with access (given that time card users don't necessarily have fulfiller roles, although most would)?  Are there any other curveballs coming my way I haven't thought of yet?