Alert recurrence that looks at a date field - possible?
I'm trying to set a recurring alert workflow to remind someone that they need to approve a submission. I have a "submission date" field and I would like a workflow that sends a reminder one week after submission date is reached and then weekly after that, as long as the status field is not changed to "approved".
I was able to set an alert to occur only ONCE, one week after the "submission date" field is reached.
I was also able to set a recurring WEEKLY alert, but I don't see an option to set the start date as the date located in the "submission date" field. The only recurring option I see is to send the reminder weekly, starting on a set date I have to enter from a calendar, which is not feasible as all of my rows will have different submission dates.
Any input on how to achieve this would be appreciated. I really don't want to set 20+ different workflows for each week...