Hiding a Specified Sheet by JS

Problem

During initialization, some sheets among multiple sheets in a data entry report do not need to be displayed or just need to be hidden directly during initialization.

For example, some sheets used for calculation do not need to be displayed. In this case, you can use the following method.

Implementation Method

You can hide the corresponding sheets by adding a Loading Start event. For details about the API description, see API Only for Data Entry Preview.

Template Design

The sample template contains five sheets, displaying the corresponding data of five products, respectively.

1. Design the table style and rename each sheet, as shown in the following figure.

2. Set a filter condition for each sheet to display the product data corresponding to the current sheet name, as shown in the following figure.

Loading Start Event Adding

Choose Template > Web Attribute > Data Entry Setting on the menu bar, select Set for This Template Separately, and add a Loading Start event, as shown in the following figure.

The JavaScript code is as follows.

if (!window.flag) {
       $('li[title="Apple Juice"]').hide();
       //Hide the Apple Juice sheet.
       _g().loadSheetByName("Milk");
       //Switch to the Milk sheet.
       flag = true;
       //Use the global variable to prevent the event from being executed repeatedly.
}

Effect Preview

Save the template and click Data Entry Preview. In this case, the Apple Juice sheet (the first sheet) is hidden.

Note:

The effect cannot be previewed on mobile terminals.

For details, you can download the template Hiding a Specific Sheet by JS.cpt.