Custom Column Insertion or Deletion Button

Problem

Two options are available for row insertion and deletion buttons by default, namely Insert Row and Delete Row.

In this case, how to achieve the effect of inserting and deleting columns as shown in the following figure?

Implementation Method

The buttons for inserting and deleting rows identify the data that needs to be inserted or deleted based on the parent-child cell relationship. Therefore, you still need to use Insert Row and Delete Row in Button Type and set the parent cell to meet your needs of inserting and deleting columns.

Note:

You cannot insert or delete columns when the expansion direction of fields is vertical.

Data Entry Template Design

1. Create a database query dataset ds1 with the SQL statement SELECT * FROM Sales.

2. To design the data entry table, add text widgets for cells B3 to B8, set Expansion Direction to Horizontal for cells B3 to B8, and drag the dataset fields into the corresponding cells, as shown in the following figure.

Column Insertion Button Setting

Select cell B2 and add a button widget for the cell. Select Insert Row from the drop-down list of Button Type, set Button Name to Insert Column, set Specified Cell to B3, and retain the default setting of other items, as shown in the following figure.

Column Deletion Button Setting

Select cell B1 and add a button widget for the cell. Select Delete Row from the drop-down list of Button Type, set Button Name to Delete Column, set Specified Cell to B3, and retain the default setting of other items, as shown in the following figure.

Parent Cell Setting

1. Select cell B3 and set Up Parent Cell to None, as shown in the following figure.

2. Set Up Parent Cell to cell B3 for cells B1 and B2, as shown in the following figure.

Effect Display

PC

Save the report and click Data Entry Preview. The following figure shows the preview effect.

Mobile Terminal

The report can be previewed on the DataAnalyst app and the H5 terminal. The following figure shows the effect.

You can download the template Custom Column Insert or Deletion Button.cpt.