-
Hi - Add a field called Status or something and set it to Submitted when the form is first submitted. Then in your form load rules, you can switch views if Status is equal to submitted. Or if you have any required fields in your form, you can switch views in form load on those being populated....
-
Sorry to be slow getting back to you - what you want to do is going to require code. I guess I'd create the form bound to the DB table I want to submit to, then on form open or click of a button or whatever makes sense for your particular process, you'll need to use code to insert rows into the main data source (as many are present in your ...
-
In IP 2010 / 2013 - Under the data tab in the ribbon find the Default button. In the defaults, deselect the repeating group you do not wish to have appear in a new form.
For 2007 I think this option is under the Tools menu.
-
The only other thing I can think of is that the XML is a greater version number than the max version to upgrade in the manifest.xsf of the form - but since it works in preview that seems unlikely...
-
And the published form is opened in IP Filler? Any chance the cached form template is from before setting the upgrade settings?
-
Do you have access to the SharePoint server logs? If not, give your SharePoint admin the correlation ID - there will likely be additional info in the log file to let you know which connection is causing the issue and why.
-
I would download one of the existing XML files and save it locally. Then in the form options, under preview, I'd set the form to preview with that XML. That may help you troubleshoot. You can preview, then use File > Save As to save the XML you previewed with, then open the XML with notepad and verify the new node was added, for example. ...
-
Can you attach a screenshot of your data source (or the form itself) under the Options tab in a reply?
This is for IP 2003, but the same principles apply - perhaps take a look: http://office.microsoft.com/en-us/infopath-help/connect-a-form-to-a-database-RZ001187936.aspx
-
So, my guess is going to be that the template is not set to upgrade existing XML. Under Form Options / Versioning, make sure Update existing forms is set to Automatically upgrade existing forms.
-
In your email data connection, when you walk through the wizard, you can use a formula.
concat("ITDude@mycompany.com;", AccountID)
I think if you pick the AccountID from the data source in the People Picker, it will email - but you'll want to give it a test first. :)