Im creating a standalone application for managing incoming timesheet data. (also developing a web app for the time sheet submissions)
The database side of things right now is one table. Shown here:
It can show multiple jobs on any given day and the hours/mileage associated with that job.
I would like some guidance on how to deliver this information to users (office staff). Payroll and project managers specifically.
Main consideration right now is:
payroll want a weekly view. They are not concerned with a breakdown of hours. Just how many.
In my mind the best way to do this:
use a combination of filters, one where they can select the week ending (list of dates). Also they can select the employee name. the system then tells them the hours worked that week.
I was thinking of applying the week ending date to every entry using some sugestions from here;
https://forums.windowssecrets.com/sh...ed-with-a-date
But I'm now concerned that with a lot of data this will become slow and I should apply this after the filters have been selected (it will look within a set range then do the calculations.)
Any thoughts on anything ive mentioned are appreciated. I like to ask just as confirmation rather than spending a lot of time on a bad solution.
Thanks, Andy.