InfoPath 2010 Tutorial Videos

Watch these InfoPath 2010 tutorial videos to learn how to use InfoPath Designer 2010 to create electronic forms for InfoPath Filler 2010 and SharePoint 2010.

InfoPath Basics

What is InfoPath Filler 2010

In this InfoPath 2010 tutorial you will learn what InfoPath Filler 2010 is, what the difference is between InfoPath Filler and Designer, and how to open either application.

What is an InfoPath browser form?

Learn what an InfoPath browser form is and how InfoPath 2010 forms can be used in SharePoint 2010.

What is InfoPath 2010 form load?

In this InfoPath 2010 tutorial video you will learn what Form Load is and where you can add Form Load rules to an InfoPath 2010 form.

InfoPath 2010 present vs. not blank in rules

Learn what the difference is between present and not blank when used in conditions on rules in InfoPath 2010.

InfoPath 2010 views and page layout templates

Learn how InfoPath 2010 page layout templates behave when you add page breaks between them on InfoPath 2010 views.

InfoPath 2010 switch views with tabs

Learn how you can use rules and conditional formatting in InfoPath 2010 to create a tabbed interface that can be used to switch between views of the InfoPath form.

InfoPath 2010 conditional formatting

In this InfoPath 2010 tutorial you will learn how to add InfoPath 2010 conditional formatting and how to combine multiple expressions into one condition on an InfoPath 2010 formatting rule.

2 Ways to make a field required in InfoPath 2010

In this InfoPath 2010 video tutorial you will learn two ways to make an InfoPath field required and when it makes sense to use each method.

InfoPath 2010 functions within functions in a formula

Learn how you can use the translate and substring functions within the concat function to capitalize the first character of a string.

InfoPath 2010 resource files

Learn how to add and use resource files in InfoPath 2010.

InfoPath 2010 merge forms

In this InfoPath 2010 tutorial video you will learn how to use the InfoPath 2010 merge forms functionality in InfoPath Filler 2010 to merge multiple forms into one form.

Testing forms in InfoPath 2010

In this InfoPath 2010 tutorial video you will learn how to test InfoPath forms by setting sample data for previewing forms to prepopulate an InfoPath form for testing purposes.

InfoPath 2010 export source files

Learn how you can in InfoPath 2010 export source files to extract form files from an InfoPath form template.

What is Copy XPath in InfoPath 2010?

Learn what Copy XPath is in InfoPath 2010 and in which situations you can make use of it.

Copy InfoPath control from one form template to another

Learn how you can copy a control from one InfoPath 2010 form template to another and then bind the control to a field in the Main data source of the new form template.

Publish InfoPath 2010 form as PDF without code

Learn how you can use InfoPath Filler 2010 to save an InfoPath 2010 form as a PDF file without having to write code.

InfoPath 2010 validation rules

Validate phone number in InfoPath

Learn how to use a regular expression to validate a phone number in InfoPath 2010.

Controls in InfoPath

Hide a field in InfoPath 2010

Learn how to in InfoPath 2010 hide a field by using one of the most common methods to hide controls in InfoPath 2010.

Resize a control in InfoPath 2010

In this InfoPath 2010 tutorial video you will learn how you can make a control on an InfoPath form resize dynamically within a layout table or assume a fixed width.

Buttons

Add a picture button with images in InfoPath 2010

Learn two ways to add a picture button with its corresponding images to an InfoPath form template and what the difference is between these two methods.

Add an image to a page layout header in InfoPath 2010

In this InfoPath 2010 tutorial you will learn a trick to misuse a picture button in InfoPath 2010 to add an image to the header of a page layout table.

Restore an InfoPath 2010 button to its original style

In this InfoPath 2010 tutorial you will learn how you can quickly restore a button to its original display settings for style and formatting in InfoPath 2010.

Calculated Value controls

Dynamically append text to a label in InfoPath 2010

Learn how to dynamically append text to a label on an InfoPath form by using a read-only control and a rule.

Date Pickers

InfoPath 2010 date picker default value

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

InfoPath 2010 date picker with only future dates allowed

Learn how you can use InfoPath data validation rules to allow only future dates to be selected from an InfoPath date picker and InfoPath 2010 date and time picker.

