Alerts/Calendar

[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

[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.

[Artie L]

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

[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.

[Artie L]

Thank you!

Artie