InfoPath Dev

anybody can help me?, i'm creating  forms for our hr department. i want to limit the check box option i have five selections check box.

 example:

 check box 1 goes to = excellent

check box 2 goes to= very good

check box 3 goes to= good

check box 4 goes to = fair

check box 5 goes to = fair

only one box can be choosen.

Is there any reason you don't want to use a radio button?

Hi Jimmy,

   Thanks for your reply, The reason i used the checkbox, i need to get sum all selected check box ,here's my example.

selection1: i select (O), The value of (O) to checkbox is (1)

selection2: i select (O), The value of (O) to checkbox is (1)

selection3: i select (C), The value of (C) to checkbox is (1)

 selection4: i select (S), The value of (S) to checkbox is (1)

 selection5: i select (NI), The value of (NI) to checkbox is (1)

 selection6: i select (US), The value of (US) to checkbox is (1)

 just put a data validation on the checkboxes

if checkbox1  + checkbox2  + checkbox3 + checkbox4  + checkbox5 >1

error

@Aazi Anis

    Please ready my first post message.

@Aazi Anis

    Please read my first post message.

If you use radio buttons, you can use count(evaluation[. = 'O']), count(evaluation[. = 'C']), etc. to aggregate the summary values at the bottom.

Hi Jimmy, I'm not use to programming field, i need little from you, where i will place  the formula? radio button or in the summary field,

if you can give me the complete formula, but help me a lot

The formula would go in the summary field.  I'm assuming you're currently using the sum() function to count the number of checked boxes, so it would be similar to that.  Just use:

 count(/full/path/to/your/radioButton/field[. = 'valueToCount'])

That's the most complete I can make it without actually having your form.

Hi Jimmy,

   It's possible to send, my form in your email address?

Thanks in advance,

Waple

Sure.  james dot rishe at qdabra dot com.

Hi Jimmy,

   Question how get the summary of this.

Hi Jimmy,

   Question how get the summary of this.

This formula should do the trick:

count((field764 | field765 | field766)[. = 1])

 But I think structuring your form with hundreds of fields named fieldNNNN is not the way to go.  I'll try to send you an example of a better way to do it in the next day or two.

On second thought, the number of questions in your form seems to be few enough that you could get by without using a more structured data source, but I would suggest using more descriptive names for your fields.  It'll help when you're setting up your formulas.