1 Reply Latest reply on Mar 23, 2011 2:08 PM by philmodjunk

    Is there any way to create an alert when a new record is created?

    northpakco

      Title

      Is there any way to create an alert when a new record is created?

      Post

      I am currently using Filemaker Pro 11 on my Mac OS 10.6.

      We have an inventory listing of the products that we sell.  Is there any way to create a script or an alert to email our sales associates when a new record is added to this particular database?

      Any help would be appreciated!!

        • 1. Re: Is there any way to create an alert when a new record is created?
          philmodjunk

          Add a date field to your inventory table called EmailDate. Use an OnCommit record to perform a script that checks this field. If it is empty, send out the email and log the current date in this field so that it will not be sent again. To keep the email from being sent too soon, place an invisible web browser set to "" as its URL behind all the fields and sized to cover the entire layout. That will keep clicking the layout background from committing the record.