I need to extract data into a report and email it at a fixed time each week. Is it possible to create an automated script in Filemaker?
Definitely yes, if it is on a server.
If not you will need to use a technology outside FileMaker to get it to run the sctipt at a preset time - having first made sure the machine is on, the file is available etc etc
So I create a script in the database and execute it via the scheduler in Server?
Retrieving data ...