InfoPath Dev

Hi, Good day. I just want to inquire if the SharePoint List Tool (mapping tool) has the ability to map fields but trimming the value using a formula? For example, I have a field called "Order" which exceeds 255 characters so I want to trim the value like substring(fieldname, 1, 255) so that if the SubmitToSharePointList command is ...

As best as I can determine, this happens when we add formatting to a calculated value - the binding gets added to the view & has to be manually removed. If you need a hand after you finish your calc'd values, just attach the form to another reply & I'll help you fix it up.

 Hilary you rock! I have to add some more calculated values, is there something I should avoid doing so I don't run into the issue again?

 Hopefully this fixes that up - InfoPath generally seems to do this when formatting is set on the calc'd value & the only real work around I've found is to manually clean up the view.

Hi Hilary,   please find it attached 

http://www.infopathdev.com/blogs/hilary/archive/2012/01/19/ipfs-design-checker-errors-amp-print-preview.aspx This is an error in IPFS - basically, sometimes InfoPath will add binding info to the view for a calculated value that causes an issue when publishing. You can manually remove this info from the view files. Attach your template under the ...

 Hi Hilary,   I got the calculated value formulas working along with the preceding-sibling.   An issue I have now is that it is giving me an error when trying to publish " Binding a non repeating control to a repeating field or group is not supported in InfoPath 2010 Web Browser Forms"   do you ...

 Hi Hillary,   I am having trouble with the xpath creating a calulated value formula. do you know how I can basically recreate the below:  count(Vertical_x002f_Charter[Title = current()/Title]) I am attempting to count the list of project names(Vertical_x002f_Charter) in a 3rd data connection where the project name = current ...

 It took a day and a half; but, I finally figured it out. Thank you InfoDev team.!

 My sample has both tables bound to the main data source simply to make it easy for someone to preview, etc. The same techniques work regardless of the data source. I'm attaching another sample that uses a secondary (XML) data source - it originally was to demonstrate a different technique, but I made a minor modification to hopefully ...