Artie L 0 Posted July 30, 2018 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 1,212 Posted July 30, 2018 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 0 Posted July 30, 2018 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 1,212 Posted July 30, 2018 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. 1 Share this post Link to post Share on other sites
