Reporting Question

[rulingclass]

Hi,

I'm a Filemaker newbie and I'm trying to run some reports based on employee timesheet data.

I've attached a sample of my database in the hopes that someone could steer me in the right direction.

It's important that I be able to creat reports based on data for each employee as well as by work activity. I've tried numerous things, including reading other threads on this board, but I can't seem to figure it out. We really want to be able to track employee overtime as technically, employees are only able to accumulate 21 hours in their bank at which point they are supposed to take time off.

Thanks in advance.

Timesheet.zip

Edited June 26, 2008 by Guest

[Lee Smith]

What are the User id and Passwords for your file?

While you are at it,

Describe what you consider OT.

i.e. what is a normal work day, week of (Mon - Fri)

8 hours a day, 5 days

10 hours a day 4 days

40 hours a week

You should be aware if your state has a tiered OT that needs to be factored into this also.

California has some break downs for OT, so be careful of the Time off in lieu of approach.

Lee

Edited June 26, 2008 by Guest

[rulingclass]

You can gain full access to the file using the guest account as it is the only active account in the file.

OT is calculated at a 1 for 1 rate. The normal work week is 35 hours and employees are paid every 2 weeks. Therefore, if I worked 75 hours over a two week span, I would accumulate 5 hours of overtime. Employees are not paid for overtime, but are given time off in lieu at a 1 for 1 rate.

Thanks again.

Edited June 26, 2008 by Guest
spelling mistake

[bruceR]

You can gain full access to the file using the guest account as it is the only active account in the file.

OT is calculated at a 1 for 1 rate. The normal work week is 35 hours and employees are paid every 2 weeks. Therefore, if I worked 75 hours over a two week span, I would accumulate 5 hours of overtime. Employees are not paid for overtime, but are given time off in lieu at a 1 for 1 rate.

Thanks again.

You need to do a complete redesign using a related table. You've got discrete fields for everything ActHours1, ActHours2, etc.

It is very unfortunate that FileMaker provides an example file that gets users off on the wrong foot by not doing things right.

[rulingclass]

Well, that wasn't the news I wanted to hear :.

Anyway, I half-expected it. Could you give me a little push in the right direction as to how I could start? It's fairly pressing to get this done and I don't want to start on the wrong foot.

Thanks for any help you can give.

[bruceR]

Well, that wasn't the news I wanted to hear :.

Anyway, I half-expected it. Could you give me a little push in the right direction as to how I could start? It's fairly pressing to get this done and I don't want to start on the wrong foot.

Thanks for any help you can give.

Sorry I don't have much time to help right now. You'll need to read up on portals and relationships. There should be plenty of people who can help you with this; and also some existing example files.

But see attached for some ideas.

timecards.zip

Edited June 27, 2008 by Guest

[Lee Smith]

It is hard to point you in a specific direction, because we don't know what skills are now. If you are a raw beginner, and you have some time to learn FileMaker, then there are a lots of books, videos, DVDs, and training classes available, many of which have been recommend in FM Forum's Resource Topic Area.

In addition, many of the sponsors of this site also offer training aids, sample files, white papers, etc. available, some of them are FREE.

Don't forget FileMaker Inc., they also have links to training aids, and third party products, and training aids.

Lastly, in spite of what you might have heard about Filemaker being Easy to Learn, and Use, it does have a Learning Curve, which can demand a lot of time and effort to learn. As for the Ease of Use comes down to the skills of the craftsman who puts the solution together.

If you don't have the time to learn FileMaker, then consider hiring someone with the skills to help you build it, or build it for you.

HTH

Lee

Edited June 27, 2008 by Guest

[rulingclass]

Thanks for the input everyone.

I'm still going to attempt this myself as I've picked up a Filemaker textbook to help me along.

Just one question, though...

Should I use repeating values for each day/activity entry?

Thanks.

Edited June 30, 2008 by Guest

[Lee Smith]

no.