Clicking Radio Button Groups to Switch Sheets by JS

Problem

When multiple sheets exist, you need to move the mouse and click tabs in the lower left corner to switch sheets. Besides, if excessive sheet tabs exist, it is hard for you to select the corresponding tab correctly. In this case, is there a simpler method to enable you to correctly select the corresponding sheet? The names of sheet tabs correspond to the values in the radio button group widget. You can switch to a specific sheet by clicking the corresponding value in the widget, as shown in the following figure.

Implementation Method

You can add a State Change event to Radio Button Group Widget. In this case, you can be redirected to the corresponding sheet pages when selecting different values.

Template Preparation

1. Create a template, add six sheets, and rename the sheets Apple, Strawberry, Orange, Pear, Blueberry, and Grape, as shown in the following figure.

Note:

You can right-click sheet names to rename the sheets.

2. Choose Template > Template Parameter on the menu bar and add the template parameter Fruit, as shown in the following figure.

3. Add the Fruit parameter to the parameter page, bind the parameter to Radio Button Group Widget, as shown in the following figure.

Click the icon in Data Dictionary, set Type to Custom, and customize the options as the sheet tab names, as shown in the following figure.

Note:

The actual values of options in Radio Button Group Widget must be consistent with the sheet names.

Event Adding

Select Radio Button Group Widget and add a State Change event, as shown in the following figure.

The JavaScript code is as follows:

var c = _g().getParameterContainer().getWidgetByName("Fruit");
var s = c.getValue();
_g().loadSheetByName(s);

Effect Preview

Save the template. Click Data Entry Preview or Data Analysis Preview to preview the report. Select a value in the radio button group widget, and you will be redirected to the corresponding sheet page. The following figure shows the effect.

Note:

The effect cannot be previewed on mobile terminals.

For details, you can download the template Clicking Radio Button Groups to Switch Sheets by JS.cpt.