-
You need to promote the field to the library, so that it is populated when you submit your form. Then that field is used to query the library to get back the ID.
-
When I look at the promoted properties in the template you attached, I don't see Form Name in the promoted properties.
-
Is the formName field in the form promoted to your library? It is weird, I don't see it in the promoted properties for the form. Drag your secondary data source onto the form and click your button and see if your query returns data.
-
You need to save the form locally (right click the link, and Save Target As). Then right click the downloaded form and select Design to open in InfoPath designer.
-
Here's a rough sample. Save the file attached locally. Right click the file and select Design to open in Design mode, from there you can preview & try it. :)
-
If this is a browser form, maybe set it filler temporarily and add popup dialogs in your rules so you can see the order of occurrence when you preview. :)
-
So, the rule on the field with the default that has the account id runs your query? I wonder about having another field, not on the form, that has a default to the display name. Put the rule that runs the query on that field instead (I'm assuming the account id changes, then the display name changes....) and don't run the query if the ...
-
The submit connection to the UpdateListItems web service will have parameters you can set for the list name, etc - you'll need a field in your form (or in another data source, I often add the field to the CAML xml file outside of the Batch node) to select when you set up the submit connection.
-
You really can't - but you can switch views on load, not show the view options in the menu and only use buttons that allow users to switch views, put information in sections that will hide if a user opens a view, etc. Keep in mind that if users have access to the XML files that the form creates, they can view all data from the main data source ...
-
Replying to "how can I write an absolute path" - see the attached screenshot. Use the full server path in this dialog, not "z:\shareddocs" or whatever but \\servername\shareddocs.