Check Box (Multiple) fields

1. I have a Check Box (Multiple) field. The check boxes have numerical values. How do I add them up when checked in user profile?
   
   I have a Check Box (Multiple) field. When I check one or boxes and save, all boxes are checked . What is causing this?
   

I have a Check Box (Multiple) field. The check boxes have numerical values. How do I add them up when checked in user profile?

You have to use CB Query Field or CB Code Field to either query for them and use SQL to add them up or use PHP to add up the substitutions. Example code as follows for a Code field.

I have a Check Box (Multiple) field. When I check one or boxes and save, all boxes are checked . What is causing this?

No idea, we have nothing that does this. You'd have to of have configured something to change the value of the field (e.g. CB Auto Actions). I am unable to confirm on 2 local installs or our demo site.

I have a Check Box (Multiple) field. When I check one or boxes and save, all boxes are checked . What is causing this?
No idea, we have nothing that does this. You'd have to of have configured something to change the value of the field (e.g. CB Auto Actions). I am unable to confirm on 2 local installs or our demo site.

Values
Value Label
5 choice1

Value Label
5 choice2

Value Label
5 choice3

Value Label
5 choice4

Well I found something interesting out. Because I have assigned the same value (5) to my checkboxes, checking one checks all of them on save. What is that? Happening at 2 demo sites.

return (int) '[cb_checkbox1]' + (int) '[cb_checkbox2]' + (int) '[cb_checkbox3]';

Is this formula for summing the checkbox values in a single multi checkbox field? That is what I want to achieve. So in my example if choice1 and choice2 are checked for a given user, the total is 5 + 5 = 10.

Well I found something interesting out. Because I have assigned the same value (5) to my checkboxes, checking one checks all of them on save. What is that? Happening at 2 demo sites.

You set all of their database values to be the same so of course that's going to happen. Value is used for database storage and needs to be unique. This is noted in the parameters description.

Is this formula for summing the checkbox values in a single multi checkbox field? That is what I want to achieve. So in my example if choice1 and choice2 are checked for a given user, the total is 5 + 5 = 10.

You'd need to explode the value then add the results all together. Multicheckbox and multselect fieldtypes store values with a |*| delimiter so they're stored as 5|*|6|*|7, etc.. You'd PHP explode by |*|, loop the array, and add the values. Example as follows.

It's good there is a way I can explode and add.

What is the best way of trying to do this, seeing every value has to be unique and I want to add the same values sometimes.

Do I create separate fields for what would have been separate checkboxes? I can, but it will exponentially add to my fields count.

Thanks

Best way is to make the values unique then strip out what makes them unique when doing the math. So for example you could have the following values

val1_5
val2_5
val3_5

That would make them unique while still allowing you to define a same points value for example. Then in your code you can use substr after a strpos, preg_match, or even and explode the extra the points value. Alternatively instead of hardcoding the value into the field value you assign a value in PHP instead which would give you the most flexibility.