It might not be this but there is a spelling mistake in one of the reminder_off's. It reads reminrer_off. Perhaps this is causing some issues?
I think I have sorted this using triggers. I'm going to test this over the next few days so I'll let you know how I get on! Create tag: Update assignee and remove tag: