Add, remove, or modify form library columns on a SharePoint site - InfoPath

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Add, remove, or modify form library columns on a SharePoint site

When you design a Microsoft Office InfoPath 2003 form, you can specify whether or not you want data from specific fields in the form to appear as columns in the default view of a form library (form library: A folder in which a collection of forms based on the same template is stored and shared. Each form in a form library is associated with user-defined information that is displayed in the content listing for that library.) on a Microsoft Windows SharePoint Services site. You can do this when you design your form, or you can wait until you publish the form to the form library.

In design mode, open the form template for which you want to specify form library columns.
Do one of the following:

Show Specify form library columns when designing a form

In design mode, click Form Options on the Tools menu, and then click the Form Library Columns tab.
Do one of the following:
- To add a column, click Add, click the field or repeating group for which you want to create a column, and then type a name for the column in the Column name box.
  Tip
  If you click a repeating field, you can define how you want to display data from the field in the form library by clicking a value in the Choose a function to use on repeating data box.
  You can choose whether to display the first value in the field, the last value, a count of all occurrences of the field, or whether to merge all of the values together.
- To remove a column, click the column in the list, and then click Remove.
- To modify a column, click the column in the list, click Modify, and then make the appropriate changes.

Show Specify form library columns when publishing a form

In design mode, click Publish on the File menu.
On the first page of the Publishing Wizard, click Next.
Under Where do you want to publish this form, click To a SharePoint form library, and then click Next.
Under Do you want to, click Create a new form library (recommended), and then click Next.
In the Enter the location of your SharePoint site box, enter the address of the Windows SharePoint Services site.
In the Name and Description boxes, type a name and description for the form.
Note The name and description of the form will appear on the default view of the form library.
Do one of the following:
- To add a column, click Add, click the field or repeating group for which you want to create a column, and then type a name for the column in the Column name box.
- To remove a column, click the column in the list, and then click Remove.
- To modify a column, click the column in the list, click Modify, and then make the appropriate changes.
To finish the wizard, click Finish.

Note Depending on the form and the way that the form library is set up, fields in form library columns on the Windows SharePoint Services site may display both data stored within the form and properties of the form itself.