-
What's the data source look like for your form?
I am guessing the issue is that in IP we can't use rules to insert a new instance in a field in our data source. There are a couple ways to deal with this limitation.
Custom Code - write code to insert a new instance of the target field and set the value
qRules - use rules to insert ...
-
Here's a link to a document with a how-to - give it a try and if you have trouble, post back so I can give you a hand.
-
I think I'd create a view or something that created a unique display name - like C - Bob@xxxx
-
Wow - that's nutty. Feel free to attach the form under the Options tab if you'd like - I'd love to take a look at it.
-
My guess would be some wayward code or rule setting the field's value on change. Have you taken a look in the rule inspector?
-
Does the URL you are using work in the browser? That is, if you paste the URL in your browser's address bar, do you get an XML file (or display of XML) in return?
-
What version of SharePoint are you using? If you are using SharePoint 2010, I wonder if an OData data connection would return these -- If you are using SharePoint 2007, you might be able to use an owssvr.dll connection.
-
Since you have a dev team, you'd just need to let them know you need an EXE that can read an Excel workbook and generate XML for each row - Or, I suppose they could use VBA in Excel and add it as a macro to the workbook...
-
Wow - at first I was thinking that 2,000 must be a typo.... but it looks like it isn't & that the restrictions weren't based on column types in 2007 (per http://technet.microsoft.com/en-us/library/cc262787(v=office.12).aspx) and in 2010, they are. Are the data types correct on all of these? That is, they are all single lines of text? ...
-
The time format is actually hh:mm:ss. Save an XML file from your form and open in a text editor to see the real value of the field, or right click your text box (in design mode), select properties, click the format button, and select the None (display XML value) so you can see the actual value... When you retype it, IP is adding the :00 for the ...