Newbie Questions

Re: Set a checkbox based on a textbox value

webwmn53 — Fri, 27 Aug 2021 18:58:12 GMT

thank you for the idea of using the FUNCTION!!!! that solved it for me with InfoPath 2013.

Re: Set a checkbox based on a textbox value

Laurie Wheeler — Fri, 03 Sep 2010 17:07:12 GMT

Absolutely.

Re: Set a checkbox based on a textbox value

Jimmy — Fri, 03 Sep 2010 16:42:12 GMT

Ok.....so I guess my advice would apply to the other section that requires the the checkboxes.

Re: Set a checkbox based on a textbox value

Laurie Wheeler — Fri, 03 Sep 2010 15:09:51 GMT

In reality... I don't even need the second check box. I just use a conditional formation on a related text box that I won't want visible until the one check box is checked. But... I needed to know how to do this anyway... I have other section of the form that will require it, where a text box is not involved but check boxes are.

Re: Set a checkbox based on a textbox value

Jimmy — Fri, 03 Sep 2010 15:04:16 GMT

Why not just use a rule to set the second checkbox to the same value as the first checkbox. No need for conditions or multiple rules.

Re: Set a checkbox based on a textbox value

Laurie Wheeler — Fri, 03 Sep 2010 14:43:26 GMT

Thank... I see I did have the values flip-flopped. I just need to add a rule now to turn it back off, when the first check box is un-checked. Thanks much.

Re: Set a checkbox based on a textbox value

Jimmy — Fri, 03 Sep 2010 14:39:20 GMT

Yes, it should work fine. Look at the properties of the checkbox you want to automatically check, and make sure that the checked value is true.

Re: Set a checkbox based on a textbox value

Laurie Wheeler — Fri, 03 Sep 2010 14:36:37 GMT

Can the same principle be applied between two check boxes. If I check one box, it checks another? I can get the value on the second check box to be 'true', but the box won't show up as 'checked'. I'm using InfoPath 2007.

Re: Set a checkbox based on a textbox value

Hilary Stoupa — Fri, 02 Oct 2009 00:44:45 GMT

When you have a situation where only one of something should be selected, option buttons are the way to go -- the logic gets a lot simpler, because you are only setting the value of a single field.

Re: Set a checkbox based on a textbox value

carwil — Thu, 01 Oct 2009 23:38:32 GMT

Thank you so much for the sample. It is very helpful. I know exactly what I did wrong. I was typing in TRUE and FALSE and did not use the function button to enter the value.

I believe I will delete the check boxes have and start over. It seems like the cleanest thing to do using your example.

Re: Set a checkbox based on a textbox value

Hilary Stoupa — Thu, 01 Oct 2009 22:44:54 GMT

I've attached a simple sample form to this reply. Right click the link in the header, and save the form locally. Right click the saved copy and open in design mode. Preview to test.

I only did two rules, one for < 19 and one for >= 19. The top section is for checkboxes -- you'll see that the value I'm setting the fields to is actually a function (click the fx button next to the value field to enter). The true() or false() functions help with pesky case errors.

In the second section, I show the same thing with a set of option buttons. When your options are mutually exclusive (and it sounds like yours are) and option button control can be a good way to go...

Re: Set a checkbox based on a textbox value

carwil — Thu, 01 Oct 2009 22:18:28 GMT

Hilary,

Thanks for getting back to me.

The rules are on a calculated field (which is hidden). I attempted to share the form, but I get an error, "Malicious Behavior Detected! The page or file you requested contains malicious code. Transaction ID is 4AC519EFA90C080E156F." So here goes...

I have a calculated field (Calc) which sums whole numbers. If the value of the Calc is < 19 I want to set chkbox1 (low) to True and the other three to False. If calc is between 20-29 I want to set chkbox2 (neutral) to True and the other three to False. If calc is between 30-40 I want to set chkbox3 (high) to True and the other three to False. If calc is >40 I want to set chkbox4 (dangerous) to True and the other three to False.

What I am seeing when I used your testing suggestion is the correct value of the calculation and the correct text so I do know that things are working correctly, but I never get the check in the box. I did just verify that I do not have any conditional formatting on any of the check boxes.

I am verifying all of my work in Preview Form, would I possibly see other results if I published the form?

Re: Set a checkbox based on a textbox value

Hilary Stoupa — Thu, 01 Oct 2009 21:52:35 GMT

So these rules are all set on some field other than chkbox1, 2, 3, or 4? Is this form something you can share? If so, perhaps attach it to a reply (under the Options tab, there is a place to attach a file). It is usually easier to figure these things out if we can see the form. When you talk about not being able to type in the box, it seems as if you may also have some conditional formatting set up?

Re: Set a checkbox based on a textbox value

carwil — Thu, 01 Oct 2009 17:30:42 GMT

Hilary,

Thank you for your reply.

I followed your suggestion and did get TRUE in the text box, but I must be missing something very simple. The effect that I got in the check boxes was this: (In Preview Form) TRUE – not checked and I cannot type into the box. FALSE – not checked, and I can check the other three check boxes.

I am setting the fields on a calculated field. Should I be doing it here or on the check box itself? What seems strange to me is that I can see that things are working correctly using a text box bound to the same field. I have to admit I am stumped.

Thank you!!

This what things look like:

Condition: Calc > 19

Actions: Set field value: chkbox1 = “TRUE”

Set field value: chkbox2 = “FALSE”

Set field value: chkbox3 = “FALSE”

Set field value: chkbox4 = “FALSE”

The check box properties are set as:

Data type: True/False (boolean)

Default: Cleared

Value when cleared: FALSE

Value when checked: TRUE

When I add the rules for check box 2 neither boxes are checked. This what things look like:

Condition: Calc > 19

Actions: Set field value: chkbox2 = “TRUE”

Set field value: chkbox1 = “FALSE”

Set field value: chkbox3 = “FALSE”

Set field value: chkbox4 = “FALSE”

The check box properties are set as:

Data type: True/False (boolean)

Default: Cleared

Value when cleared: FALSE

Value when checked: TRUE

Re: Set a checkbox based on a textbox value

Hilary Stoupa — Wed, 30 Sep 2009 20:51:54 GMT

Make sure your checkbox control uses TRUE and FALSE for the values of selected / deselected (you can look at the control's properties to find this). Sometimes when I'm troubleshooting something like this, I add an expression box or text box bound to the same field. See what it gets set to when you manually select / deselect the checkbox. Then see what it gets set to when you run your rule. XML is case sensitive, don't forget that, so true does not equal TRUE.