I’m looking for a way to reorder or move selected items up and down in a Multivalue Lookup Column. The list to select from is ordered correctly but the selected items are ordered by how they were selected. Our end users would like to move these items up and down the list. Is this possible with JQuery or SPServices? I’m using SharePoint 2007 currently. Thanks in advance for any advice anyone can provide.Â
Actually, I wasn’t suggesting you use the checkboxes, and the reality is that the checkboxes are still storing in the order checked. I was just offering it up so you could see how values are stored for multi-value lookup fields. They’re stored in a weird string involving pipes (|) and t characters. To allow for them to be re-arranged, you’ll need to rearrange that underlying string, as well as rearranging them in the visual interface.
SharePoint has a built in method that turns them into an array (referenced in my code), so you could possibly do some array sorting of some sort. I guess the way I’d tackle it is to use jquery to allow for moving up and down in the visual element (maybe with this: http://jqueryui.com/sortable/) and then rebuild the string on the back side at some point. I’m not sure it would rebuild fast enough if you did it on every change, though.
Oh, and caveat – I missed that you were doing 2007. This method works with 2010. I’m not sure about 2007. I don’t have an environment to test in.
Make sense?
