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

    Automated e-mail notifications

    mcampa0902

      Hi:

       

      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
          Vyke

          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
            paulspafford

            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

             

             

             

            --

            Paul Spafford

            FileMaker Database Superhero,

            Spafford Data Solutions

             

            Tel: 613 314 8890

            www.paulspafford.com

            www.ottawafilemakerdeveloper.com

            www.fmlayoutmode.com