Only one record allowed to have a check box checked

Hey Jerry, this can be done in the database itself, but I don't know if you can do it through CMSBuilder.

I'll refer this to Dave, he might have a solution.

I should specify - I think this can't be done with a checkbox field at all, so you may want to look into using another field type.

That's unfortunate, but I guess that a Y in a text field would suffice if it has to.

Just not as elegant...

Maybe Dave will have some magic up his sleeve.

Thanks,

Jerry Kornbluth

Hi Guys, 

When you set this option in the Field Editor: 

Unique       [X] user may not enter the same value as another record (not case-sensitive)

It checks that no other records have the same value, but it ignores "blank" 0-character values when checking.  So it doesn't work for checkboxes because checkboxes store their state as either 0 or 1 in the database meaning it would allow one record with a checked box and one with an unchecked box.

But what you could do instead of a checkbox would be to use a list field and set the list values as follows:

|No
1|Yes

And then check the "Unique" checkbox.  That would store blank "" for the No value and 1 for the Yes value (and you could use whatever you wanted instead of Yes/No).  Furthermore, it would only allow you to have one record with 1/Yes set and unlimited records with blank/No set.  

It's not a checkbox, but pretty close, and you can rely on consistent user input since they can only select those two options.

Hope that helps!

WOW!!!!

What a great idea.

Thanks,

Jerry Kornbluth