In the place where I work we have a different schedule depending on the job you are currently working. So
"Schedule A" 4 days on, 4 days off.
Schedule B" 3 days off 5 days on
Currently the person who wrote the program before me set it up like this:
Day_Name, Day_Work are the fields
Each day you have to put in a report in Filemaker and at the end of your "Days ON" you then have to write an End of Cycle report in Filemaker.
What is the best way to get Filemaker to check if after writing a report if the next day is an "OFF" day, and if so, tell the user to write an "End of Cycle" report? I assume this would be in a script.