Server and Email Question

[agtjazz]

Hello,

I would like to use the sendmail script feature for a database telling the user that the request was received (once they hit the “save” button).

This database is going to be hosted by FMSA 8 on Mac OSX and do IWP. It’s a simple database for travel requests. Users will submit a travel requests and an admin will approve/deny or forward to committee etc.

I don’t have a default email client configured on a server. If I did, would someone need to be logged in at all times (to a server??)?

I am just not getting it. Any help or advice would be greatly appreciated.

Thanks in Advance

[Vaughan]

The Send Mail step is not web-compatible. You cannot use it in a script that's being activated by a web client.

Somebody will suggest a way of doing it on the server.

ANother method is to have a "drone" computer running FMP, commencted into the database, regularly running a "search for new requests and send an email" script.

[agtjazz]

I am interested in the "drone" computer idea and more specifically how do you script something to run "regularly"?

thanks bunches

[Søren Dyhr]

Loop the execution of the script with this:

http://www.filemaker.com/help/Script-Steps3.html

--sd

[agtjazz]

Ok Wow... Thanks bunches to both of you

I am off to read and test.

Thanks again

[agtjazz]

I was hoping to get a little help with my script. It's looping too much and sending out a million emails

Perform Find- Submission_Status=Submitted

Loop

Send Mail

Set Field- Submission_Status=Test

Go to Record/Request/Page - next, exit after last

End Loop

Thanks in advance

Edited October 31, 2007 by Guest

[T-Square]

I'm working off the top of my head here. How about:

Set Error Capture[On]

Loop

Show All Records

Perform Find- Submission_Status = Submitted

If (Not(Get(LastError)))

Loop

Send Mail

Set Field- Submission_Status = Sent

Commit Record/Request[]

Go to Record/Request/Page - next, exit after last

End Loop

End If

Pause/Resume Script[someValue]

End Loop