Timesheet Manager Streamlines Employee Reporting of Work

Tuesday, April 13, 2010 12:16 by dCheng

We added a new app called Timesheet Manager to the LongJump Catalog both as a “ready-to-go” app that you can install and start using as well as a showcase for some of LongJump’s deeper features that are capable on the platform and very easy to use.

Timesheet Manager is a web-based customizable timesheet/timecard management application. It features ready-to-use timesheets that can be related to employee data as well as other objects such as Accounts or Projects.

The app is constructed around three objects.

  • The Timesheet object, used for recording weekly timecards for each employee
  • The Daily Timecard object, which is the “Detail” object to the Timesheet “Master” object (you can read more about Master-Detail relationships in our wiki)
  • The Employee Rate Table object, which is used for “looking up” an hourly rate to fill in some Timesheet values

Some enhancements to the Timesheet Manager go beyond just objects and fields including:

  • Using a Formula to set the Default Value for Week Start as the nearest Sunday
  • Using a Formula field to automatically determine Week End
  • Using a Formula to set the Weekday based on the Daily Timecard Day
  • Using Rollup Summary Fields to sum up hours recorded by Daily Timecards to the main Timesheet
  • Using a Data Policy to execute Java Code that converts a Rollup Value to a Number Value
  • An approval workflow to ensure management sign-off
  • Reports for current hours/wages anticipated and approved wages
  • Using a Post Selection JavaScript when a user completes an Employee lookup to the Rate Table to automatically retrieve the Hourly Rate

Of course, you can completely modify this app to suit your needs. We’d love to hear your experiences and suggestions on this app as well as any permutations that this app has inspired in your business.

You can Test Drive the Timesheet Manager app here, or install it into your account (Free!).

Technorati Tags: , , , , , , , ,

One Response to “Timesheet Manager Streamlines Employee Reporting of Work”

  1. Mike Donald says:

    April 14th, 2010 at 1:53 pm

    I found the Timesheet Manager pretty useful and I’m looking forward to further development on it. I’d love to see it coded as a Custom Page on LJ.

Leave a Reply