Repeating option controls on infopath form

Question

I get data from a sharepoint list as a data source. I then have a repeating table which has one of the fields as a option (radio) control. Unfortunately, when the data is repeated, it doesn't include the option control as part of the same group, so it's possible to have multiple option controls selected at the same time. Is there any way to fix this?

Here is an explanation of the problem, along with a screenshot of part of the form.

This next bit of info is a representative set of data from the sharepoint list that populate the repeatable field.

Answer 1

I have a solution (workaround).

Only thing you need to compromise on is to replace your option button with check box (but with same functionality as option button).

I hope that you have some basic skills with InfoPath rules since my solution is all rules and it is not so simple (but you asked for no code).

Step 1:

Add two new columns to source list:

IsChecked – Type: Boolean Default value: False
DummyTitle – Type: Single line of text

My source list:

Step 2:

Refresh data connection to source list in InfoPath, delete option button and just leave Title (as label/calculated value or textbox) – this is setup you already have. Or recreate your repeating table from scratch.

Step 3:

Add newly created fields to repeating table. IsChecked as CheckBox, DummyTitle as TextBox.

Add one more field to your main InfoPath data – SelectedItem (to store current selection) and add it outside of repeating table as TextBox.

InfoPath design view:

Step 4:

Add two rules to IsChecked CheckBox:

Rule A:

Condition: IsChecked = TRUE and DummyTitle != (not equal) Title

Action: Set a field's value: SelectedItem = Title

Rule B:

Condition: IsChecked = FALSE and DummyTitle = Title

Action: Set a field's value IsChecked = true

Note: Rule B is ensuring that check boxes in repeating table are working as option buttons. Only one can be true.

Step 5:

Add rule to DummyTitle textbox

Condition: DummyTitle != (not equal) Title and IsChecked = TRUE

Action: Set a Field's value: IsChecked = false

Step 5:

Add rule to SelectedItem textbox.

Condition: None

Action: Set filed's value DummyTitle = SelectedItem

If you followed my steps and if I didn't make any error in explanation you will now have working example of my solution.

InfoPath preview:

Note: For production solution you can hide DummyTitle.

I used MOSS 2010 platform and InfoPath 2010 (but since there is nothing so special in solution it can run on 2007). I can even send you my xsn file for reference.

I have tried to write things down as simple as possible so no additional explanation is included. Like always: I will provide more info if needed.

I haven't touched InfoPath for year so I will not exclude that there is some simpler solution.

Answer 2

My quick answer is to hook the Change event of the radio button, write some VB or C# code to select the Xml nodes related to that field (i.e. e.Site.Select([full XPath of field])), and Set the value of all the returned nodes except the currently selected one to zero.

I'm on my phone right now, but will drop a code snippet on how to do this later if needed.

Hopefully this will at least get you started in the right direction.