InfoPath Dev

I have a repeating table that I'm using a secondary data source to populate because I have 100s of entries for the table.  I have it set up in a handmade multi select box and need to concatenate all the boxes that are checked into a text box in a different view.  I got this to work using a formula with manual entries in the repeating table but doing it this way would take forever and so I'm thinking that I need to make a data source that will establish both the true/false checkbox AND the item to be selected, I have the items down, just not the true/false checkbox.  Any ideas?

 My data source is currently like this

<?xml version="1.0" encoding="utf-8"?>
<SelectedCompounds>
<text value="compound1">compound1</text>
<text value="compound2">compound2</text>

It creates a data source like the following

SelectedCompounds (group) / text (repeating field) / value

And creates a table with two columns that are both populated with the same data, value and text, I want the value column, instead of matching the text column as it does not to be true/false checkboxes.  I've tried doing a 'changeto' and making them check boxes but I can't change the properties of the checkboxes (they say yes and no instead of true or false) and so the function I created to concatenate the repeating table filtered for true values isn't being populated.  I hope that made sense.

If you wanted the value attribute to have true/false values I have to wonder why you didn't put true/false values in the sample data.  Nonetheless, I admit that that probably wouldn't have helped in this situation.  You have two options here:

1. Filter the rows using yes/no values instead of true/false values.
2. Modify the secondary data source's schema to specify that the attribute should have a boolean value.

The first option is considerably simpler, but I can explain how to do the latter if you are interested.

 The latter was what I'm looking for actually.  I've tried filtering for yes values instead of true values and for some reason it's not populating the text box I need it to.  Although, I suppose that could have something to do with my formula.

I didn't put the true/false values in the data source simply because I'm not 100% on how.  This is project got dropped on me and I have no experience with XML.

Thanks

 Was this ever solved?

I'm looking for a similar  solution.

Thanks!

--mobrien118

You can save your form as source files and open the schema file for the secondary data source (.xsd -- depending on your secondary data source type, you may have to do a little looking to find the right one) in a text editor. Then, find the element you wish to change -- it will have the data type xsd:string. You can change that to xsd:boolean. You may also want to add the 'nil ' attribute to it by including nillable="true".

So, your element would change from:

< xsd:element name = "Warnings" type = "xsd:string" ></ xsd:element>

to:

< xsd:element name = "Warnings" type = "xsd:boolean" nillable = "true"></xsd:element>

As an example.