Rules Advice

Hi,

We use workflow to keep track of jobs. When we make a job 'finished' we send an email to the customer.

I now want to send a reminder to the customer 1 week, 2 weeks, 3 weeks and a month later. We currently create a node which upon save sends the email (so we keep a log of what we sent and when).

Just to add to the mix, there is potential that the customer will take their laptop away but come back again so we'll reopen the same job. This means the job will be put back into finished and the countdown should start again.

I can think of one way: have a counter on the node that via a cron run will up the counter each day the job status is finished and then have a rule that will trigger when a level is reached, creating a reminder node (which in turns triggers the email to be sent). We can reset that counter to 0 each time the status moves to finished.

Would this be the best way to perform what I need?

Thanks,
Paul.