InfoPath 2007 to SharePoint 2010 form [field] changes not saving - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

InfoPath 2007 to SharePoint 2010 form [field] changes not saving

Last post 07-07-2017 12:29 PM by Wheels. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 07-07-2017 08:31 AM

    InfoPath 2007 to SharePoint 2010 form [field] changes not saving

     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 

  • 07-07-2017 11:06 AM In reply to

    Re: InfoPath 2007 to SharePoint 2010 form [field] changes not saving

    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

  • 07-07-2017 11:31 AM In reply to

    Re: InfoPath 2007 to SharePoint 2010 form [field] changes not saving

    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...
    Hilary Stoupa

  • 07-07-2017 12:00 PM In reply to

    Re: InfoPath 2007 to SharePoint 2010 form [field] changes not saving

    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

  • 07-07-2017 12:13 PM In reply to

    Re: InfoPath 2007 to SharePoint 2010 form [field] changes not saving

    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!
    Hilary Stoupa

  • 07-07-2017 12:29 PM In reply to

    Re: InfoPath 2007 to SharePoint 2010 form [field] changes not saving

     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.

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.