InfoPath 2013 Cookbook 2

121 Codeless Recipes for SharePoint 2013


How to Purchase

Paperback Edition of InfoPath 2013 Cookbook 2 ($44.99) + Get bonus solutions online


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

and

Available on CreateSpace

 

WARNING: This book is NOT for everyone! It makes use of deprecated functionality in SharePoint 2013.

Do not buy this book if...

... you already own InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010 or any other InfoPath 2010 with SharePoint 2010 book, if you own InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services, or if you are looking to replace InfoPath with another forms creation tool.

Who is this book for?

InfoPath 2013 Cookbook 2 is for semi-technical professionals who:

  1. Have already mastered the basics of designing form templates in InfoPath 2013 AND
  2. Are already familiar with the basics of SharePoint 2013

but who have yet to start integrating InfoPath forms with SharePoint. The level of this book is beginner - intermediate and it DOES NOT CONTAIN ANY CODE!!! Code in this context refers to compilable code, which excludes XML technologies such as XML, XPath, and XSLT.

InfoPath 2013 Cookbook 2 is definitely NOT for:

  • SharePoint consultants
  • SharePoint architects
  • SharePoint administrators
  • Advanced InfoPath/SharePoint users
  • Programmers
  • Anyone looking to replace InfoPath today

What is this book about?

InfoPath 2013 Cookbook 2 extends the skills acquired from InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners by showing you how to integrate InfoPath 2013 primarily with SharePoint 2013 and secondarily with SharePoint Designer 2013, Excel, Access, and Word without writing code.

InfoPath 2013 Cookbook 2 is comprised of:

  • 40% basics of working with InfoPath forms in SharePoint
  • 60% solutions for integrating InfoPath with SharePoint
  • 121 step-by-step tutorials or solutions that have a Problem-Solution-Discussion format

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

What will this book do for you?

InfoPath 2013 Cookbook 2 will teach you how to:

  • Work with SharePoint list forms, SharePoint form library forms, SharePoint workflow forms, and document information panels
  • Work with SharePoint form libraries
  • Work with SharePoint content types as they relate to InfoPath forms
  • Work with data from SharePoint lists in InfoPath forms

In addition, you will:

  • Learn how to create SharePoint Designer workflows that use, run on, or interact with InfoPath forms
  • Learn how to integrate InfoPath with Word, Access, and Excel via SharePoint
  • Get solutions for common scenarios for using InfoPath forms in SharePoint
  • Get ideas for creating your own solutions or solving your own InfoPath SharePoint problems

What can you do next?

You can get InfoPath 2013 Cookbook 2 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 for SharePoint 2013 that InfoPath 2013 Cookbook 2 teaches you how to create.

Recipe 93 & 94: SharePoint Designer workflow to create InfoPath 2013 forms




 

Full Table of Contents

Chapter 1: SharePoint List Forms
1. Customize a SharePoint list form from within SharePoint
2. Customize a SharePoint list form from within InfoPath
3. Create a SharePoint list form to manage multiple list items
4. Add a new field to a SharePoint list through InfoPath
5. Delete a field from a SharePoint list through InfoPath
6. Restore the default form of a SharePoint list
7. Hide the Ribbon for a SharePoint list form
8. Add a custom Save button to a SharePoint list form
9. Add query functionality to a SharePoint list form
10. Query for multiple items in a SharePoint list form
11. Perform wildcard searches with a SharePoint list form
12. Add new record functionality to a SharePoint list form
13. Embed a SharePoint list form on a SharePoint page
14. Master/detail with two linked SharePoint lists
15. Master/detail between a SharePoint list and an InfoPath form
16. Use 2 different InfoPath forms to enter data in one SharePoint list

Chapter 2: SharePoint Form Library Forms
17. Create a SharePoint form library form template
18. Create a form library and edit its form template
19. Publish a form template to a form library
20. Republish a form template
21. Find and update a template that was published to a form library
22. Promote form fields to columns of a form library
23. Promote form fields to existing site columns
24. Delete a column linked to a promoted field
25. Create a content type for an InfoPath form from within InfoPath
26. Create a content type for an InfoPath form from within SharePoint
27. Create different types of forms in one form library
28. Configure a form library to create a certain type of form by default
29. Rename items listed on the New Document menu of a form library
30. Find and update a template that was published as a content type
31. Delete the content type for a form template from a form library
32. Use one form library column for data from two different forms
33. Hide or show Ribbon commands for a form
34. Submit a form to a form library and then close it
35. Submit a form to a folder in a form library based on a condition
36. Submit a form and switch to a 'Thank You' view
37. Send an alert when a new form is added to a form library
38. Add a link to open a form from a SharePoint page
39. Add a link to open a form from the Quick Launch menu
40. Embed an InfoPath form on a SharePoint page
41. Master/detail across two forms linked through one field
42. Pass data from a selected row in a repeating table to another form

