Email Alert script
I'd like to know how I can create an email alert within Filemaker.
The desired function is for Filemaker to alert me via email when an employees licence is due to expire. For example, I have a database that includes approximately 150 licences that have various expiry dates, the best scenario would be for an email alert to be triggered one month (for example) before a licence is due to expire.
This alert would be a simple text message (no attachments necessary) that alerted me to:
- FM Record
- The Expiry date (based on the relevant Field's expiry information)
I look forward to any responses that may assist me with this.