I have a site where there are multiple staff profiles, each of which are in a specific department; some times more than one. Parts of these profiles are then displayed in a grid view for each department.
What I need to do is have a method of setting their ordering in the grid view. My original plan was to just have a text field where they can enter the profiles position number & have the view order by that. The problem is they can be part of multiple departments so the numbers entered could conflict between departments.
Does anyone have any ideas on a way around this?
The other idea that has been suggested is to add a weighting to each profile and that would dictate its position, still kind of has the same problem as the text field though. If I was to use the weighting system what is the best way to add it? I assuming just creating a select field with the options -50 through to +50 isn't the best way?