I manage a college website. We've got six admissions counselors who are each assigned a group of U.S. states that they're responsible for. For various reasons, these assignments change all the time - Counselor A gives NY and Pennsylvania to Counselor C and takes Idaho from Counselor B, and so on. Each state can only have one counselor assigned to it at any given time.
I'm using a multi-select taxonomy vocabulary called "States" to manage this. Using the example above, we currently have to edit all three counselors - add NY and Pennsylvania to Counselor C, take those same states from Counselor A... you get the point. Kind of tedious, and easy to screw up and wind up with states that don't have a counselor assigned or multiple counselors assigned to the same state (especially when editing responsibilities are delegated to multiple people in the Admissions department).
There's got to be a better way to manage this, but I haven't figured it out yet. Any ideas?
Comments
Nope?
Guess not.
You don't specify if a
You don't specify if a counselor is a user or a node type so I'm assuming the latter. In this case you can write validation function for node edit submit to make sure no more than one counselor node type is associated with each term. You can also use VBO to do this in bulk.