5 Replies Latest reply on Dec 27, 2013 9:48 AM by Tom_Droz

    Layout trigger to send SMTP email when PHP creates a record ??

    dburnham

      I have a layout that is only used by a PHP web page that posts new records in the database. What I want to accomplish is have a triggered script send an SMTP email to inform somebody of the arrival of a new record in the database.

       

      Using a privilege set name, I am able to differentiate the users, so that emails are not inadvertently sent by people who access the layout in FileMaker Pro and have occasion to edit and/or commit a record.

       

      OnRecordCommit doesn't seem to trigger the script. Neither does OnRecordLoad.

       

      I'm looking for a way to trigger the script when a new record is created. Apparently, PHP creates the record without causing the commit step to occur.

       

       

      Any ideas will be appreciated.