Artie L Posted July 30, 2018 Share 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 Link to comment Share on other sites More sharing options...
Josh Ormond Posted July 30, 2018 Share 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. Link to comment Share on other sites More sharing options...
Artie L Posted July 30, 2018 Author Share Posted July 30, 2018 No, it is not hosted, I have the desktop version, all data is located on my local server. Link to comment Share on other sites More sharing options...
Josh Ormond Posted July 30, 2018 Share 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 Link to comment Share on other sites More sharing options...
Artie L Posted July 30, 2018 Author Share Posted July 30, 2018 Thank you! Artie Link to comment Share on other sites More sharing options...
Recommended Posts