Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

So I hope this makes sense. I have a column within a list that I want to use as an active flag. There are 5 possible categories and for each category there can only be one active value. So I need some method that if a user select category 2, and makes it active, then the previous category 2 active value no longer is active.

Could I achieve this by adding SPServices and jQuery to the edit form (probably new too i guess), and just use a CAML value to find this value and update it? How would I be able to narrow it to that other ID?

Does this even make sense? :) Thanks as always guys!

EDIT: restating in an attempt to clarify another one of my bizarre questions.

Is it possible to achieve something like having a choice field with options 0-5, where option 0 is not unique, but option 1-5 are? Probably not within the built in SharePoint construct of the choice field and rad button, but is there a way to combine some jquery with that in order to achieve the same result. So I don't care how many zeros there are throughout the lists, multiple items can all be ranked zero, but I need ranking 1 to 5 to be unique. If 1 is the value of this field on itemID=312, then how to prevent it if itemID=311 also equals 1, or change that value from 1 to zero for itemID=311?? This sounds weird I know but it is exactly what I need for an automated ranking system that pulls content and builds pages dynamically based on user selections.

share|improve this question
WOuldn't radio buttons make more sense as there can only be one selected? –  PirateEric Dec 21 '12 at 16:57
not within the same item, but if any other item has that value set, set it to a default value, or null or something. I have to develop a ranking system, but I cannot allow 4th for example, to be set on more than one item....however I still can't use unique because I not a default value for all those not currently included in the ranking....better approach to this? thanks! –  Justin Jan 2 '13 at 12:51
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.