How to Enable the Editing of InfoPath Form Fields in a Published SharePoint Library
Written By: Rahul Mehta -- 10/5/2010 --
(15) comments --
Categories: Configurations, InfoPath, MOSS 2007
InfoPath forms are used to perform business processes. Usually
we publish our InfoPath Forms to a Form Library in SharePoint.
There may be times when you need to edit SharePoint form fields that are
published to a SharePoint document library with InfoPath. By default, you will
not be able to. Read more to learn how to enable editing for these fields.
As an example, consider a site where there
are two libraries which maintain data about two different schools. Among school libraries,
they mostly share the same metadata structure like
student name, class, etc. But there are some fields like 'rollno'
which could be numeric or alphanumeric. In this case you may need to allow
users to change the data type.
By default, InfoPath published fields
do not allow editing of data types.
One can allow users to edit and update the metadata structure from the
form library, only if it is allowed when the form gets published to the
In this article, we will discuss how to enable field editing from the
I have created a sample basic student form with information like name,
rollno and age.
When published with the normal publishing wizard, you can see
in the below image that one cannot edit the form fields. (Notice the highlighted column
names are black. There is no link that would enable any modifications.)
In order to allow the field to be editable, we need to start the
form publishing wizard. Go to Form's File Menu>Publish. Follow the
wizard until it allows you to add properties.
Select the field you want to be editable and click on "Modify".
By default the "Allow users to edit data in this field by using a datasheet
or properties page" checkbox will be not be checked. Select it. On
selection, you will be prompted with an information box.
Assuming various functions indicated in the message are not needed, click OK and finish the publishing wizard.
Go back to the document library settings and you will see you can now edit the field.
This is the process to allow editing form fields from the publishing
Use this process to permit users to change the metadata in form
- Return to MSSharepointTips to read about other topics and ideas.
- Check out MSSQLTips.com for great information about Microsoft SQL Server.