InfoPath eval and sum functions to get total length of strings in repeating table
Learn how to use the sum, eval, and string-length functions in InfoPath 2013 to calculate the total amount of characters that have been entered into all of the fields in all of the rows of a repeating table on an InfoPath form.
You can use the string-length InfoPath function to calculate the length of a string that is entered into a text box control.
If you have a repeating table control containing a couple of text boxes in each row, and you would like to calculate the total length of all of the strings that are entered into the text box controls in the repeating table, you can first use the eval function combined with an expression using the string-length function to return a node-set that can then be passed to the sum function to calculate the total amount of characters that have been typed into the text boxes in the InfoPath repeating table.
The following InfoPath 2013 video tutorial shows how you can construct a formula that makes use of the three aforementioned functions in InfoPath to retrieve the total length of all of the strings that are entered into a repeating table control on an InfoPath form.
In this InfoPath 2013 tutorial video, you learned...
- How to construct a formula that makes use of the sum, eval, and string-length functions to calculate the total amount of characters entered into text box controls in a repeating table on an InfoPath form.
See more InfoPath 2013 tutorial videos »
Related InfoPath Articles:
- InfoPath substring-after and substring-before functions
- InfoPath 2010 functions within functions in a formula
- InfoPath 2013 LEFT and RIGHT functions
- Using InfoPath Math functions with repeating fields as input
- InfoPath 2010 running total sum in repeating table
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. 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.