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:
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:
I hope this helps.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |