S.Y.M. Wong-A-Ton

Kia Ora! My name is S.Y.M. Wong-A-Ton, and I am the owner and editor of BizSupportOnline as well as the author of all of the InfoPath tutorials, articles, and educational InfoPath videos on this web site.

BizSupportOnline is a web site where you will find articles about practical solutions to common challenges encountered when trying to build solutions using Microsoft technologies, and in particular, InfoPath, SharePoint, SQL Server, and the Microsoft .NET Framework.

If you are interested in learning more about me, you can choose from the following topics on this page:

 

InfoPath Books and Articles

Apart from the 450+ articles you will find on BizSupportOnline, I have authored the following InfoPath books and written the following InfoPath articles for third-party web sites.

 

Books

InfoPath 2013 Cookbook 2

InfoPath 2013 Cookbook 2 (July 2014)
InfoPath 2013 Cookbook 2 explains the basics of designing SharePoint list forms, SharePoint form library forms, SharePoint workflow forms, and document information panels, in addition to providing guidance for how to work with SharePoint lists as well as how to create workflows in SharePoint Designer 2013 that make use of, create, or interact with InfoPath 2013 forms. This book is targeted towards semi-technical professionals who have already mastered the basics of designing form templates in InfoPath and who are familiar with the basics of SharePoint 2013, but who have yet to start integrating InfoPath forms with SharePoint. InfoPath 2013 Cookbook 2 extends the skills acquired from InfoPath 2013 Cookbook by showing how to integrate InfoPath 2013 primarily with SharePoint 2013 and secondarily with SharePoint Designer 2013, Excel, Access, and Word without writing a single line of code. InfoPath 2013 Cookbook 2 consists of 121 step-by-step tutorials spread across 8 chapters and 660 pages.

InfoPath 2013 Cookbook

InfoPath 2013 Cookbook (August 2013)
InfoPath 2013 Cookbook covers the basics of designing form templates using InfoPath 2013, and is geared towards semi-technical professionals who want to master the basics by following step-by-step instructions without writing code. This InfoPath 2013 book consists of 121 step-by-step tutorials spread across 9 chapters and 512 pages. InfoPath 2013 Cookbook is an updated and revised version of InfoPath 2010 Cookbook that contains more recipes, more exercises, questions and answers to test your knowledge, and a larger font for better readability.

InfoPath 2010 Cookbook 5

InfoPath 2010 Cookbook 5 (January 2013)
InfoPath 2010 Cookbook 5 is for semi-technical to technical professionals who have already mastered the basics of designing form templates in InfoPath and who already know how to work with Excel 2010 and SharePoint 2010. InfoPath 2010 Cookbook 5 extends the skills acquired from all books in the InfoPath 2010 Cookbook series of books written by S.Y.M. Wong-A-Ton. InfoPath 2010 Cookbook 5 is an InfoPath-centric book that is not suitable for absolute beginners and that teaches intermediate to advanced InfoPath users how to combine InfoPath 2010 with Excel 2010 and Excel Services. First it teaches you how to create InfoPath solutions that do or do not require writing code by providing basic knowledge for building form solutions that access data in Excel 2010 workbooks or that make use of Excel Services in SharePoint 2010, and then it provides step-by-step guidance for designing common and often-requested form solutions that integrate InfoPath with Excel and Excel Services. InfoPath 2010 Cookbook 5 consists of 57 step-by-step tutorials spread across 3 chapters and 362 pages.

InfoPath 2010 Cookbook 4

InfoPath 2010 Cookbook 4 (August 2012)
InfoPath 2010 Cookbook 4 is for Visual Basic developers who have already mastered the basics of designing form templates in InfoPath 2010 without writing code and who now want to extend the functionality of InfoPath 2010 forms through code. InfoPath 2010 Cookbook 4 extends the skills acquired from InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners by showing you how to start writing VB .NET code for InfoPath 2010 forms to access and manipulate data within forms. InfoPath 2010 Cookbook 4 then moves on to explore more complex and advanced topics that combine InfoPath programming with web services, databases (Access 2010 and SQL Server 2008), Word 2010, and SharePoint 2010. InfoPath 2010 Cookbook 4 consists of 101 step-by-step tutorials spread across 9 chapters and 478 pages.

InfoPath 2010 Cookbook 3

InfoPath 2010 Cookbook 3 (March 2012)
InfoPath 2010 Cookbook 3 is for C# developers who have already mastered the basics of designing form templates in InfoPath 2010 without writing code and who now want to extend the functionality of InfoPath 2010 forms through code. InfoPath 2010 Cookbook 3 extends the skills acquired from InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners by showing you how to start writing C# code for InfoPath 2010 forms to access and manipulate data within forms. InfoPath 2010 Cookbook 3 then moves on to explore more complex and advanced topics that combine InfoPath programming with web services, databases (Access 2010 and SQL Server 2008), Word 2010, and SharePoint 2010. InfoPath 2010 Cookbook 3 consists of 101 step-by-step tutorials spread across 9 chapters and 478 pages.

InfoPath 2010 Cookbook 2

