SharePoint Himadrish

Welcome back!

In part 1 of the article we have discussed how to create and design the InfoPath form. We also see the detailed steps how to implement client side validation and rule into the InfoPath form.

In part 2, we have gone through the steps by which we can create data base connectivity with InfoPath form, and the different gateway through which a InfoPath form can connect with other system.

In this article we will focus on how to integrate table filed with InfoPath control and the associated detail steps.

How to map InfoPath form control with database table column:

Select any control in the InfoPath form and double click on this. It will open the properties window for the field. Select the Data Connection combo list and select your data connection.

InfoPath Field properties

Next, click on Entries button   and you will have option to choose data filed. Select the required field and click OK.

InfoPath Field mapping

 
There are two more entries, Value and Display Name, which basically auto populated.

Let me explain one thing over here. In most of the cases, in the database table, we basically keep ID against employee name or any other object where ID is the primary key. So for those cases, select ID in the Value text filed and Employee or other object name in Display name field. That’s all you integrate your table data with InfoPath. 

How to submit InfoPath forms:

To submit the InfoPath form, click on Tools >Submitting Forms. There are also other ways by which you can also submit InfoPath form data. You can place the submit button within the form and double click on the submit button to open the submit integration window in InfoPath.

Submitting Form wizard in InfoPath

Again this form is self explanatory. You need to choose ‘Enable Submit commands and buttons‘ and there will be options where you can submit your form data. You can choose Database, web service, E-mail, SharePoint list form library etc.

Let’s select Database and click on Submit Options. Next screen, you will have some GUI perspective condition and you can easily make this process complete.

InfoPath Submit option form

Another thing you need to do is to create database connection to submit the forms data i.e. Tools > Data Connection >Add >

Form submission in InfoPath

 

Select To a SharePoint form library and then finish these steps. 

Submit infoPath to SharePoint

 

In the part 4, the final part of this series, we will see how to host the InfoPath application on SharePoint portal, and how SharePoint communicate through .xsn file with SharePoint.

Good luck and happy reading!