timesheet

[harrymossman]

We need to create a timesheet. It needs to be like ones used by lawyers etc. who break their time down by case.

We have a table of employee names and a table of cases. What stumps me is how to create a form that an employee could use to fill in their weekly times. And also a form where the supervisor could review weekly and summary totals by employee and by case. (Of course, this could be 2 separate forms.)

The employee form would be something like:

         MON  TUES  WED  THUR  FRI
CASE1    2.5  3.75  4.0
CASE2
ETC.

All of this data would go into one big table. Should I put that table on the form and filter it? Or use an undefined tableframe and then upload to the main table? Or something else?

This must be a common task but Search didn't produce any results for "timesheet."

Harry

 

[sloinc]

Harry-

The way we handle this problem is to create a child table to the parent employee file. Primary index is employee name , date as second field, line # as the third, then add necessary fields (case #, account #( type of work), hours). At this point you have an option of creating a second child table for indirect or non billable hours or using the type of work as a filter (we seperated into two tables). If you don't have one, create a table each for billable and nonbillable account #.

The form parent would have fields for the employee identifier and the date. The child portion would be a table frame. Add a line # sequencer on arrive. In the Case# field add a push button that will bring up a form listing all of the cases and click the one desired and have it fill the desired fields in the table. Do the same thing for the account #.

Next create a report for the daily time sheet.

Now create a form that has a beginning date field and an ending date field. In the ending date field add code in depart to filter the table. THis will allow any period of reporting. A secondary index would be required to obtain hours by case.

The same report can be used for multi dates and cases.

Hope this helps.

SLOINC