1 Reply Latest reply on Aug 9, 2011 8:50 AM by philmodjunk

    Create timer job

    caltonjarvis

      Title

      Create timer job

      Post

      I have a list.  I would like to send out email when today's date equals to the EmailDate column in the list.

      How to schedule the task to check time on a daily basis.  Thanks.

        • 1. Re: Create timer job
          philmodjunk

          If you have FileMaker Server, you can use its script scheduler to run a script each day that performs a find for such records and emails out any found.

          If you leave your database open 24/7, an Install OnTimer Script step can perform that script once every 24 hours. (Convert 24 hours into seconds).

          If your use of your database differs from those two options, you won't be able to perfectly do this. You can set up a script in File Options that runs every time you open the file. This script can check values in a "log" file so that this only happens the first time the file is opened on a given data to prevent multiple emailings.