Our support site has moved, please go to https://support.formsonfire.com

Hiding Rows / Sections of Your Template

Situations may arise 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.



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


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk