I have a SharePoint 2010 list that has been edited with InfoPath 2010.
One of the controls on the form is a Multiple Selection check box field. It has 17 options.
I have been trying to get the checked item values written to another TXT field but can't get it to work.
I have edited InfoPath forms for the web before (InfoPath Library) and was able to get the values from multiple selection controls using this formula:
substring(eval(eval([. != ""], 'concat(";", .)'), ".."), 2)
That works fine on forms that are created with InfoPath from the start but it does not work on lists that are edited with InfoPath.
It seems that the multiple selection control does not work the same way because the [.!=""] filter does not work on it.
When you try to apply a filter to the multiple selection control for a SP List you get an error once you click OK saying that this control does not support filtering.
Are there any solutions (codeless) to this problem?
Has anyone dealt with a situation like this before?