Process Multiple Rows Data

Here is the way to process each row with loop one by one to multi rows data.

As a example, it is the detail to create action set to register name list into Name table one by one.

Prepare To Register Multiple Row Data Process

1. Prepare data registration list and 'Register' button in application sheet.

2. To set loop process, you need cell to manage information in the middle of operation. So it is necessary to prepare the cell to manage operation information.

[1] Register data name column (E3)

It is the cell to manage column to set name. The name is in B column, and so input as 'B'.

[2] Data starting row (E4)

It is the cell to manage row number to start operation. Starting row is 4th, and so input as '4'.

[3] Cell reference counter variable

It is the cell to use managing row in use in actions. The value is updated in action set.

[4] Current reference cell address (E7)

It is the cell to save cell in the middle of process in action.

After joining target column number (value in above [1]) and row number (value in above [3]), input formula ('=E3&E6') to return characters to suggest cell.

By this, 'B6' value is retained if Register data name column is 'B' and 'Cell reference counter variable' is '6'.

[5] Current reference value (E8)

It is cell to retail value with processing in the action.

Input formula ('=INDIRECT(E7)') to display cell value 'Current reference cell address' suggests.

By this, if 'Current reference cell address' is 'B6', B6 cell value is retained.

By 'Counter variable for refering cell' value, value of 'Cell reference counter variable' cell or 'Current reference value' cell is decided like this.

Hint

• These management cells retain unnecessary information for application user, it is easier to see for application user to hide column at publication.
• To use INDIREC function can get cell value from characters to suggest cell like 'A1' or 'D6'.(Example:INDIRECT("A1") )

Tip

There is a utility (UTIL.CELLV function) to get the cell value by specifying the row number and column number (number or column name) in CELF.

Using the UTIL.CELLV function, the value can be obtained in the same way by writing '=UTIL.CELLV(E6, E3)' for 'Current reference value' (E8)

(In this case, the 'Current reference cell address' (E7) is no longer needed.)

Create Action Set For Multiple Rows Processing

1. Create new action set, and then open 'Action set setting' dialog.
2. Set value of 'Data starting row' cell (E4) into 'Cell reference counter variable' cell (E6) to be equal initial value of counter with starting row of counter.

3. To register multiple row data, set 'Batch execution of data updates' action.

See also

Regarding the way to control transaction at multiple data registration, refer Control Transaction.

4. Set 'While do' action for loop process.

5. You can set as end condition for loop process if 'Current reference value' (E8) is empty or not. (E8)

6. Set 'Insert data to table' action. Value of 'Current reference value' cell (E8) is set to register.

Tip

Create 'dummy_name' table as a table to register, just 'NAME' column is defined in the table.

7. After 1 record registration, Add 1 value of 'Cell reference counter variable' cell (E6) to move 1 row lower for target process data.

8. To remind completing process, set 'Pop-up the following message' action.

9. Save action set, and then set to 'Register' button.

Execute process for registering multiple data count

1. Click 'Register' button.
2. Completing message to register is displayed with pop-up.

Confirmed to be registered into NAME table.