Multi-select list box to show/hide columns in horizontal repeating table
Learn how to use a multiple-selection list box on an InfoPath 2013 form to show and hide columns in a horizontal repeating table.
A horizontal repeating table control allows you to add columns to a repeating table instead of rows. The same techniques you generally apply to normal repeating table controls, you can apply to horizontal repeating table controls.
So if you want to show or hide the columns of a repeating table control, you can make use of conditional formatting on a horizontal repeating table control to do so.
Note that a horizontal repeating table control is not available for browser forms and that a user cannot add rows to it; you must preconfigure it to have a certain amount of rows.
You can also show or hide columns of a repeating table, which would also work in browser forms, but you would have to apply a couple of tricks to get the functionality you require.
The InfoPath 2013 video tutorial below shows you how you can use check boxes in a multiple-selection list box control to show and hide columns of a horizontal repeating table control on an InfoPath 2013 form.
In this InfoPath 2013 tutorial video, you learned...
- How to add a Formatting rule to a horizontal repeating table.
- How to construct a formula that makes use of the preceding-sibling XPath axis and the count function to count the amount of columns in a horizontal repeating table.
- How to construct a formula that makes use of the not, contains, and eval functions to be able to show or hide columns in a horizontal repeating table based on selections made in a multi-select list box.
See more InfoPath 2013 tutorial videos »
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.