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.