Title
need help with Automated action script
Post
hello everyone.
I have a small care home and for that i have made a database of staff and residents.
In the employees table I have a list of employees with different qualifications and based on their performance they each have a performance score of 5 to 25.
I am trying to set up and automated Roster so that 4 employees be assigned to a shift, 2 with a performance score of 10 or above and 2 with PS of less than 10. There are 3 different type of shifts in a day Morning(M) Afternoon (A) and Night (N)
I have assigned a script to each day of the rote field so taht on entre script searches for the staff who have score of more than 10 and then set field to assign a shift to that employee. but so far it is not working properly as I wanted it to, can somone please direct me to a proper way of doing this as my little knowledge of FMP 10 is obviously not enough to make the script work.
Thank you all for your help on this matter.
Talimar:
Thank you for your post.
After reading your post, there are still a lot of unknown factors. For instance, it is easy to search for employees with a performance score of 10 or above, as well as searching for employees with a performance of less than 10. However, how do you know which shift to assign an employee. For example, if I assigned an employee to a Night shift one day, and the next day to the Morning shift, that might be 16 straight hours of working, and I assume you don't want this to occur. What other criteria is used to put employees into a shift?
TSGal
FileMaker, Inc.