Automated service timer
I'm new to Filemaker pro 12, having spend about 3 weeks building a database to keep track of customer records. One very important feature I have been struggling with is an automated way to alert us in the office when a customer's service is up for their boat. The way we want this to happen is to put a date in a field, and then after the specified amount of time (4 months, 1 year, 2 years), a check-box would automatically check itself, and we could sort records based on this to view who needs service. I have tried various scripts, such as I have built a script to check whether the fields date is a certain amount of time away from the current date, and this date check seems to work, but I am having trouble getting the script to run for all of our 1000+ records and update them all. I feel like there has got to be a simple way to do this, but am unsure.