Controls

Re: how can i limit the check box

waple02 — Sun, 27 Jun 2010 13:53:27 GMT

Hi Jimmy,

Thanks for your response, i have sent attachment file to your email address, base on the formula you suggested.

Thanks,

Waple

Re: how can i limit the check box

Jimmy — Sun, 27 Jun 2010 12:17:54 GMT

Hello,

Sorry if you understood my most recent post. In the end, I thought there wasn't that much value in rearranging your data source, and thought that using the formula in the post before that might be sufficient for this quantity of questions. I do think it would be wise to give your nodes more meaningful names, but you don't need a sample to do that.

Can you try out the most recent formula I suggested and tell us how it works out?

Re: how can i limit the check box

waple02 — Sun, 27 Jun 2010 07:07:19 GMT

Hi Jimmy,

How are you? any chance for the sample of the form?

Regards,

Waple

Re: how can i limit the check box

Jimmy — Wed, 23 Jun 2010 14:42:38 GMT

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.

Re: how can i limit the check box

Jimmy — Wed, 23 Jun 2010 14:05:11 GMT

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.

Re: how can i limit the check box

waple02 — Wed, 23 Jun 2010 14:00:31 GMT

Hi Jimmy,

Question how get the summary of this.

O	C	S
Field 764	Field 764	Field 764

O	C	S
Field 765	Field 765	Field 765

O	C	S
Field 766	Field 766	Field 766

I need to get same summay inside the box, here's the formula i was using

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

using this formula, i'm not getting same summary inside the box, please advice for correct formula

Re: how can i limit the check box

waple02 — Wed, 23 Jun 2010 13:47:56 GMT

Hi Jimmy,

Question how get the summary of this.

O	C	S
Field 764	Field 764	Field 764

O	C	S
Field 765	Field 765	Field 765

O	C	S
Field 766	Field 766	Field 766

210

I need to get same summay inside the box, here's the formula i was using

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

using this formula, i'm not getting same summary inside the box, please advice for correct formula

Re: how can i limit the check box

Jimmy — Mon, 21 Jun 2010 14:45:14 GMT

Sure. james dot rishe at qdabra dot com.

Re: how can i limit the check box

waple02 — Mon, 21 Jun 2010 13:56:02 GMT

Hi Jimmy,

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

Thanks in advance,

Waple

Re: how can i limit the check box

Jimmy — Mon, 21 Jun 2010 13:33:26 GMT

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.

Re: how can i limit the check box

waple02 — Mon, 21 Jun 2010 13:27:37 GMT

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

Re: how can i limit the check box

Jimmy — Mon, 21 Jun 2010 12:14:28 GMT

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

Re: how can i limit the check box

waple02 — Mon, 21 Jun 2010 09:00:54 GMT

@Aazi Anis

Please read my first post message.

Re: how can i limit the check box

waple02 — Mon, 21 Jun 2010 09:00:39 GMT

@Aazi Anis

Please ready my first post message.

Re: how can i limit the check box

Qazi Anis — Mon, 21 Jun 2010 08:36:23 GMT

just put a data validation on the checkboxes

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

error