0

Send email when number less than specified

Feel like this might be achieved through trigger on update (but not sure if a formula automatically changing affects trigger on update?)

I'd like to send an email to certain staff when stock levels fall below a certain point... so is x product inventory levels fall below 50, send email to these users with generic message "x product is low on stock" or some such.

 

Can this be achieved?

2 replies

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    Trigger onUpdate will not send a mail. The trigger onOpen can:

    Screen Shot 2019-05-23 at 11.40.28,028

    Birger

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Another strategy would be to put the code in a global function ... and then call that global function from a "save/close" button the user clicks when placing an order.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1237Views