Sending email with new record info??

[SFalk]

Hi guys,

When a new record is created in my FMPro 5 db, I need to automatically send an email to a third party, with the record information included. Any ideas how to do this??
I'm using this form:

<FORM ACTION="FMPro" METHOD="post">[\code]
Thanks!
Sarah

 

[TStriker]

Sarah,

Are you using the FM Pro application or are you using a web browser hooked to a Filemaker database?

-Striker

 

[SFalk]

I'm using a web broswer hooked to a Filemaker database.

 

[TStriker]

Sarah,

Sorry but I have very little experience with FM and the web. I have a hunch that it is not possible with either IWP or CWP but maybe if you're using PHP or ASP. Anyway, I don't know the answer, maybe Jean does?

-Striker

 

[JeanW]

I-m in the same boat as Striker

What I did once to accomplsh this:

I took an old computer, installed FMPro client. Wrote a script that checks for a new record in the shared file every 60 seconds. If it finds a new record it triggers the email operation, marks the record as acknowledged and continues on checking.

Another way if you don't have a spare machine and use a Mac:

Find a machine that is never turned off, and set up a 2nd account on it. Use Fast User Switching to go to that account, log in via Filemaker, then use FUS to go back to the normal os x user.

Rumor is you can even use FUS on the server machine itself, though certain folks will claim it's an unholy abomination and will cause the filmaker gods to strike you down, etc.
so, be carefull....

I use a lot of old computers to do 'out of the box tasks',like a computer that just runs FileMaker scripts all day to print documents. They just search for flags in certain fields that mean a document needs to be printed. They do the work, clear the flag and go on with their searching.

This same basic process could work over the web because the remote user is simply placing a value in a field or running a script that places a value in a field. The computer that actually does the work is a regular FileMaker Pro client with the ability to print, email, fax, etc.

The only thing I could come up with is to watch :

http://www.fmwebschool.com/resources/iwpphp/iwpphp.html

it uses IWP and PHP to fire off emails every time a new record is created.

Sorry to be not a great help in this.....

 

[JeanW]

Well...after a night thinking....

You're on FM 5....

With FM5 there was the introduction of the InLineActions, which give the possibility to play with CDML and perform several functions, like -find, -edit, -delete and -sendmail from within a single format file.

So, I suppose that the -sendmail action can be used.

I'm not familiar with the whole web and CDML world, only had a small touch of it years ago, so this is free hand coding....based on a memory that is not that young anymore....

I think to fire of a email you can use something along these lines:

[FMP-InLineAction: -db=yourFileName.fp5, -mailto=[field_email], -mailfrom= yourMail@whatEverItIs.etc, -mailsub=yourTextSubject, -mailHost=mail.whatEver.com, -mailFormat=yourTextFieldsCalculationConcatenate, -view]
[/FMP-InLineAction]

I'm complete freewheeling here, but it can give you an idea where to look.