Example Forms

Copy Repeating External Data Into a Form

Hilary Stoupa — Fri, 04 Jul 2008 19:00:48 GMT

This zip file contains the following:

Sample forms with code for copying repeating external data into a form

JScript version
C# version

XML files that can be used as secondary data sources

A tutorial for these samples is located here: http://www.infopathdev.com/blogs/hilary/archive/2008/07/04/how-do-i-copy-repeating-data-from-an-external-source-into-my-form.aspx

InfoPath Attachment Linking

Patrick Halstead — Sun, 15 Jun 2008 19:39:50 GMT

This solution shows how you can copy InfoPath attachments to SharePoint document library and convert the Base64 string attachment in your InfoPath form into a link to the uploaded SharePoint document. You will need to modify the URL in ViewOptions.xml to point to your SharePoint site's document library.

Note: this sample solution uses the taskpane to upload and convert the image attachments to SharePoint documents. This means that the form cannot be used in the browser.

Select a Master Table Row via Code, v1.0

Greg Collins — Fri, 01 Sep 2006 22:50:35 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Techniques Demonstrated:

Identify the currently selected master table row using GetNamedNodeProperty.
Change the currently selected master table row using SetNamedNodeProperty.
Use buttons to select the first and last rows in the master table.
Use buttons to select the previous and next rows in the master table.
Use text box and button to select specific row in the master table.
Show table row number using position().
Expression Boxes.

Search, v1.0

Greg Collins — Fri, 01 Sep 2006 22:50:16 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Techniques Demonstrated:

Use XPath to search a data source, including Rich Text controls, for user-specified query string.
Store search results in secondary data source (allows for complex manipulation).
Manipulate a secondary data source via code.
Disable view switching via the menus.
String object extensions.

Rudimentary Animation, v1.0

Greg Collins — Fri, 01 Sep 2006 22:49:59 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Techniques Demonstrated:

Custom task pane to control animations using code.
Preserve code block to prevent loss of modifications.
Manually modified XSL.
Using SetNamedNodeProperty to set animation variables.
Using GetNamedNodeProperty to use animation variables.

Rightsizing Check Boxes and Option Buttons, v1.0

Greg Collins — Fri, 01 Sep 2006 22:49:41 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1	ü
SP1	ü

Techniques Demonstrated:

Adjust control size to compliment various font sizes.
Adjust margin settings to keep smaller controls lined up.

Repeating Cascading Lists with Extracted First Level, v1.0

Greg Collins — Fri, 01 Sep 2006 22:49:20 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Techniques Demonstrated:

Repeating three-level cascading drop-down list boxes.
First cascade level extracted outside of repeating table.
Hidden field to correspond to extracted first cascade level.
Preserve Code Block.
Use of XSL variables for cascading.
Use of code to populate text box based on final cascade choice.
Secondary data source to populate cascading drop-down list boxes.
Rules.
Filters.
Table row numbering.

Repeating Cascading Lists of Cascading Lists, v1.0

Greg Collins — Fri, 01 Sep 2006 22:49:00 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü			ü

Techniques Demonstrated:

Cascading drop-down list boxes in successive repeating tables.
Filter duplicate entries.
Filter previous selections.
Use XSL current() function to ensure proper cascade.
Secondary data source to populate drop-down list boxes.
Rules clear successive values on selection change.
Code removes extra successive fields on selection change.
Disable drop-down list box if parent selection is blank.
Disable insert if parent selection is blank.

Reordering Table Rows. v1.0

Greg Collins — Fri, 01 Sep 2006 22:48:32 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1	ü
SP1	ü			ü

Techniques Demonstrated:

Reordering table rows via script.
Table row numbering with an Expression Box.
Miniature arrow buttons.
Hand-edited XSL, includes:
- Updated style attribute of arrow buttons to include:
  - LINE-HEIGHT: 5px;
- Conditional formatting on buttons:
  - Disables first row's Up button.
  - Disables last row's Down button.

Populating Table Row After Selection (Rules), v1.0

Greg Collins — Fri, 01 Sep 2006 22:48:13 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Requirements:

Local Installation of Microsoft SQL Server.
SQL Northwind database installed.

Techniques Demonstrated:

Using SQL as a secondary data source.
Using a secondary data source to store the current row number.
Connecting a drop-down list box to a SQL database.
Using rules to populate the main DOM from a secondary data source.
- Using the stored current row number to assist in row population.
Master-Detail repeating table.

Populating Table Row After Selection (Code), v1.0

Greg Collins — Fri, 01 Sep 2006 22:47:55 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Requirements:

Local Installation of Microsoft SQL Server.
SQL Northwind database installed.

Techniques Demonstrated:

Using SQL as a secondary data source.
Connecting a drop-down list box to a SQL database.
Using code to populate the main DOM from a secondary data source.
Master-Detail repeating table.
Preventing recursion in an OnAfterChange event handler.
String object extensions.

Populating Fields After Selection, v1.0

Greg Collins — Fri, 01 Sep 2006 22:47:36 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Requirements:

Local installation of Microsoft SQL Server.
SQL Northwind database installed.

Techniques Demonstrated:

Using SQL as a secondary data source.
Connecting a drop-down list box to a SQL database.
Using rules to populate the main data source from a secondary data source.

Populating Fields After Selection With Search, v1.0

Greg Collins — Fri, 01 Sep 2006 22:47:12 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Requirements:

Local Installation of Microsoft SQL Server.
SQL Northwind database installed.

Techniques Demonstrated:

Using SQL as a secondary data source.
Connecting a drop-down list box to a SQL database.
Using rules to populate the main data source from a secondary data source.
Search field to limit entries in drop-down list box.
Button to reset search to full list of entries.

Paged Master-Detail Table, v1.1

Greg Collins — Fri, 01 Sep 2006 22:46:50 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1
SP1	ü

Techniques Demonstrated:

Paged information using Master-Detail table.
Show total number of items, total number of pages, and current page.
Specify number of items per page.
Page buttons: first, previous, next, and last.
Show full or partial last page.
Insert row scrolls page if necessary.
Secondary data source.
Rules.
Filters.

Moving Items Between List Boxes, v1.1

Greg Collins — Fri, 01 Sep 2006 22:46:30 GMT

Available Versions
	JScript	VBScript	VB.NET	C#
V1	ü
SP1	ü

Techniques Demonstrated:

Preserve Code Block.
Moving items between list boxes.
Populating a drop-down list box via script.
String object extensions.