OnNewRecord Script Trigger

[Jim Gill]

Yeah I know there is no OnNewRecord script trigger - but this is what I would like to happen.

I have a a table called Prospects where prospective clients input information via our website. New records are created in the Prospect table once the client pushes the submit button.

Is there a way to trigger a script each time a record is created in the Prospect table?

The script I have written simply emails my office manager to alert her of a new prospective so she can send them information.

Thanks for your help,

Jim

[eos]

The OnRecordLoad trigger also fires on creation of a new record. But you already have a trigger - it's the prospective client clicking a button.

[Jim Gill]

The OnRecordLoad trigger also fires on creation of a new record.

The form the prospective client uses is through PHP so it is not "live" in filemaker. It scripted on the web side (which I don't completely understand) I tried the OnRecordLoad but I still have to find and make the new record active for the script trigger to fire.

But you already have a trigger - it's the prospective client clicking a button.

I asked my web guy about having a notification email sent when a client pushes the submit button and he told me me this would be very difficult and expensive - its why I'm trying to do it in filemaker.

Any other ideas?

Thanks!

Jim

[bcooney]

Create a field in the Prospects table, TimeStamp_NotifiedOM. Create a scheduled server script (this is a served solution?) that finds all records where isempty(TimeStamp_NotifiedOM ) and sends a list of them in an email to the office manager (or a separate email for each record) and enters the TimeStamp_NotifiedOM. How often you want to run the schedule that trolls for new prospect records is up to you.

[Jim Gill]

bcooney - thank you so much! Works perfect! I haven't done much on the server side and you have given me a whole new realm of possibilities for my solution! Thank you again!

Jim