We have a list containing items classified by one field – “Category”.
We have a “Ranking” field for users to rank list items in a category.
We want the “Ranking” field to function like the column ordering section of list settings.
A user has ranked items as 1-5. They want to change the item ranked as “4” to a ranking of “2”. We would like the other items in the category to renumber reflecting that change.
Ideally, we would like this to work with inline editing within the list, instead of having to open the list item.
We’re using InfoPath 2010 for initial entry into the list. If we have to, we could use an InfoPath form for editing, but I would prefer to avoid that.