InfoPath 2010 Cookbook

101 Codeless Recipes for Beginners

How to Purchase

Paperback Edition of InfoPath 2010 Cookbook ($39.95) + Get bonus solutions online

Available on Amazon (also available on and


Available on CreateSpace


Who is this book for?

InfoPath 2010 Cookbook is for semi-technical professionals who:

  1. Have little or no prior knowledge of InfoPath AND
  2. Have previously worked with a Microsoft Office application

and who have already installed InfoPath 2010.

This book is NOT for administrators, programmers, or advanced InfoPath / SharePoint users. The level of this book is beginner and it DOES NOT CONTAIN ANY CODE!!!

What is this book about?

InfoPath 2010 Cookbook is a practical book about InfoPath 2010 that focuses on teaching the basics of designing InfoPath 2010 form templates from scratch without writing code.

InfoPath 2010 Cookbook is comprised of:

  • 50% basics of designing InfoPath 2010 form templates
  • 50% solutions for working with the most popular controls in InfoPath
  • 101 step-by-step tutorials or solutions that have a Problem-Solution-Discussion format

See the titles of all 101 recipes in the full table of contents of the book.

InfoPath 2010 Cookbook is not an InfoPath with SharePoint guide. However, most, if not all of the codeless techniques from InfoPath 2010 Cookbook can be applied to InfoPath forms you create for SharePoint.

What will this book do for you?

You should go through all of the recipes from Chapters 1 through 4 in sequence to get the full benefit of the book and of learning the basics before moving on to the chapters that provide more specific InfoPath solutions.

InfoPath 2010 Cookbook will teach you how to:

  • Design form templates
  • Publish form templates
  • Submit forms
  • Work with views
  • Work with controls
  • Work with rules and formulas
  • Work with external data sources

In addition, you will:

  • Get invaluable tips
  • Learn tricks to do things that seem impossible to do in InfoPath without writing code
  • Get ideas for creating your own (future) solutions or for solving your own InfoPath problems

What can you do next?

You can get InfoPath 2010 Cookbook at Amazon or CreateSpace (an Amazon company)


You can watch demo videos (one of which is shown below) of a few of the InfoPath form solutions that InfoPath 2010 Cookbook teaches you how to create.

Recipe 99: Cascading drop-down list boxes in a repeating table


Full Table of Contents

Chapter 1: Form Template Design Basics
1. Create a new form template
2. Preview an InfoPath form
3. Align labels and controls
4. Add a text box - method 1
5. Add a text box - method 2
6. Delete a control
7. Bind a control to a different field
8. Make a text box multi-line
9. Make a field required
10. Add a hidden field
11. Publish an InfoPath form template

Chapter 2: Working with Views
12. Add a second view to a form template
13. Make a view the default view
14. Add a read-only view
15. Add a print view
16. Print data on a print view by overlaying text on an image

Chapter 3: Formulas
17. Capitalize text in a text box
18. Join text strings from two text boxes together
19. Join two text strings and remove spaces if either text string is empty

Chapter 4: Adding Rules
20. Change the background color of a text box to red if blank
21. Set the value of a field
22. Close a form when a button is clicked
23. Switch to a read-only view when a button is clicked
24. Show a repeating table when check box is selected
25. Make a control read-only based on a condition
26. Disable a button on a read-only view
27. Enable a control when a check box is selected
28. Make a field required based on a condition
29. Check whether a number was entered
30. Set a maximum length on a text box
31. Show/hide sections based on a drop-down list box

Chapter 5: Getting Data from External Sources
32. Get data from an XML file
33. Get data from a database table
34. Get data from a SharePoint List

Chapter 6: Submitting Forms
35. Submit a form to a single destination using rules
36. Submit a form to multiple destinations using rules
37. Prevent form submit if a check box has not been selected
38. Submit InfoPath data to a single Microsoft Access database table
39. Submit to Access database tables with a one-to-many relationship
40. Switch to read-only view on submit
41. Switch to read-only view when form opens after submit
42. Make a control read-only upon submit

Chapter 7: Input Controls
43. Validate a check box
44. Toggle a check box on and off when a button is clicked
45. Make a field required based on a check box selection
46. Select a check box to move text from one field to another
47. Select an option on one view and have a text box appear on another view
48. Populate a drop-down list box from an XML file
49. Filter a drop-down list based on the first character
50. Automatically select the first item in a drop down list box
51. Clear the selected value in a drop-down list
52. Count the number of items in a drop down list box
53. Check if an item exists in a drop-down list box
54. Populate a text box based on a drop-down list box
55. Cascading drop-down list boxes using an XML file
56. Change a text box control into a date picker control
57. Add a date picker to a repeating table
58. Display the current date in a date picker
59. Display the current time on a form when it opens
60. Add 7 days to a date in a date picker
61. Extract the year from a date picker
62. Select a date picker's year via a drop-down selection
63. Extract the month name from a date picker
64. Set a date picker to display the previous month in its calendar
65. Extract the name of the day for a selected date
66. Force Sundays to be selected from a date picker
67. Change the time text box of a date and time picker into a drop-down list box
68. Check whether start date falls before end date
69. Keeping two date pickers within a 7-day date range of each other
70. Calculate a person's age from a date of birth in a date picker control
71. Calculate the difference in days between a date picker and today
72. Calculate the difference in days between two date pickers
73. Filter data from an external data source using multiple selections
74. Display items from a multiple-selection list box as multi-line text

Chapter 8: Objects
75. Change button caption when button is clicked
76. Add line breaks to a button caption
77. Check if a file has been attached
78. Clear a file attachment field
79. Make an attachment read-only - method 1
80. Make an attachment read-only - method 2
81. Add multiple files to a file attachment control

Chapter 9: Container Controls
82. Use sections to display error messages
83. 4 Ways to add a rich text box to a repeating table
84. Create a repeating table with a fixed number of rows
85. Add a sum field to a repeating table
86. Count the number of rows in a repeating table - method 1
87. Count the number of rows in a repeating table - method 2
88. Automatically number repeating table rows
89. Copy data from the previous row to a new row
90. Auto-populate a repeating table with week periods
91. Count the number of occurrences of a word in a repeating table
92. Highlight the last row of a repeating table
93. Highlight alternating rows in a repeating table
94. Change a green repeating table to red if it contains more than 3 rows
95. Hide the first row of a repeating table
96. Hide a row of a repeating table when a check box is selected
97. Lock rows of a repeating table using check boxes
98. Make a repeating table read-only
99. Cascading drop-down list boxes in a repeating table
100. Export a repeating table's contents as a string
101. Export a repeating table's contents to a text box with line breaks


Bonus: Get more InfoPath solutions and other goodies in the InfoPath 2010 Cookbook Club, a private area for customers who have bought InfoPath 2010 Cookbook.

Available on Amazon (also available on and


Available on CreateSpace

Disclosure: A few links on this page are Amazon affiliate links. To learn more, read our privacy policy.

InfoPath 2010 book


ISBN: 978-1456542764
Publication Date: Feb 2011
Author: S.Y.M. Wong-A-Ton
Page Count: 284
Language: English