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

Discussion created by dburnham on Nov 17, 2012
Latest reply on Dec 27, 2013 by Tom_Droz

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.