Jump to content
Sign in to follow this  
Bill_misc_IT

Email user if expiration date is passed

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.