I was just wondering is it possible to schedule a script to run once daily. I have enabled users to save order for later. They have to input the date when to save order by . I want to have a script which would run daily to go through all the saved for later items and send email to user 3 days before their save by date.
I believe for this I have to schedule script on FileMaker server to run once daily and loop through the orders to check how many days left to be remained as saved. If days = 3 than send email.
Has anyone done something similar before. What would be best way to carry out something like this.
Do you have FileMaker Server? That is the best way to do this automatically.
Create a script that finds all orders with 3 days to go and then sends the email via an SMTP server. Create a "schedule" in the FileMaker server admin web page to run that script once a day at the time you desire.