The other day one of our clients requested a massive form, I think I count 500 controls. I have never been a huge fan of InfoPath, mainly because every time I use it, becomes a little bit tricky. The client always wants to go to the extra mille, so you end building a web part and leaving the InfoPath form away.
In this case, I knew that a 500 controls form will take me months to build, so I decided the only way, was InfoPath. The requirements were simple, keep the form, and keep the data, so the client could attach a Business Intelligence process behind the results.
The tricky part for me was to create the connection and the content type for it, but as soon as you know how to do it, it is a piece of cake. Right here we go… a step by step:
- Open InfoPath 2010.
- Select “SharePoint Form Library->Design Form”.
- Design your form.
- Publish your form to be sure it is ok.
- Go to “File->Publish->Sharepoint Server”.
- A Wizard like this will be opened:
- Enter the site and the Document Library where the form is kept.
- Leave this form as it is and click next.
- Now, select “Update the form template in an existing form library”, and select the library where you are keeping the forms.
Click on Finish!
Job done!, now, everytime you submit a new form it will be saved in the “Document Library” as a file (with all the data inside) and it will save the data in the columns, so you can interrogate them from any source.