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.