AnsweredAssumed Answered

Checking Next Day Schedule

Question asked by pademo57 on Mar 31, 2017
Latest reply on Apr 3, 2017 by pademo57

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

Sched. A

Day1 ON

Day2 ON

Day3 ON

Day4 ON

Day5 OFF

etc ..

Sched B

Day1 OFF

Day2 OFF

Day3 OFF

Day4 ON


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.