InfoPath Dev

 Good morning.

I have a InfoPath 2007 form writing to a SharePoint 2010 custom list. Basically I am trying to accomplish the following:

• Users complete the fields in the form then click submit.
• This sends the form contents to the SharePoint site, queries the site for the ID (and populates the ID field with this #), sends and email to a DL, closes the form, and opens a new form.

What I am trying to do is to have the ID (which is unavailable during the initial submit) saved on the form in SharePoint. If I go into the form and make any changes, it prompts me to save, and if I click Yes, OK, etc., it saves the changes. I had hoped the Close the Form feature would work the same way (but without the save prompt).

I would prefer not to use code (C#, etc.) if possible. Any suggestions? 

Have a great day, WHEELS 

UPDATE: I created a workaround (there's got to be a better way) where the form submits to SharePoint for the second time before it closes with the ID field populated. I created a field (FormName) to store a concatenation of several fields and the DateTime. This way each Data Connection can read the FormName field and use it as the filename, and I set it to overwrite with same filename.  It seems to work, but less than ideal. WHEELS

So - you do have to submit twice to get the actual library ID and then store it in the form. Your approach is probably the same as I would have taken. Is the submitted form re-opened and submitted again at any point? Make sure the logic for the first submit only runs when the ID field is blank...

Good afternoon Hilary. I hope things are well at Qdabra, and in your world. If I am understanding your question, the initial form is submitted, ID added, and resubmitted before closing. Then while in SharePoint others may open the form, make some changes, and when they close it will prompt them to save. The form is never resubmitted after the initial (2) SharePoint submissions. Great advice on the blank ID field. WHEELS

Got it - so if they only ever submit when the form is first created, you don't need to add conditions in this specific case, because they would never apply. :) But yeah, you have found the right way to do this - there isn't really a more graceful way about it. Have a great weekend!

 You too Hilary. I am really looking forward to the new InfoPath replacement (heard support was extended until 2026), and I have expressed my interest as a Qdabra beta tester.