InfoPath 2010 Cookbook 2 (October 2011)
InfoPath 2010 Cookbook 2 explains the basics of designing SharePoint list forms, SharePoint form library forms, SharePoint workflow forms, and document information panels, in addition to providing guidance for how to work with SharePoint lists to provide sorting, filtering, and paging, as well as how to create SharePoint Designer 2010 workflows that make use of, create, or interact with InfoPath 2010 forms. This book is targeted towards semi-technical professionals who have already mastered the basics of designing form templates in InfoPath and who are familiar with the basics of SharePoint 2010, but who have yet to start integrating InfoPath forms with SharePoint. InfoPath 2010 Cookbook 2 extends the skills acquired from InfoPath 2010 Cookbook by showing how to integrate InfoPath 2010 primarily with SharePoint 2010 and secondarily with SharePoint Designer 2010, Excel, Access, and Word without writing a single line of code. InfoPath 2010 Cookbook 2 consists of 101 step-by-step tutorials spread across 6 chapters and 478 pages.

InfoPath 2010 Cookbook

InfoPath 2010 Cookbook (February 2011)
InfoPath 2010 Cookbook explains the basics of designing form templates using InfoPath 2010. This book is targeted towards semi-technical professionals who want to master the basics of InfoPath 2010 from scratch by following step-by-step instructions without writing code. InfoPath 2010 Cookbook consists of 101 step-by-step tutorials spread across 9 chapters and 284 pages.

 

Online Articles

Downloading InfoPath 2007 Forms in a Specific File Format from a SharePoint Form Library (MSDN Web Site, November 2007)
Learn how to use a technique that enables users to convert and download Microsoft Office InfoPath 2007 forms directly from Microsoft Office SharePoint Server 2007 form libraries as files in a format that is not XML.

Accessing configuration settings from InfoPath 2007 browser-enabled form templates (Microsoft Support Web Site, September 2007)
Learn how to access custom configuration settings that are stored in Windows SharePoint Services web application configuration files from InfoPath browser-enabled form templates.

Printing InfoPath 2007 Web-Based Forms to PDF (ASP Alliance Web Site, November 2007)
While you can use the Microsoft Save as PDF add-in with the InfoPath 2007 client application or write code that uses the InfoPath 2007 object model to export the current view of an InfoPath form to PDF, these two options are not available for InfoPath 2007 web-based forms. This article presents a technique that you can use to print InfoPath 2007 web-based forms to PDF.

Saving InfoPath Forms to SQL Server 2005 as XML (ASP Alliance Web Site, January 2007)
The new XML data type within SQL Server 2005 opens new possibilities for persisting XML data of InfoPath forms. This article discusses and demonstrates how to save entire InfoPath forms to SQL Server 2005 as typed or untyped XML data.

How to automatically display the first item in a drop-down list box in InfoPath 2003 (Microsoft Support Web Site, December 2006)
This article describes how to automatically display the first item in a drop-down list box that has been populated with values from a data connection to an XML file.

Updating a Secondary Data Source in InfoPath Using AJAX (ASP Alliance Web Site, November 2006)
Microsoft Office InfoPath does not offer out-of-the-box persistence of data in secondary data sources; only data within the Main data source is persisted. To make updating secondary data sources possible, changes have to be saved back to the underlying source of secondary data sources. This article shows how you can use AJAX to update the data of a secondary data source.

Building an RSS Feed Reader with Microsoft Office InfoPath (ASP Alliance Web Site, May 2006)
While Microsoft Office InfoPath 2003 offers out of the box connections to several types of data sources such as XML files, databases, SharePoint lists and web services, we can also use InfoPath to connect to web sites to retrieve or submit data. In this article we will create an RSS feed reader sample form in InfoPath to retrieve data from the Internet.

Password-protecting Sensitive InfoPath Form Fields (ASP Alliance Web Site, March 2006)
Microsoft Office InfoPath forms are stored in clear-text and thus considered insecure, especially if you have an option to enter the Password. In this article, Wong examines how to enable a user to enter a password into an InfoPath form and use it to encrypt and decrypt sensitive InfoPath form fields without saving the password.

 

Professional IT Experience

I am a Microsoft Certified Professional Developer in Enterprise Applications, have been Microsoft Certified since 1998 and was awarded the Microsoft MVP award from 2006 to 2014.

I have worked with a large range of technologies over the course of my professional career (since 1997) as well as built, maintained, and supported a variety of applications ranging from small desktop applications to large and complex enterprise applications. The primary technologies I work with are listed below.

Development Tools

  • Visual C#

Data Technologies

  • SQL Server
  • XML

Web Technologies

  • HTML / CSS
  • ASP.NET
  • Web Services

Business Productivity

  • InfoPath

Collaboration

  • SharePoint Server
 

Personal Information

I live in Wellington, New Zealand, where I enjoy traveling around New Zealand, going on long strenuous day hikes, and taking landscape photos. I often report on my hiking and driving trips, and on other tidbits of New Zealand travel through my travel web site.

 
 Subscribe to BizSupportOnline via RSS or Email