Tomo1 Posted January 22, 2002 Share Posted January 22, 2002 I have been asked to create a Holiday Board in Fm for the company work for. Although this is possible I am having a little trouble. There are around 90 people, and traps need to be added so people doing the same job don't clash ei; a message will appear letting you know if 2 or more people who do the same job are off. Does anyone know where I could go for some inspiration?? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted January 23, 2002 Share Posted January 23, 2002 I might suggest starting with a look at some existing group scheduling software and see how it is handled. You may not be able to look behind the scenes, but it might inspire you as to the basic methodology. Link to comment Share on other sites More sharing options...
Tomo1 Posted January 23, 2002 Author Share Posted January 23, 2002 I have tried the above to no avail!! Is there a function to check the contents of a field? If I have 4 names in the monday field eg John, Danny, James, Julie. I want to run a script and show an error message, something like, "Julie & James cannot have the same days off!". If you use the mail programe 'Entourage', my DB is set out like the month view. Link to comment Share on other sites More sharing options...
Kurt Knippel Posted January 24, 2002 Share Posted January 24, 2002 quote: Originally posted by Noddy: Is there a function to check the contents of a field? If I have 4 names in the monday field eg John, Danny, James, Julie. I want to run a script and show an error message, something like, "Julie & James cannot have the same days off!". code: If ( PatternCount ( MondayField, "James" ) and PatternCount ( MondayField, "Julie" ), "Julie & James cannot have the same days off!", "" ) The above is the simplest, but not most flexible, way of accomplishing your example. However you need to think about how the database will know what combinations to look for. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8288 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now