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:
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |