I’m relatively new to building workflows using SharePoint Designer 2013. I’ve set up a primitive “ticketing” system to track enhancement requests for several of our apps. My boss would like it to send a once daily reminder email if the “ticket” hasn’t been updated once in the last seven days, but only for seven of the twelve possible statuses.
I have figured out how to send email based on the status. And I’ve found, I think, how to use the Pause function to wait for 7 days. There are two things I cannot, however, determine.
1/ Is there a way to do an If Status In “New, Assigned, WIP, Pending, etc.”, then send email without having to do it over and over for each status, as this message will be the same, no matter the status if it fires, unlike the notifications currently configured?
My code currently looks similar to:
If Current Items:Request Status equals Assigned
If Current Item:Modified equals Today
Pause for 7 days, 0 hours, 5 minutes
then email Current Item: AssignedTo
At the moment, I have that block seven times, once for each status he cares about. I feel like I should be able to collapse it into one. I just can’t figure out how to do it.
2/ Is there a way to get this to refire daily if they don’t go in and update their ticket? Thinking along the lines of a repeat until updated or closed kind of thing, but I’m not finding anything like that in the list of Designer commands nor in the knowledge base.