Submit form data to a SharePoint library

You can store and organize all of your users' forms in a document library on a server that is running Microsoft Windows SharePoint Services. In the document library, users can fill out forms that are based on your form template, export data from completed forms to Microsoft Office Excel 2003 or Microsoft Office Excel 2007, or merge the data from several forms into one form.

To allow users to submit forms that are based on your form template to a document library, you can add a secondary data connection to your form template that submits the data. After you add the submit data connection, you can configure the form template to allow your users to submit their form data to the document library. When you do so, Microsoft Office InfoPath adds a Submit button to the Standard toolbar and a Submit command to the File menu on the form. You can also customize the submit options for your form template in the following ways:

  • Change the text that appears on the Submit button on the Standard toolbar and the Submit command on the File menu.
  • Change the keyboard shortcut for the Submit button on the Standard toolbar and the Submit command on the File menu.
  • Create custom messages to display to your users when they submit their forms.
  • Specify whether to leave the form open, close the form, or open another blank form after the form is submitted.

Add a submit data connection

  1. On the Tools menu, click Submit Options.
  1. In the Submit Options dialog box, select the Allow users to submit this form check box.
  1. Click Send form data to a single destination, and then click SharePoint document library in the list.
  2. Click Add.
  3. In the Data Connection Wizard, in the Document library box, type the location of the SharePoint document library.
  4. In the File name box, type a name that will be used to identify the form in the document library.

 Tip   You can also use a formula to ensure that each form name is unique.

ShowHow?

  1. Click Insert Formula Button image.
  1. In the Insert Formula dialog box, do one of the following:
    • To use a field in the formula, click Insert Field or Group, click the field that you want to use in the Select a Field or Group dialog box, and then click OK.
    • To use a function in the formula, click Insert Function, select the function that you want to use in the Insert Function dialog box, and then click OK.

 Tip   If the function requires parameters, select the function in the Insert Function dialog box, click OK, and then in the Formula box in the Insert Formula dialog box, double-click the function that you added, and click a field or group. Find links to more information about functions in the See Also section.

  • To insert a value or mathematical operator into the formula, type the value or the symbol for the mathematical operation in the Formula box.
Operation Symbol
Add +
Subtract -
Multiply *
Divide /
  •  Note   If your formula uses the division (/) operator, make sure that there is a space before and after the division operator. If the division operator does not have a space before and after it, InfoPath may interpret "/" as a separator for XPath location steps rather than as a division operator.

  1. To check the formula for the correct syntax, in the Insert Formula dialog box, click Verify Formula.

Find links to more information about formulas in the See Also section.

  1. To overwrite any existing forms with the same name in the document library, select the Allow overwrite if file exists check box.
  2. Click Next.
  3. On the next page of the wizard, in the Enter a name for this data connection box, type a descriptive name for this submit data connection.
  1. Verify that the information is correct in the Summary section, and then click Finish.

To change the name of the Submit button that appears on the Standard toolbar and the Submit command that appears on the File menu when users fill out the form, type the new name in the Caption box in the Submit Options dialog box.

 Tip   If you want to assign a keyboard shortcut to this button and command, type an ampersand (&) before the character that you want to use as a keyboard shortcut. For example, to assign ALT+B as the keyboard shortcut for the Submit button and command, type Su&bmit.

  1. If you do not want people to use a Submit command or the Submit button on the Standard toolbar when they fill out your form, clear the Show the Submit menu item and the Submit toolbar button check box.

By default, after users submit a form, InfoPath keeps the form open and displays a message to indicate if the form was successfully submitted. To change this default behavior, click Advanced, and then do one of the following:

  • To close the form or create a new blank form after the user submits a completed form, click the option that you want in the After submit list.
  • To create a custom message to indicate if the form was successfully submitted, select the Use custom messages check box, and then type your messages in the On success and On failure boxes.

 Tip   Use a message in the On failure box to tell users what to do if they cannot submit their form. For example, you can suggest that users save their form and contact someone for further instructions.

  • If you do not want to display a message after the user submits a form, clear the Show success and failure messages check box.

Top of Page Top of Page

 
 
Applies to:
InfoPath 2007