How? Trigger script by adding new record?????

March 10, 200817 yr

Hey Folks.

So I have a commonly asked question of which I have yet to find any really good answers to:

{background: We are running FMServer Advanced 8.5 on OS X 10.4 and we are integrating it with CWP via the xml/xslt grammer set.}

PROBLEM: I want to allow the public to complete a form online using a CWP interface (which works fine) BUT I'd like to get notified* every time a form is successfully complete THAT IS: a new record is added to that database

*(run script send me email - that part is easy).

If we were doing this directly in FMPRo, it wouldn't be a big deal.

So in short, I'd like to figure a way to get the adding of the record to automatically trigger the running of a script.

--------

Another variation on this I'd like to figure out:

[PROBLEM: scheduled event triggers script}

A scheduled event (at specified time, event is triggered.) The only way I can figure this out is to use a lonely computer with a standalone database linked to the shared database that is always running and always running a script that is looping through some testing action.

this seems really silly. Seems like there should be an easy way to trigger a timed event.

I'd like NOT to use the SCHEDULED EVENTS on the server. I could write some applescipts to trigger the script in the DB and then just schedule the server to run this applescript on a schedule. (I haven't done it but this is what my research tells me. correct me if I am mistaken.)

So anyway Folks, if anyone has some good solutions or tips or information or a links, your assistance is greatly appreciated.

thank you in advance

the wheelhorse