Any way to create a Script for "On Record Creation"?
Our webpage asks that visitors submit information which is submitted to a new FileMaker record, then notifies a static e-mail address at our company that such a record has been created, which lets us know to send out an e-mail thanking the user for visiting our website.
What we are looking to do is automate the process, so that the script grabs their e-mail address and sends out an auto-response rather than waiting on a manual response to be generated.
This would seem to be ideally done with script triggers, but there is no script trigger for "on record creation". It would seem like "on object modify" might work as well (for when the visitor clicks submit), but I haven't been able to figure out how to tie the two together.
We are on FM11. Any help would be appreciated. Anybody???
You may want to look at the layout script triggers instead of object triggers.
Not clear as to how your website is connected to Filemaker or if the record is only committed once. If it is committed later you would need an If statement in your script and maybe a field in the for if the email was already sent or not.