{"id":11376,"date":"2021-04-29T17:59:00","date_gmt":"2021-04-29T08:59:00","guid":{"rendered":"https:\/\/www.eformsign.com\/en\/blog\/?p=11376"},"modified":"2022-05-20T14:55:31","modified_gmt":"2022-05-20T05:55:31","slug":"hiding-sheets-sections-of-a-document-when-sending","status":"publish","type":"post","link":"https:\/\/www.eformsign.com\/en\/blog\/hiding-sheets-sections-of-a-document-when-sending\/","title":{"rendered":"Hiding sheets\/sections of a document when sending"},"content":{"rendered":"\n<p>If you upload an Excel or Word file via the Form Builder Microsoft Office add-in, you can choose to hide sections or sheets in the document in the participant step of the workflow. By using the <strong>Hide sheets or sections<\/strong> option which is displayed on the right of the participant step, you can choose which sheets\/section will be hidden from the participant.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>Creating multiple sheets\/sections in a document<\/h2>\n\n\n\n<p>To hide a sheet\/section of a document, the template must consist of multiple sheets\/sections first.<\/p>\n\n\n\n<ul><li>Excel: Must consist of two or more sheets.<\/li><li>Word: Must consist of two or more sections. Note that you must set &#8220;Breaks&#8221; to &#8220;Next Page&#8221; when creating sections.<\/li><\/ul>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-very-light-gray-color has-text-color has-background\" style=\"background-color:#0e73c3\">[Tip] Creating sections in Word<br><img class=\"wp-image-13288\" style=\"width: 400px\" src=\"https:\/\/www.eformsign.com\/en\/support\/wp-content\/uploads\/sites\/6\/2020\/04\/word-breaking-sections.png\" alt=\"\"><br>1. Place the mouse cursor on the part of the page you want to create sections.<br>2. Go to the PAGE LAYOUT menu.<br>3. Select &#8220;Next Page&#8221; under &#8220;Breaks&#8221;.<br>4. Check that sections have been created.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>Using the settings for hiding sheets\/sections<\/h2>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Only the&nbsp;<strong>company administrator<\/strong>&nbsp;and members with the&nbsp;<a href=\"https:\/\/www.eformsign.com\/en\/blog\/?p=11569\"><strong>Manage templates<\/strong><\/a>&nbsp;permission can perform this action. <\/p><\/blockquote>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1354\" height=\"650\" src=\"https:\/\/www.eformsign.com\/en\/blog\/wp-content\/uploads\/sites\/3\/2021\/11\/hiding-sheets.png\" alt=\"\" class=\"wp-image-11587\" \/><\/figure>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ol><li>Log in to eformsign.<\/li><li>Go to the <strong>Manage templates<\/strong> menu in the sidebar.<\/li><li>Click the template settings icon (\u2699) to go to the <strong>Template settings<\/strong> page. <\/li><li>Click the<strong> Workflow<\/strong> tab.<\/li><li>Add a participant step (if there already is a participant step, then click on that step).<\/li><li>Check the <strong>Hide sheets or sections<\/strong> option in the <strong>Properties<\/strong> tab on the right.<\/li><li>Select the sheets or sections you want to show or hide.<ol><li><strong>Required<\/strong>: The selected sheet\/section will be shown to the participant.<\/li><li><strong>Optional<\/strong>: The participant decides whether to show the selected sheet\/section.<\/li><li><strong>Hide<\/strong>: The selected sheet\/section will be hidden from the participant.<\/li><\/ol><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>If you upload an Excel or Word file via the Form Builder Microsoft Office add-in, you can choose to hide sections or sheets in the document in the participant step of the workflow. By using the Hide sheets or sections option which is displayed on the right of the participant step, you can choose which [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":12266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[129],"tags":[165,154,155,182,223],"_links":{"self":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11376"}],"collection":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/comments?post=11376"}],"version-history":[{"count":6,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11376\/revisions"}],"predecessor-version":[{"id":11897,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11376\/revisions\/11897"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/media\/12266"}],"wp:attachment":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/media?parent=11376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/categories?post=11376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/tags?post=11376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}