表单提交按钮 - 每次提交时更改操作页面

Question

I have a form with a submit button that when pressed it emails the contents to a single email address. The email is then manually forwarded to one of 3 people on a rota system.

Is there any way that the submit button could work so that when the first site visitor clicks it the inquiry goes to staff member 1, when the next one does it the inquiry goes to staff member 2 when the next one does it it goes to staff member 3 and then back to staff member 1 when the next one does it.

Any help would be greatly appreciated.

Answer 1

Make a column in database for current active_member

set 0 default value.

get first staff member from database with column active_member value 0

set column active_member to 1 when you send mail to that staff member.

when no member have active_member value column value 0 than Reset all value to 0.