E-mail Bot Keep Sending

[KathB27]

Hi All,

I have set up an email bot for this inventory app im working with. That when the current stock hits the Safety Stock level and the status turns to Reorder, it will send email notification. However, the email notification keeps sending everytime i deduct from the inventory until the stocks is not more than the safety stock level. I need it to send one time only.
Is there a way around this?

[dbaum · Accepted solution]

You probably set the automation event's condition to something like:

[Stock Level] <= [Safety Level]

Try instead something like:

AND([_THISROWAFTER].[Stock Level] <= [Safety Level],[_THISROWBEFORE].[Stock Level] > [Safety Level])

[KathB27]

Thank you so much @dbaum for always being there to help the community!!! 😍

You are right i did use the first formula 😖