Send email notification on timed interval

[dmontano]

Curious if this is possible:

 

User selects a value from drop-down field, such as "Contract Sent". One week later (the interval), the DB will run a script that sends an email to the User asking if they have received the contract? The email will continue to notify them until the User goes back in to DB and alters the value in the drop-down field to "Contract Received" - then the script would stop sending emails.

 

I am quite interested in a solution without plug-ins that is cross-platform compatible. I can see some great things I can do with such a "feature".

 

If this is possible, does the DB have to be "open", or can it just be "available".

 

Thanks,

David

[dmontano]

Does anyone know if this is possible?

[HBMarlowe]

Without using a plug-in a script can only be triggered by a button, called as a sub-script, or set to run on open or close. What you're asking for is easy enough if your user can click a button.

[dmontano]

Thanks John,

I have done something maybe similar...

 

I have wrote a mac automator script and had someone else write a pc script and we installed in our department (about 40). When user launches their email programs it triggers our script. This was obviously outside of any FileMake use, but from what you said it has me wondering if I can use some other "event" that will happen almost daily to use as my trigger in FM.

 

For example, I have a start-up script that will "route" the FM user based on their privileges to either "web" layouts or to the FM native layouts.

 

I wonder if I could use this as a trigger. For example, adjust the start-up script that when any one in a particular privilege group logs in, it triggers the script.

 

That would be daily - and not what I asked - I had asked for weekly or some timed interval. So...

 

If this might be possible to use a daily trigger such as this, might it be possible to have the script check the status of what I need completed (checkbox) if not, then check the elapsed time and calculate if it should send today, on this days login script, or wait until another day?

 

Just curious because this would be fantastic to be able to "schedule" reminders, especially if they are of importance - job scheduling and such or important documents not only tracked - but reminding those responsible to obtain what is required.

 

(By the way, I have a ERD I have been working on and would appreciate your input. I have taken many people's suggestion and finally got something started - any feedback would be tremendous.) Will post in a few minutes - not done but it should show my madness in plain view for all.

 

Thanks,

David