Hiding Rows / Sections of Your Template

There are sometimes situations where you'd like to show or hide sections of your data template based on outcome of each Form entry's answers. For example, you may have an optional section in your Form that is not displayed or filled out depending on what the app user fills out. The associated data template will likely have the same requirement - i.e., you don't want to show a section of the template when it is not needed. Our platform enables you to dynamically hide rows or whole sections of your template using the syntax outlined below.

Dynamically Hiding Sections in Templates
To hide a section of your Word or Excel template, use the special !HIDEIFSTART placeholder:

{{!HIDEIFSTART( put a formula that evaluates to True/False here )}}


So, for example:

{{!HIDEIFSTART( {{myoption}} = 'No' )}}

This is some content that will be hidden...

... and some more to be hidden.


will hide the content between the START and END placeholders if the myoption answer is No.

NOTE: In Word templates, you must ensure there is either a space or a new line between the !HIDEIFSTART, HIDEIFEND and what needs to be hidden.
e.g., {{!HIDEIFSTART( {{myoption}} = 'No' )}} Content to be hidden {{!HIDEIFEND}}

In Excel, the !HIDEIFSTART, HIDEIFEND and content to be hidden must be in separate cells, i.e. not all in the same cell.

{{!HIDEIFSTART( {{myoption}} = 'No' )}}
Content to be hidden

Dynamically Hiding Rows in Templates
If you have rows that should only be shown when a specific answer value is given, you're in luck! Use the special !HIDEROWIF placeholder to dynamically show/hide a given row:

{{!HIDEROWIF( put a formula that evaluates to True/False here )}}

For example:

{{!HIDEROWIF( string-length({{chosenproduct}}) = 0 )}}

which will hide the row if the chosenproduct answer is empty or not set. This kind of formula is handy if you only want to show output if an answer is given.

Note that you can also use the !HIDEROWIF placeholder inside a !REPEATSTART section on Excel. (In Word templates, HIDEROWIF is always evaluated first before any REPEAT syntax is run.) For example, in Excel, the row inside the REPEATSTART / END will be repeated, and selectively hidden based on the selectedanswer value:


{{!HIDEROWIF( {{selectedanswer}} = 'Y' )}}


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.