Dates and time zones in InfoPath 2010

Learn how you can use a date and time picker control in InfoPath 2010 to specify time zone information for dates.

InfoPath substring-after and substring-before functions

Learn how you can use the substring-after and substring-before functions in InfoPath 2010 to extract a date and time from a datetime string.

File Attachments

InfoPath file attachment control

In this InfoPath 2010 tutorial video you will learn where InfoPath 2010 stores attachments when you attach a file to an InfoPath form.

Copy file between InfoPath file attachment controls

Learn how you can use rules to copy or move a file that is stored in a file attachment control on an InfoPath form to another file attachment control on the same form.

Pictures

Change an image on an InfoPath form by selecting options

Learn how you can use rules (no code) to select and change the image stored in a picture control on an InfoPath 2010 form through option button selections.

Hyperlinks

2 Ways to add and display a hyperlink in InfoPath 2010

Learn two ways you can add and configure a hyperlink on an InfoPath form.

List Boxes

Copy text from a list box to a text box in InfoPath 2010

In this InfoPath 2010 tutorial you will learn how to use rules and filters to lookup the name of an item in an external data source used to populate a list box control, and copy the item's text to a text box control.

Dependent drop down lists with disappearing items

In this InfoPath 2010 tutorial you will learn how to create InfoPath dependent drop down lists where items can only be selected once from a group of drop-down list boxes on an InfoPath 2010 form.

InfoPath combo box control

Learn what an InfoPath combo box control is and how it works.

Master Detail

InfoPath 2010 master detail example

This article shows an InfoPath 2010 master detail example that makes use of an InfoPath master detail control to present data that has a one-to-many relationship.

Repeating Tables

What is InfoPath repeating table

In this InfoPath 2010 tutorial you will learn what an InfoPath repeating table is and how an InfoPath repeating table works.

Repeating table vs. repeating section in InfoPath

Learn what the difference is between a repeating table and a repeating section in InfoPath 2010.

Hide a column in a repeating table in InfoPath 2010

See how you can hide a column in an InfoPath 2010 repeating table using rules and a toggle button on a form.

InfoPath sum function to calculate repeating table sum

In this InfoPath 2010 tutorial video you will learn two ways to calculate the sum of multiple fields in InfoPath using the InfoPath sum function in a repeating table.

InfoPath repeating table sum

In this InfoPath 2010 tutorial video you will learn how to calculate the sum of two different repeating tables in InfoPath 2010.

InfoPath 2010 running total sum in repeating table

Learn how you can use the sum function and preceding XPath axis in formulas to create a running total calculation in a repeating table on an InfoPath 2010 form.

Highlight rows of a repeating table in InfoPath 2010

In this InfoPath 2010 tutorial you will learn how to use conditional formatting to highlight rows in a repeating table based on a text string that is typed into a text box.

InfoPath avg function in repeating table

In this InfoPath 2010 video you will learn how you can use the InfoPath avg function in a repeating table to create functionality similar to that of the InfoPath Application Rating sample form.

InfoPath 'Control cannot repeat here' message

Learn why InfoPath displays the message 'Control cannot repeat here' and how you can get the rid of that message if you want to display and not store data in a repeating table on an InfoPath form.

Add people picker to repeating table in InfoPath 2010

Learn how you can add a person/group picker or people picker control to a repeating table control on an InfoPath 2010 form.

Display part of a repeating table in InfoPath 2010

Learn how you can use conditional formatting in InfoPath 2010 to hide part of a repeating table on an InfoPath form.

InfoPath 2010 repeating table validation for unique values

Learn how you can add data validation to a drop-down list box in a repeating table on an InfoPath 2010 form to prevent duplicate values from being selected.

Sections

InfoPath choice section and choice group controls

In this InfoPath 2010 tutorial video you will learn what InfoPath choice section and choice group controls are and how they work.

Integrating InfoPath with Other Applications

SharePoint

Add InfoPath image as attachment to SharePoint list item

Learn how you can use the Lists web service in SharePoint to add an image from a Picture control on an InfoPath form to a SharePoint list item without having to write code.

Filter SharePoint list on dates in InfoPath 2010

