Jump to content
Sign in to follow this  

Summary of Related Field?

Recommended Posts

I've been looking at this for some time and can't really see an elegant way to do what I need.

I'm essentially dealing with 2 tables, Personnel and Timesheet. What I need is to run a payroll report that will show me how many hours each person in the Personnel table has entered in their records in the Timesheet table (with sub-summary by date).

I have previously done this by looking up all Timesheet records in a date range (date range submitted via script to a global field) and then created a layout that summarizes by person and date. The problem I'm trying to work around is if a person has not entered their time in the Timesheet table - they don't appear on the report at all, because they have 0 records that fit my find criteria.

What I'm thinking is to create a layout based on the Personnel table rather than the Timesheet table, thus listing every employee, but I'm having a very hard time wrapping my brain around how to display their total hours per day... it feels like a summary field and some type of self-relationship may be in order, but my brain is mush, and I can't work it out.

I may be totally on the wrong track too.

Can anyone offer advice?


Share this post

Link to post
Share on other sites

Script the process to add a blank time sheet for every employee that doesn't have one, then generate the report.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.