AnsweredAssumed Answered

Automated service timer

Question asked by AndrewGuy on Jul 2, 2013
Latest reply on Jul 8, 2013 by philmodjunk

Title

Automated service timer

Post

     Hi everyone,

     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.

     Thanks! 

Outcomes