Learn how you can use rules to filter items from a SharePoint tasks list to display only those tasks that lie between two dates in a repeating table on an InfoPath 2010 form.

Submit InfoPath forms to a SharePoint document library

Learn how you can configure an InfoPath form template so that it can be used to create InfoPath forms that can be submitted to a SharePoint document library instead of a SharePoint form library.

Start version control on InfoPath forms submitted on SharePoint 2010

Learn how to enable versioning on a SharePoint form library and apply version control to InfoPath forms that are saved or submitted on SharePoint 2010.

SharePoint Designer

Create a SharePoint Designer workflow for InfoPath forms

Learn how you can create a simple SharePoint Designer 2010 workflow that runs and creates new SharePoint list items whenever InfoPath 2010 forms are saved or submitted to a SharePoint 2010 form library.

SharePoint Designer workflow to lookup manager of manager for InfoPath people picker

Learn how you can create a SharePoint Designer 2010 workflow that can lookup the manager of the manager of a user that is entered into a people picker control on an InfoPath 2010 form.

Excel

Display Excel 2010 data in InfoPath 2010

In this InfoPath 2010 tutorial you will learn how you can convert an Excel file into an XML file and then use that XML file in InfoPath 2010 to display data from Excel.

Import InfoPath 2010 data into Excel 2010

Learn how to import InfoPath data into Excel 2010 by connecting an InfoPath form as an XML data source to an Excel spreadsheet.

SQL Server

2 Ways to connect InfoPath to SQL Server 2012 Express

Learn two ways in which you can connect an InfoPath 2010 form to a SQL Server 2012 Express database.

Connect InfoPath master detail to SQL Server Express

Learn how you can connect a master-detail control on an InfoPath 2010 form to two SQL Server 2012 Express database tables that have a one-to-many relationship between them.

Miscellaneous solutions

InfoPath format date function (Part 1)

See how you can use normal date formats such as for example 'MMMM d, yyyy' to format dates in InfoPath.

InfoPath format date function (Part 2)

Learn how to use an XPath function to format a date in InfoPath 2010.

 

InfoPath Demo Videos

InfoPath solutions

Dates in InfoPath repeating table without weekends

In this InfoPath 2010 demo you will see how you can automatically populate a repeating table control on an InfoPath 2010 form with dates that are sequentially incremented thereby skipping any dates that fall in weekends.

Cascading drop down lists in an InfoPath repeating table

This InfoPath demo is the completed solution for recipe 99 of InfoPath 2010 Cookbook in which drop down list boxes have been placed within an InfoPath repeating table.

Make InfoPath attachment read-only

This InfoPath demo is the completed solution for recipe 79 of InfoPath 2010 Cookbook in which an InfoPath attachment is made read-only by selecting a check box.

InfoPath print view text on image overlay

This InfoPath demo is the completed solution for recipe 16 of InfoPath 2010 Cookbook in which text filled out on an InfoPath form is printed on an image through a print view.

InfoPath date and time picker with time drop-down list

This InfoPath demo is the completed solution for recipe 67 of InfoPath 2010 Cookbook in which a drop down list box is used to select time for an InfoPath date and time picker control.

Show / hide section on time of day

In this InfoPath 2010 demo you will see how you can display the current time on an InfoPath form and have a section shown or hidden based on the current time of the day.

Use an InfoPath form to perform CRUD actions on an Access table with Memo field

In this InfoPath demo video you will see how you can use an InfoPath form to add, edit, and delete records in a Microsoft Access database table that has a Memo field.

Import InfoPath data into Access database tables

Watch a demo video of how you can import data from InfoPath form fields into one or more tables in a Microsoft Access database.

Sales Report InfoPath 2010 template

Watch a demonstration of codeless InfoPath techniques that are contained in an InfoPath 2010 form that can serve as a sales report.

Default to Monday in the current week in InfoPath 2010

Watch this InfoPath demo of how you can create a codeless InfoPath form template with a date picker control that always displays a date that corresponds to the Monday in the current week no matter which day is selected from the date picker control.

Make an InfoPath repeating table display pages of rows

