Automation Help

[Ryan1]

My vendor will log into the app once a week to order the items needed. If midweek there are suddenly ten or more items needed I would like to send him an email so he can get this going sooner (some weeks we go through more items than usual). I have automated my app so that if the total number is greater than or equal to ten, it sends the email. However, I don’t want it to keep sending more emails when 11, 12, or more items are needed. So I guess I need to add a step in the process to see if an email has already been sent in the last seven days before sending the email. Any help on doing this? I take it It might go here:

I have no idea how to write this condition.
I take it that it needs to be something like
If(time since(date(action happened)))<7 = Yes
where action happened is sending the email, date is the day it happened yada yada yada.
Please help!

[Dan_Bahir]

Hi @Ryan1,

Do you manage the items inventory through the AppSheet app ? That is when you remove one of the items do you do that through the app ?

If so you could send an email when the item amount is modified and is below a threshold.

If you want to keep track of when an action has happened you can do that by adding a column to the table. You would then fill in that column when you perform the action and would need to later clear that column (when you get more items in).

So it seems like there are two options:

1. Send the email when the amount of an item is changed
2. Add another column to track if an item has been requested for restock, reset that column when it is restocked. Use that column when generating the email.

I hope this helps.