SharePoint 2013: October 2016

Introduction of Dataconnection and Data Source in Infopath form 2013

Let's find out what is Main Data source and what is secondary Data source, How to add a secondary data source, how these data connection are different by each other, and how to retrieve a reference to the Main data source or to an InfoPath secondary data source programatically.

Introduction to Dataconnection

In Infopath form Dataconnection is used to receive data from a Data Sources.

Introduction to data sources

In every Infopath form there are two types of data sources: Main and secondary data source. An InfoPath form template will always contain one Main data source and can contain zero or more secondary data sources.

What is the difference between the Main data souce and secondary data sources

Main data source of a Infopath form contains the data that you want to permanently store when you save the Infopath form. An secondary data source is a temp storage location for data that is external to the Infopath form. This data is placed outside of the form in databases, XML files, SharePoint lists or libraries, or can be retrieved from web services.

If you will save a form, the data in the secondary data sources of the form will never be saved in the form. This is an important fact to remember when you design InfoPath form templates. Thatsmean, if you wanted to store data in a form after you save, close, and re-open the form, you have to store this data in the Main data source of the form.

How to create data sources

A Main data source is automatically added to an form when you create a InfoPath form template. You can create or add a existing secondary data source to InfoPath by adding a Receive or Submit data connection to a form template. You can add an InfoPath data connection to a form template by going to the Tools menu and selecting Data Connections.

How to view data sources

You can use the Data Source task pane to view InfoPath Main and secondary data sources in a form template. If the Data Source task pane is not visible, click Data Source on the View menu to bring it up. The Data Source drop-down list box will contain the text Main for the Main InfoPath data source and an InfoPath data connection name followed by the text (Secondary) for a secondary data source

You can also refer to the following Post-

Dear Friends! If you like this Post Kindly comment below the post and Do share your responses. See more Post of this Blog or Ask me to Write on a Topic.

How to set values of dropdown field with different methods in Infopath designer 2013

DataSource (your DataSource should open up on the right side of the screen with folders, and fields - this is where your form controls actually store the data)
Click on your dropdown box on your form - this will select the datasource it is bound to in that screen on the right
Now double-click that datasource that is highlighted on the datasource screen on the right
The properties will open up - it should open up to the "Data" tab
On that Data tab you will see a Default Value Section
Enter the default value you want in the box next to "Value:"
Click "Ok"

Dear Friends! If you like this Post Kindly comment below the post and Do share your responses. See more Post of this Blog or Ask me to Write on a Topic.

Introduction to all the default function in infopath designer 2013

Dear Friends! If you like this Post Kindly comment below the post and Do share your responses. See more Post of this Blog or Ask me to Write on a Topic.

How to set default value or function for a field in infopath 2013 form

Learn how you can set the default value for an InfoPath 2010 date picker or InfoPath

Use the Default Value property if it is available.
Use an InfoPath Form Load rule.
Use a Set a field's value action rule.

However, because an InfoPath 2010 date picker stores only dates and an InfoPath 2010 date and time picker stores a date and time, you must use different InfoPath 2010 date and time functions to set their default values.

The following InfoPath 2010 tutorial video shows you how you can set an InfoPath 2010 date picker default value and an InfoPath 2010 date and time picker default value.

Dear Friends! If you like this Post Kindly comment below the post and Do share your responses. See more Post of this Blog or Ask me to Write on a Topic.