Watch a demonstration of a solution where users can page through rows of a repeating table on an InfoPath form using previous and next buttons.

InfoPath forms in SharePoint

Convert InfoPath form to Word via SharePoint

In this InfoPath demo video you will see how you can use a codeless InfoPath 2010 form and a SharePoint Designer 2010 workflow to create a Word 2010 document and store it in a SharePoint document library.

InfoPath SharePoint Search form

In this InfoPath demo video you will see how you can use a codeless InfoPath 2010 form and SharePoint Search to search for InfoPath forms or documents in a SharePoint form library.

Create InfoPath form through SharePoint Designer 2010 workflow

In this InfoPath demo video you will see how you can use a codeless InfoPath 2010 form and SharePoint Search to search for InfoPath forms or documents in a SharePoint form library.

Link InfoPath form to Excel in SharePoint 2010

In this InfoPath demo video you will see an InfoPath form linked to Excel in SharePoint 2010 can send data to from InfoPath to Excel to update a chart or perform calculations.

Calculate business days between two dates excluding holidays using Excel Services

In this InfoPath demo video you will see how you can take a codeless InfoPath browser form and call Excel Services in SharePoint 2010 to calculate the amount of business days between two dates excluding holidays and weekends.

Add event to SharePoint calendar through InfoPath 2010

In this InfoPath demo video you will see an InfoPath form used to add an event to a SharePoint calendar and that has the ability to check for overlapping events before adding the item to the SharePoint 2010 calendar.

Connect SharePoint form library form to SharePoint list form through SharePoint web part connections

In this InfoPath demo video you will see how a SharePoint form library form can send data to a SharePoint list form by using the send data to web part functionality in InfoPath.

Extract emails from people picker in InfoPath 2010

In this InfoPath demo video you will see how you can get email addresses from an InfoPath 2010 people picker control for a selected group of users.

Display Access 2010 data in an InfoPath 2010 browser form

In this InfoPath demo video you will see an InfoPath browser form in SharePoint linked to and retrieving data from a Microsoft Access database through a data connection and InfoPath repeating table.

Submit/retrieve an entire InfoPath form to/from SQL Server

In this InfoPath demo video you will see how you can use a web service to submit or retrieve entire InfoPath 2010 forms to or from SQL Server 2008.

Auto-number InfoPath forms in a SharePoint form library

In this InfoPath demo video you will see how you can use a SharePoint event receiver on a SharePoint form library to automatically number InfoPath forms that are submitted to the SharePoint form library.

Use an InfoPath form and SharePoint Designer workflow to send an email with attachments

In this InfoPath demo video you will see how you can use a custom workflow activity in a SharePoint Designer 2010 workflow to extract data and attachments from an InfoPath form that is submitted to a SharePoint form library, send an email with attachments, upload the attachments as documents to a SharePoint document library, and include a link to the InfoPath form in the email.

Convert an InfoPath form to Word and PDF in SharePoint 2010

In this InfoPath demo video you will see how you can use Word Automation Services in SharePoint 2010 to convert a Word document that has been automatically generated based on data from an InfoPath 2010 form into a PDF document.

SharePoint Designer workflow to switch InfoPath views

In this InfoPath 2010 demo you will see how you can use a SharePoint Designer 2010 workflow to set the startup view in an InfoPath 2010 form.

Use an InfoPath form to add a recurring all day event to a SharePoint calendar

In this InfoPath demo video you will see how you can use an InfoPath form to submit and add a normal event, an all-day event, a recurring event, and a recurring all-day event to a SharePoint 2010 calendar.

Submit an InfoPath form to a web service and then retrieve return values

In this InfoPath demo video you will see how you can submit InfoPath form data to a web service and then retrieve and display any values that the web service sends back to the InfoPath form after it has been submitted.

Select and add files from a document library as attachments to a form

In this InfoPath demo video you will see how you can use an InfoPath form to download a file from a SharePoint document library and add it as an attachment to the InfoPath form.

Pass values between InfoPath forms

In this InfoPath 2010 demo you will see how you can open an InfoPath browser form from within another InfoPath browser form and pass data or values between the InfoPath forms.

Pass repeating table data between InfoPath browser forms in SharePoint

