Email user if expiration date is passed

[Bill_misc_IT]

Can I set up filemaker to email an alert if a date has expired? Not sure what area this should be posted. I just upgraded to fm10 and fms10, so perhaps it can be done with one of the new features.

Thanks

[mr_vodka]

If you have server, you can have your server side script just run a script at a certain time one a day. The script could check to see it the date has passed and if so send the alert using the new SMTP feature.

[Bill_misc_IT]

I've tried to set-up a daily script at 8:00AM, but it is not working. Here is what I've done so far:

1. Set-up the SMTP in FMS. The test email works correctly.

2. Created a script in the database that I'd like to to generate the email report in FMPA. It work's when I test it within FMPA.

The script does not work from FMS. I've tested it by forcing it to run in the admin console.

What is the next thing I can check?

[bcooney]

I'm wondering, how do you know a date has expired? Perhaps if you show us a bit of your script logic, it'll help.

Remember to be on the correct layout. Perhaps you go there manually, but server can't, and so that'll need to be in your script.

When you say the script does not work...what exactly does that mean?