InfoPath 2013 Cookbook

121 Codeless Recipes for Beginners


How to Purchase

Paperback Edition of InfoPath 2013 Cookbook ($39.99)


Available on Amazon (also available on Amazon.co.uk and Amazon.de)

and

Available on CreateSpace

 

Who is this book for?

InfoPath 2013 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 2013.

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 2013 Cookbook is a practical book about InfoPath 2013 that focuses on teaching the basics of designing InfoPath 2013 form templates from scratch without writing code.

InfoPath 2013 Cookbook is comprised of:

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

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

InfoPath 2013 Cookbook is not an InfoPath with SharePoint book. However, most, if not all of the codeless techniques from InfoPath 2013 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 2013 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 2013 Cookbook at Amazon or CreateSpace (an Amazon company)

OR

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

Bonus Recipe: Populate a drop-down list box with dates excluding weekends




 

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. Change a text box into a date picker
7. Delete a control
8. Bind a control to a different field
9. Make a text box multi-line
10. Make a text box mandatory
11. Add a hidden field to a form
12. Publish an InfoPath form template

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

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

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

Chapter 5: External Data Sources
33. Get data from an XML file
34. Get data from a database table
35. Get data from a SharePoint list

Chapter 6: Submit Forms
36. Enable a form to be submitted
37. Submit a form to a single destination using rules
38. Submit a form to multiple destinations using rules
39. Prevent form submission if a check box has not been selected
40. Submit form data to one Access database table
41. Submit form data to database tables with a one-to-many relationship
42. Switch to a read-only view on submit
43. Switch to a read-only view when a form is opened after submission
44. Make a control read-only upon submit

Chapter 7: Input Controls
45. Display the current time on a form when it opens
46. Calculate the sum of text boxes
47. Validate a check box
48. Toggle a check box on and off when a button is clicked
49. Make a field required based on the value of a check box
50. Select a check box to move text from one field to another
51. Select an option and have a text box appear on a different view
52. Populate a drop-down list box with static items
53. Populate a drop-down list box with data from a repeating table
54. Populate a drop-down list box with data from an XML file
55. Filter a drop-down list box based on the first character
56. Automatically select the first item in a drop-down list box
57. Clear the selected item in a drop-down list box
58. Count the amount of items in a drop-down list box
59. Check if an item exists in a drop-down list box
60. Populate a text box based on an item selected in a drop-down list box
61. Cascading drop-down list boxes using an XML file
62. Display the current date in a date picker
63. Extract the year from a date picker
64. Set the year of a date in a date picker using a drop-down list box
65. Display the month name for a selected date
66. Set a date picker to display the previous month in its calendar
67. Display the name of the day for a selected date
68. Force Sundays to be selected from a date picker
69. Display the time of a date and time picker in a drop-down list box
70. Add 7 days to a date in a date picker
71. Check whether a start date falls before an end date
72. Keep two date pickers within a 7-day date range from each other
73. Calculate a person’s age based on a date of birth in a date picker
74. Calculate the difference in days between a date picker and today
75. Calculate the difference in days between two date pickers
76. Calculate the difference between two dates in a repeating table
77. Count the amount of holidays between two date pickers
78. Select one or more items by default in a multi-select list box
79. Limit a multi-select list box to a maximum of 3 selected items
80. Show or hide sections using a multiple-selection list box
81. Display items from a multiple-selection list box as multi-line text

Chapter 8: Objects
82. Dynamically change the label of a text box when an option is selected
83. Change the label of a button when the button is clicked
84. Add line breaks to the label of a button
85. Enable a button by clicking on another button
86. Create a tabbed interface using buttons
87. Check if a file has been attached to a file attachment control
88. Clear a file attachment control
89. Make an attachment read-only - method 1
90. Make an attachment read-only - method 2
91. Add multiple files to a file attachment control

Chapter 9: Container Controls
92. Use sections to display error messages
93. Make a field mandatory when a specific choice section is selected
94. 4 Ways to add a control to a repeating table
95. Remove the first empty row of a repeating table
96. Display a fixed amount of rows in a repeating table
97. Make an entire repeating table read-only
98. Make rows of a repeating table read-only by using check boxes
99. Count the number of rows in a repeating table - method 1
100. Count the number of rows in a repeating table - method 2
101. Count the number of rows changed in a repeating table
102. Count the number of occurrences of a word in a repeating table
103. Automatically number repeating table rows
104. Copy data from the previous row to a new row in a repeating table
105. Auto-populate a repeating table with week periods
106. Auto-populate a drop-down list box with past and future dates
107. Add a sum field to a repeating table
108. Add a running total sum to a repeating table
109. Calculate the average of all fields in 3 repeating tables
110. Hide the first row of a repeating table
111. Hide a row of a repeating table when a check box is selected
112. Highlight the last row of a repeating table
113. Highlight alternating rows in a repeating table
114. Limit the amount of rows added to a repeating table to a maximum
115. Change a green repeating table to red if it contains more than 3 rows
116. Shrinking drop-down list in a repeating table
117. Cascading drop-down list boxes in a repeating table
118. Export a repeating table’s contents as a string
119. Export a repeating table’s contents to a text box with line breaks
120. Copy data from a Secondary data source to the Main data source
121. Master/detail functionality with one master and two detail lists

Bonus Recipes
Display only the last 10 rows of a repeating table
Limit the amount of lines in a multi-line text box
Display the first of next month in a date picker
Populate a drop-down list box with dates excluding weekends



Available on Amazon (also available on Amazon.co.uk and Amazon.de)

and

Available on CreateSpace

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

InfoPath 2013 Cookbook

PAPERBACK

ISBN: 978-1491245637
Publication Date: Aug 2013
Author: S.Y.M. Wong-A-Ton
Page Count: 512
Language: English