Chapter 3: Work with SharePoint List Data
43. 2 Ways to retrieve data from a SharePoint list
44. Display SharePoint list data in a repeating table
45. 3 Ways to copy SharePoint list data to form fields
46. Map rows of a repeating table to SharePoint list items
47. Master/detail data with linked SharePoint lists
48. Display a list of people from the current user's department
49. Sort SharePoint list data on one field
50. Filter SharePoint list data on an exact match
51. Retrieve the first X amount of items from a SharePoint list
52. Prevent duplicate items from being added to a SharePoint list
53. Prevent overlapping periods when adding items to a SharePoint list
54. Retrieve a list of forms from a form library
55. Display the name of the user who created a form on the form
56. Retrieve a list of forms created by the current user from a library
57. Open a form in the browser from another form
58. Display a list of the form libraries on a SharePoint site
59. Determine whether a form is new or already exists
60. Autonumber a form when it is submitted to a form library
61. Create separate add and edit views in a form

Chapter 4: Use InfoPath Controls with Data from SharePoint
62. Shrinking list in a repeating table using SharePoint list data
63. Cascading drop-down list boxes using one SharePoint list
64. Cascading drop-down list boxes in a repeating table using linked lists
65. Cascading drop-down list boxes using linked SharePoint lists
66. Cascading drop-down list box and repeating table using linked lists
67. Upload an image as an attachment to a SharePoint list item
68. Select and display an image attached to a SharePoint list item
69. Upload an image to a picture library using an InfoPath form
70. Select and display an image from a picture library
71. Sequentially navigate through images in a picture library
72. Display basic info of a user from a people picker in text boxes
73. Limit a person/group picker to a maximum of 3 selected people
74. Get email addresses from a person/group picker
75. Get the details of the manager of a selected person in a people picker
76. Fill a multi-select list box on a list form with SharePoint list data
77. Fill a multi-select list box with email addresses from a people picker
78. Cascading multi-select list boxes using linked SharePoint lists
79. Filter and display SharePoint list items using a multi-select list box

Chapter 5: Use SharePoint Designer Workflows with InfoPath
80. Create a workflow that runs on forms in a specific form library
81. Create a workflow that runs on a specific type of form
82. Delete a workflow that runs on forms in a form library
83. Manually start a workflow to run on a form
84. Start a workflow from a custom action in a library
85. Start a workflow by clicking on a button on an InfoPath form
86. Get the value of an InfoPath form field in a workflow
87. Set the value of an InfoPath form field through a workflow
88. Send a form's link in an email to selected users at workflow startup
89. Send an email to the manager of a selected person
90. Send an email to a list of people in a people picker
91. Create SharePoint list items for multiple people in a people picker
92. Submit rows of a repeating table to a SharePoint list
93. Create a new InfoPath form through a workflow
94. Create a new form and link it to an existing form through a workflow
95. Move a form from one form library to another using a workflow
96. Set a task form field from an initiation form in an approval workflow

Chapter 6: Use Word with InfoPath via SharePoint
97. Use a Word document as a template for documents in a library
98. Link Word document fields to document panel fields
99. Create a document information panel from within SharePoint
100. Create a document information panel from within InfoPath
101. Auto-generate a simple Word document from an InfoPath form
102. Bulk convert selected InfoPath forms into Word documents

Chapter 7: Use Excel (Services) with InfoPath via SharePoint
103. Export data from Excel to SharePoint for display in InfoPath
104. Export data from forms in a form library to Excel
105. Publish an Excel workbook for use with InfoPath in SharePoint
106. Send an InfoPath form value to an Excel workbook
107. Get the value of an Excel cell in InfoPath
108. Set the value of an Excel cell in InfoPath
109. Populate a drop-down list box with data from an Excel workbook
110. Calculate business days between two dates excluding holidays
111. Use an InfoPath form to create a new Excel workbook in SharePoint
112. Update an Excel workbook when submitting a form to SharePoint
113. Submit SharePoint list form values to a new Excel workbook
114. Add a form's URL as a link to an Excel workbook from within InfoPath
115. Send a repeating table row to Excel
116. Send an entire repeating table to Excel
117. Add a new row to an Excel table from within InfoPath
118. Sequentially navigate through rows of an Excel table

Chapter 8: Use Access with InfoPath via SharePoint
119. Display Access data in an InfoPath browser form
120. Maintain Access data through an InfoPath browser form
121. Import data from an InfoPath form into Access database tables


 

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



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 2: 121 Codeless Recipes for SharePoint 2013

PAPERBACK

ISBN: 978-1499521498
Publication Date: Jul 2014
Author: S.Y.M. Wong-A-Ton
Page Count: 660
Language: English