I have the following requirement
- Send an email when a record is created to the assigned user(field in the record).
- Starting from the 3rd day from the day the record was created start sending emails to the assigned user for one week.
I was thinking of using workflow to achieve this. The plan(design) was to two workflows to achieve the result.
First workflow is fired when the record is created using ISNEW() rule criteria. This WF will have one email trigger.It will also have time dependent email action(after 3days) of an email trigger and a field update(a hidden number field called timeTriggerCheck incremented by one).
The second WF to have rule criteria of ISCHANGED(timeTriggerCheck) and ISVAL(timeTriggerCheck)<= 9.
However i don't see any way to update the hidden number by one every day via WF formula. Nor do i see any way to check if the value of the number field is less than 10.
Can the requirement be fulfilled using Workflows in the above way. I do feel one workaround would be to keep only the first WF and keep all time based email trigger under it. Something in the following order:
3 days after rule trigger date
4 days after rule trigger date
9 days after rule trigger date
However the number of such days might increase and hence it seems quite inappropriate to manually create such records.