Hiding Rows / Sections of Your Template

TABLE OF CONTENTS

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 )}}

{{!HIDEIFEND}}

So, for example:

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

This is some content that will be hidden...

... and some more to be hidden.

{{!HIDEIFEND}}

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

NOTE: In Word templates, that !HIDEIFSTART and HIDEIFEND must be on separate lines.
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.
E.g.,

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

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.

You can also use the !HIDEROWIF placeholder inside a !REPEATSTART section on Excel. For example, in Excel, the row inside the REPEATSTART / END will be repeated, and selectively hidden based on the selected answer value:

{{!REPEATSTART}}

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

{{!REPEATEND}}

 In Word templates, HIDEROWIF is always evaluated first before any REPEAT syntax is run. Also, the REPEATROW and HIDEROWIF syntax should never be on the same row.

Hiding Rows from a Repeating Table

If you need to conditionally hide repeating rows from a table based on a formula, you will need to place the HIDEIFSTART statement on its own line above the text to be hidden. In order to minimize the space taken by this line, consider lowering the font size to as low as 1. See the code below for an example.

{{!HIDEIFSTART( ISBLANK({{dataname}}) )}} //set this line to font size 1 to nearly hide it on the output

Content to be hidden here

{{!HIDEIFEND}}


Did you find it helpful? Yes No

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