Couple of questions how do you determine if an employee is part time. Is this represented anywhere in your database.
There are a number of ways to accomplish what you want. Any more information you could give would be helpful.
Do you want this information on a report (printout) or just in a viewable list.
Hey, Just in a viewable list.
I guess I could either make a third field with the info part-time or full-time.
Maybe I could have a list names that the databased cross referenced to determine if someone was full time or part time. For example, if name = john doe, then check hours. I only expect the list to change by very small amounts over time.
Ok I just made another field called "fulltime". I set this up as a check box field. Therefore, if the box is checked, the script should run and tell me if the employees has less than 40 hours.
How do I build the script?
Seems like you need two or more tables for this: One table that lists each employee, their status as full or part time and any other info you need such as contact info. You'd then use a related table to log each employee's actual work history.
Isn't there just a script that could run?
Could be, but It's not very clear as to how you have structured your table. What you have seems very limited in it's usefulness to you.
What does one record in this table represent exactly?
One week's total work hours for one employee for a given week? or something else?
You can always enter find mode and enter < 40 to find all records where the field has a number smaller than 40. (Field must be defined to be of type number.)
Thank you for PhilModJunk for your input. I will try to provide a little more clarity. When processing payroll, I want to make sure that all full timers get paid for 40 hours. Every week I get a list of employees names and the amount of hours they work. This list comes to me as a filemaker file with two fields: Names and Hours. Currently, I have to look at each person name and think, is this person full time? Then I have to look at the next field and make sure that they have at least 38 hours. If they have less, I call them and ask if they forgot to clock in or something. This process has often lead me to a mistake. Which has led to a person only getting paid for 3 or 4 days when they actually worked 5.
This database, although simple, would allow me to accurately find timecards that need verification. Leading to less mistakes.
So I created a third field called Status. This is a dropped down field with two options: "Full Time" and "Part Time".
I want to be able to write a script that will check each record, detemine if the person was full time, and then check to see if they had less than a certain amount hours. 38 in this case.
I've been learning scripting for the last few weeks but have not got to point where I could write a script for this purpose.
This would really really help me.
There is no need for a script.
Enter Find Mode
Enter or select "Full Time" in the status field.
Enter < 40 in the hours field
Perform the find and you'll have a list of all full time employees that worked less than 40 hours.
You are amazing sir!!! That worked perfectly! Thanks so Much!!!