2 Replies Latest reply on Feb 17, 2017 8:44 AM by philmodjunk

    Scripts

    garry107

      I wrote the script according to this

       

      Go to Layout ["Customers"]
      Perform Find [Restore]
      Send Mail [Send via E-mail Client; No dialog; To: Customers::Email; Subject: Invoices::Summary; Message: "Dear Customer,¶¶Thank you for your business."]

       

      My question is how do perform the script everyday?

        • 1. Re: Scripts

          You need to add this script to a schedule on the server.  Assuming you host your file from FileMaker Server (if not you can not schedule the script), Click the "Schedules" tab and the calendar symbol Screen Shot 2017-02-17 at 11.28.06 AM.png on the right of the screen.  There is the option to create a schedule.  Just follow the step and you will get your schedule.

          • 2. Re: Scripts
            philmodjunk

            This script cannot be run from a server schedule unless you change the script to use SMTP. "Email Client" option is not server compatible.

             

            You could, however, set this to run via a script that runs when the file is opened on a client machine. Assuming multiple users opening your file, the script can log each time that it sends out the email and can check the the log to keep from sending more than once per day.

             

            A robot file run from an OS based "task scheduler" could also do this as a client of the database.