I am working with InfoPath form data that is then submitted to a SharePoint library and properties from the form are promoted to columns on SP. Nearly every field in the form consists of check boxes (True/False). For example
Form: Column in Sharepoint Estimate Check box for Small Estimate_Small: True OR False Check box for Medium Estimate_Medium:True OR False Check box for Large Estimate_Large: True OR False
Now realizing the error of my ways, I should have designed the form with one multi-choice list box or something to that effect. However, at this point I'm at trying to merge the columns together easily to where the SP columns will be merged into one column listing Small, Medium, and Large.
Does any have any thoughts on how this could be accomplished programmatically?