-
Excellent! So glad you have it doing what you need. :)
-
I'm not being clear enough.
Here is what I would do if this were my form.
I would:
Add a new receive data connection to my form using the data connection wizard. This would connect to an XML file. For the location, I would put in the URL of an XML that is the created by the form that you want to copy data from. I would set the ...
-
Well, first simply add an XML data connection to an existing file in the library - is that where you started? Are you having permissions issues just creating a data connection to an existing XML in the library?
-
But is custom code ok? You can do this with code....you need to change the connection URL for the XML file then query it.
-
I've not used any SOAP Excel Services, I'm afraid, only REST. But I would recommend you download and install Fiddler. Then you can open Fiddler while testing your form in filler or preview, and examine the actual request the form is making and the response you are getting. This helps me all the time when I am struggling with some obscure ...
-
I guess I would try to reproduce with a test form. I'm not sure what you mean by "save as draft" - is this some functionality you've added to the form? A library submit connection? Just using the Save button in the ribbon?
-
Take a look at this and see if it might do what you need: http://blogs.msdn.com/b/infopath/archive/2010/06/03/how-to-pass-querystring-data-into-an-infopath-form.aspx
It involves having the form in a web part in SharePoint, but allows you pass in a query string parameter w/out code....
-
I should add - see how you don't have the "my:" namespace prefix on FineCounts? Could that be your issue? I guess IP's formula editor probably would have caught that tho.
-
You should be able to attach it under the Options tab in a reply.
-
Is group8 your repeating group? And field16 contains the description? And this is a default value on the price field which is in the same repeating group as field16
If so, you want this:
xdXDocument:GetDOM("Consumables")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:cPrice[../d:Description = current()/../my:field16]
If ...