Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise

Artie L

Alerts/Calendar

Recommended Posts

Artie L

Hi,

I am new to the Forum, I have a couple of years experience with FMP, mostly basic. We have FMP 16. I would like the program to send me an email when a target date is about 30 days out. How would I set that up?

Thank you in advance for all your help!

Artie L

Share this post


Link to post
Share on other sites
Josh Ormond

How is your file hosted? Is it hosted? This typically would be handled using a scheduled script on FileMaker Server, so that it doesn't require you to open the file every day to have a script check the dates on all events.

Share this post


Link to post
Share on other sites
Artie L

No, it is not hosted, I have the desktop version, all data is located on my local server.

Share this post


Link to post
Share on other sites
Josh Ormond

Is the file used by more than just you?

If it's just you:

  • Opening a file across a network can be dangerous for the file. A network hiccup can cause file corruption because it's not closed properly.

If more than one user accesses the file:

  • definitely don't do this. It is not how FileMaker shares data.

 

Basically, you create a script to go to whatever table you have your events stored. Do a find to narrow to the events you want to generate an email for. And loop the records sending an email for each of them.

  • Like 1

Share this post


Link to post
Share on other sites
Artie L

Thank you!

Artie

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

×