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.