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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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