Slow Loading of the Data Entry Page Caused by Too Many Button Widgets

Problem

When you set button widgets that follow data expansion in a template, and the data volume is large, the page will be loaded slowly due to the slow rendering speed of the button widgets.

Solution

In some scenarios, hyperlinks can be used to replace buttons to achieve certain functions, such as inserting and deleting rows.

Designing the Template

Design the template, as shown in the following figure:

Setting the Hyperlink for Inserting a Row

Select cell D2, and add a hyperlink of the JavaScript (JS) type. Add a parameter in the Parameter area, with the parameter name set to row, and the parameter value set to =row()-1.

The JS code is as follows:

var cell=FR.columnRow2CellStr({col:0, row:row});
//Get the cell ID of the first column in the current row.
_g().appendReportRC(1,cell);
//Insert a row. Ensure that the value of the cell parameter is set to the root parent cell.

Setting the Hyperlink for Deleting a Row

Select cell E2, and add a hyperlink of the JS type. Add a parameter in the Parameter area, with the parameter name set to row, and the parameter value set to =row()-1.

The JS code is as follows:

var cell=FR.columnRow2CellStr({col:0, row:row});
//Get the cell ID of the first column in the current row.
_g().deleteReportRC(cell);
//Delete a row. Ensure that the value of the cell parameter is set to the root parent cell.

Note:

The row deletion action only removes the data from the data entry page and will not affect the database data before submission.

Setting the Policy of Inserting a Row

Select cells D2 and E2, and set Row Insert Policy to Original.

Effect Display

Download the template by clicking Inserting or Deleting a Row by Hyperlinks with JS.cpt.