Submit email notification?

[MarkATS]

Is it possible to have an email sent when a record is submitted on the web? The email would be sent from the host computer running the FM database.

[sherifmayika]

yes

[MarkATS]

Ok, that's a start. care to share how that is done?

[utahfuntimes]

Your answer "Yes" was nice...how about some elaboration?

[petererik]

As you have probably noticed, the Send Mail script step is not web compatible, so you cannot send an e-mail directly from your web application. What you can do is run a script from an FMP client that polls your database for new or changed records and when it finds one the Send Mail script step is invoked.

Peter

[S_Yeung]

Hi petererik,

happen to see your post on the above matter which was posted almost 1.5 years back.Care to share more info on how can i go about it?Which script steps should I be using in this case.or do you have any samples to share?

Thanks

[petererik]

This is how I set it up:

1. Find a machine that you can use that will have FMP open all the time running the script described in 3. below.

2. Install the plugin Dacons "Scriptfire" or similar product on this machine.

3. Install Dacons "Mail.it" or similar product on this machine.

4. Create a script (let's call it "Local_Loop") that Opens the Remote database on the server and runs a script ("Server_Loop") on the server. Use Scriptfire calls to to trigger the "Local_Loop" script to run every x minutes (I have mine set to 2 minutes).

5. In "Server_Loop" you can download e-mail and store it in a table, send e-mail, etc. using Mail.it. Among other things, my script sends a notification whenever a record in a particular table changes. That is easy to accomplish once you have set up the system described above.

Peter

[petererik]

Steven,

You had some more questions which you sent to me privately. I will post the answers here because other members may be interested in the answer:

1) Is this a separate machine?

In my case it is because my server is Windows 2003 and I did not want to install Filemaker Pro on there.

2) Can I run it in the same machine.Eg in my server?

I am not sure if you can run FMP and FM Server on the same machine. If you can, then it should work.

3) Which file do you create these Local_Loop and Server_loop scripts in?The Mail.It or in your database.

Mail.It and Scriptfire are installed on the local machine running Local_loop. Here is the Local_loop script:

SFire_AddScriptTask(

"Mailer"; // Task name

"Server_Loop"; // Script name

""; // Script parameter

"fmnet:/myserver.mydomain.com/mydatabase"; // File location

"mymailuser"; // File account

"mypassword"; // File password

"interval: 00:02:00"; // Schedule

""; // Timeout

"Enabled" // State

)

Peter

[xochi]

You can use Mail.It under FMS9 using Server Scheduled Scripts. It's a little tricky to get right, but does work. No 2nd machine is required, the plugin runs directly on the server.

[syounker]

I just came across an email plug-in from 360works.com. It apparently works in Instant Web Publishing solutions and can be loaded as a plug-in in FM server. I'll be giving it a test in the next few weeks.