InfoPath 2010 functions within functions in a formula

Learn how you can use the translate and substring functions within the concat function to capitalize the first character of a string.

You can use functions within formulas in InfoPath to construct business logic. Formulas can be used in Action rules, but also in conditions that are specified on rules (Action, Validation, and Formatting rules).

Functions return results, and these results can be passed to other functions. Therefore, you can call functions within other functions in InfoPath, thereby making a formula as easy or as complex as you like.

The following InfoPath video shows you how you can use the substring and translate functions within the concat function to construct a formula that capitalizes the first character of a word.

In this InfoPath 2010 tutorial video, you learned...

  • How to construct a formula that makes use of the substring function in InfoPath.
  • How to construct a formula that makes use of the concat function in InfoPath.
  • How to construct a formula that makes use of the translate function in InfoPath.
  • How to construct a formula that capitalizes the first character of a word.

See more InfoPath 2010 tutorial videos »

 
 Subscribe for updates via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services