1 Reply Latest reply on Jun 28, 2013 9:24 AM by philmodjunk

    Unsure how to add an auto-email function



      Unsure how to add an auto-email function


           I have a database set-up to collect information on patients during surgery for research information... When a specific surgeon is required to input data, which becomes clear because there is a drop-down list choice of the surgeon names, but does not input the data about the surgery into the database within a certain amount of time of the surgery (say within a day) I would like the database to automatically email the surgeon to remind them to do so... I'm pretty new to FileMaker Pro and am not sure the easiest way to go about this..


        • 1. Re: Unsure how to add an auto-email function

               You'll need to set up some sort of system that periodically checks for such cases of incomplete data entry. If your database is hosted from FileMaker Server, a schedule can be set up to run such a script at regular intervals such as once every evening. The script can perform a find for the records and if any are found, loop through them sending out reminder emails to each surgeon.

               If you are not hosting from FileMaker Server, a robot file can be set up to perform this script in your main file each time it is opened. Then you set up an OS based scheduler such as Windows Scheduled Tasks to open that file on a regular schedule. In Windows 7, it looks like this may be more complicated--requireing a batch file that is opened by the utility which then in turn opens the database file.