2 Replies Latest reply on Apr 8, 2014 11:31 AM by paulspafford

    Automated e-mail notifications




      I´m trying to set up automated e-mail notifications for an inventory module.

      The objective is that when an item reaches its reorder level, an e-mail is sent automatically.

      The problem is the reorder data field is a calculated value and scripts triggers do not work with this kind of fields.


      Is there a way to achieve this?

        • 1. Re: Automated e-mail notifications

          You can assign a server side script to do a find on the value and then loop through and send the mails based on the returned list of values. You can schedule the script to run at timed intervals.

          • 2. Re: Automated e-mail notifications

            That calculation is based on other fields - possibly a field in Transaction, or an InventoryMovement table? When you make an entry into THAT field have a script that commits the record and then looks at the inventory calculation, sending the email if needed.







            Paul Spafford

            FileMaker Database Superhero,

            Spafford Data Solutions


            Tel: 613 314 8890