Watch a demonstration of copying data between repeating tables on two different InfoPath forms that are embedded in a page in SharePoint 2010.

Bulk delete SharePoint list items via an InfoPath 2010 form

Watch a demonstration of how you can use an InfoPath 2010 browser form to delete multiple items from a SharePoint list at once.

Cascading drop-down lists with a repeating table using SharePoint lists

This InfoPath demo video shows you how you can use two linked SharePoint lists and two normal SharePoint lists to connect two drop-down list boxes and one repeating table in a dependent manner for a cascading effect.

Use a SharePoint list for a shrinking list in an InfoPath repeating table

See an InfoPath demo of how you can use a SharePoint list to populate a drop-down list box in a repeating table on an InfoPath form and then have items disappear from the list whenever a new row with a newly selected item is added to the repeating table.

Cascading multiple-selection list boxes in InfoPath 2010

See an InfoPath demo of how you can use a SharePoint list to populate two multiple-selection list boxes on an InfoPath form and then have cascading or dependent functionality between the items displayed in the multi-select list boxes.

Silverlight chart to display InfoPath data in SharePoint

See a demonstration of how you can use Silverlight in SharePoint 2010 to visualize and analyze data that is stored in one or more InfoPath forms stored in a SharePoint form library.

Converting browser-enabled forms to PDF or HTML in SharePoint

Learn which options are available when it comes to converting or saving an InfoPath browser form to HTML or PDF within SharePoint.

Create an Excel 2010 spreadsheet from InfoPath repeating table data in SharePoint

Learn how you can go about writing code that takes data from a repeating table on an InfoPath 2010 form, creates an Excel 2010 spreadsheet using this data, and then finally saves the Excel workbook in a SharePoint 2010 document library.

Submit SharePoint List form values to a new Excel workbook

See a demonstration of how you can use a SharePoint List form to create a new Excel workbook that contains the values that were entered into the SharePoint List form and then store the Excel workbook in a SharePoint document library.

Send an entire repeating table to Excel

See a demonstration of how you can send data from rows of a repeating table control on an InfoPath form to an Excel workbook that is stored in a SharePoint document library.

Add the URL of a form as a link to an Excel workbook from within InfoPath

See a demonstration of how you can use Excel Services to add a link to an existing InfoPath form to an Excel workbook from within the InfoPath form itself.

Add a new row to an Excel table from within InfoPath

See a demonstration of how you can use an InfoPath form to add a new row or record to an Excel table in a workbook that is stored in a SharePoint document library.

Perform exact and wildcard searches in an Excel table from within InfoPath

See a demonstration of how you can use an InfoPath form to search for a particular item in an Excel table in a workbook that is stored in a SharePoint document library.

Update an Excel chart on an InfoPath form

See a demonstration of how you can display a chart from an Excel workbook on an InfoPath form and then enter data on the InfoPath form and dynamically update the Excel chart on the form.

Get data from an Excel workbook attached to an InfoPath form

See a demonstration of how you can use an InfoPath form to add a new row or record to an Excel table in a workbook that is stored in a SharePoint document library.

Attach any file to a SharePoint list item using InfoPath

This InfoPath 2010 video is a demonstration of using a file attachment control on an InfoPath form to upload and attach any type of file to a SharePoint list item.

Create a folder in a SharePoint document library via an InfoPath form (no code)

Watch a demonstration of how you can use an InfoPath 2010 browser form to create a new folder in a SharePoint document library without having to write code.

Display SharePoint users in an InfoPath multi-select list

Watch a demonstration of how you can use a multiple-selection list box control on an InfoPath 2010 form that is filled out through the browser to display users from a particular SharePoint 2010 group.

Run a SharePoint 3-state workflow on an InfoPath form

Watch a demonstration of how you can run a three-state workflow on an InfoPath form thereby setting the status of the SharePoint workflow either through the completion of SharePoint tasks or from within the InfoPath form itself.

SharePoint list lookup in an InfoPath repeating table

Watch a demonstration of how you can use data that is stored in a SharePoint list to look up and display data in a repeating table whenever data is entered into the repeating table control on an InfoPath 2010 form.

 

 Subscribe for updates via RSS or Email
InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services