1 Reply Latest reply on Nov 4, 2009 12:51 PM by philmodjunk

    Automatically Run Reports



      Automatically Run Reports


      I have a couple reports in FileMaker that I would like to automatically ran each Monday and have either a PDF or Excel file written out to the file system. Is there a way to do this through the program or the command line which I could then use windows scheduler to run a batch file. Thanks.

        • 1. Re: Automatically Run Reports

          I'm assuming FMS 10 here...


          If your script is server compatible, you can simply set server's scheduler to run the script.


          If it's not, you can set up a robot file to log in as a client and run it for you.


          To check server side compatibility, open the script and select "Server" from the show compatibility drop down. Be aware that some script steps such as Import Records will show as "compatible" but are severely limited in what they can actually do when run from a server schedule.


          To set up a filemaker Robot file, create a new empty database file.

          Give it a script:

          Perform Script [//select the report script you want to run in the hosted file]

          Exit Application


          Now specify scheduler to open the robot file at a specified time.