Non random form recipients

[WebRob]

I have a form and 3 different recipients. I would like to have the form submitted to each of the 3 people in sequence.

So the form gets submitted now and it goes to recipient 1, 10 minutes later the form is submitted and the info gets sent to recipient 2, 30 minutes later and the info is sent to recipient 3, the next time the form is submitted the info goes back to 1 and so on.

I know that setting it up for randomizing would be easy. How would I go about a sequence?

Thanks in advance for any help!

[earl-grey]

Check out cron

[WebRob]

Check out cron

Thank you for the reply.

I am not looking for things to work out in a specific time frame. I want the emails to be sent to the recipients in a sequence. So in effect the form cycles through the list of recipients.

[Jake Arkinstall]

So does it matter about the timescale?

I was thrown by the ten-minute gap idea.

[earl-grey]

Well, you can do that using cron. Set up a script, which is executed every N minutes, and sends all emails that had to be sent within the past N minutes.

Accuracy of sending time will depend on the timeout between two consequent script executions.

[WebRob]

Well, you can do that using cron. Set up a script, which is executed every N minutes, and sends all emails that had to be sent within the past N minutes.

Accuracy of sending time will depend on the timeout between two consequent script executions.

Let me try to explain a bit better.

The form is a quote form. We do not want the form to go to all of the sales people when it is submitted. We want the sales form to cycle through the sales associates.

So if the form is submitted now the submitted info will go to sales associate A, the next time it is submitted the info will go to associate B. The next time the info will go to associate C. then the next time the form is submitted the info will go back to associate A and so on.

I hope this makes more sense.

[earl-grey]

Let me try to explain a bit better.

The form is a quote form. We do not want the form to go to all of the sales people when it is submitted. We want the sales form to cycle through the sales associates.

So if the form is submitted now the submitted info will go to sales associate A, the next time it is submitted the info will go to associate B. The next time the info will go to associate C. then the next time the form is submitted the info will go back to associate A and so on.

I hope this makes more sense.

Makes sense. You can store id of the last sales associate the form was sent to. Then fetch id of the next associate like this:

SELECT id
  FROM sales_associates
 WHERE id > $last_id
ORDER
    BY id
 LIMIT 1

If the query above returns no results, then run this query:

SELECT id
  FROM sales_associates
ORDER
    BY id
 LIMIT 1

After that update last sales associate id.

[WebRob]

OK...this sounds good. I was thinking something along these lines. I couldn't quite visualize it though.

Thanks for your help!!