Daily Script -- dates "past due"
I'm on FMP11, and our companyt uses Server (though I do not maintain the Server, nor know how to run it).
I'd like to have an automatic script run daily that checks a "due date" field, and emails a report a list of records that are due that day, as well as a list of records that are past due.
I don't know how to set scripts to run daily at a certain time. But here's what I presume:
a) The script is within the database.
b) the "run script" setting is set on the Server, at a certain time.
b) At the designated time, the server opens the database and runs the script. The script runs the report and emails the results.
Please confirm if I'm correct. Thanks!