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 selects 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 red 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.

  • WOuldn't radio buttons make more sense as there can only be one selected? – Eric Alexander 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.