Record Value Changes in the Sheet

By using actions, cell values changes in a specified sheet can be recorded, and the addresses of changed cells can be retrieved.
By utilizing this addresses information, you can create a process to efficiently update the changed data.

See also

If you want to learn more about how to update data using the actions on this page, see 一覧データの更新 .

Start sheet value change recording

  1. Open the 'Action set settings' dialog.
  2. Drag the 'In sheet[]: Start recording value changes' action from the 'Sheet' tab and set it in the edit area.
../../../../_images/img_01.en48.png
  1. To target another sheet in the application, click the 'Select sheet' button.
../../../../_images/img_02.en46.png
  1. Select the target sheet in the 'Select sheet' dialog, then click the 'OK' button.
../../../../_images/img_03.en36.png

Attention

When the action is executed, if the selected sheet does not exist in the application, this action will be skipped.

Tip

  • The recorded cell addresses can be displayed by using the action 'In sheet[]: Get the [cells/rows/columns] with changed values'.
  • To end the recording, execute the 'In sheet[]: End recording value changes' action or close the sheet.
  • If you execute this action again without executing the 'In sheet[]: End recording value changes' action, the previous records will be discarded and recording will start from scratch.

Attention

  • The cells to be recorded are those whose values have changed after this action is executed.

  • Changes to cell formatting (such as display format) are not recorded.

  • For cells containing formulas, even if the formula’s evaluation result changes, it will not be recorded unless the formula itself is modified.

    For example, if you enter '=A1' in cell B1 and change the value of cell A1, only cell A1 is recorded, and cell B1 is not recorded.
    Please note that only changes to 'the cell content itself' are recorded.

End sheet value change recording

  1. Open the 'Action set settings' dialog.
  2. Drag the 'In sheet[]: End recording value changes' action from the 'Sheet' tab and set it in the edit area.
../../../../_images/img_04.en35.png
  1. To target another sheet in the application, click the 'Select sheet' button.
../../../../_images/img_05.en31.png
  1. Select the target sheet in the 'Select sheet' dialog, then click the 'OK' button.
../../../../_images/img_03.en36.png

Attention

When the action is executed, if the selected sheet does not exist in the application, this action will be skipped.

Attention

When you execute this action, not only will the recording end, but the recorded cell changes will also be deleted.
Please note that after executing this action, even if you run the 'In sheet[]: Get the [cells/rows/columns] with changed values' action, no change records will be retrieved.

Get the cells with value changes from the sheet value change recording

  1. Open the 'Action set settings' dialog.
  2. Drag the 'In sheet[]: Get the [cells/rows/columns] with changed values' action from the 'Sheet' tab and set it in the edit area.
../../../../_images/img_06.en24.png
  1. To target another sheet in the application, click the 'Select sheet' button.
../../../../_images/img_07.en23.png
  1. Select the target sheet in the 'Select sheet' dialog, then click the 'OK' button.
../../../../_images/img_03.en36.png

Attention

When the action is executed, if the selected sheet does not exist in the application, this action will be skipped.

  1. Select the cell address type for retrieving changed cells.
../../../../_images/img_08.en20.png

Tip

  • Changed cells can be retrieved in 'Cell', 'Row', or 'Column' format.

  • If you specify row or column, the entire row or column containing the changed cells will be retrieved.

    For example, if cells A1 and B1 have been changed and retrieved in 'Row' format, the output result will be row number '1'.
  1. To filter the cells to retrieve, check 'Get the cells with changes from the specified cells:'.
../../../../_images/img_09.en16.png

Tip

You can specify multiple ranges or single cell addresses separated by commas. For example, for a sheet with a list table, you can filter and retrieve only cells that have been changed inside the table or only cells that have been changed outside the table.

  1. Specify the destination cell for the output results.
../../../../_images/img_10.en14.png

Tip

Display the cells with changes, starting from the specified cell.

If you perform the following operations, the cell address of the retrieved result will be the location after the operation.

  • [When inserted a row (or column)]

    If you insert a row before the changed cell address, the retrieved cell address will be the cell address after being shifted down.
    Example: If you change the value of cell A2 and insert a row at row 2, the retrieved cell address will be A3.
    ../../../../_images/img_11.en12.png

  • [When deleted a row (or column)]

    If you delete a row before the changed cell address, the retrieved cell address will be the cell address after being shifted up.
    Example: If you change the value of cell A3 and delete row 2, the retrieved cell address will be A2.
    ../../../../_images/img_12.en11.png

    Attention

    Please note that if you delete the row (or column) of a changed cell, that cell address will not be included in the retrieved results.

  • [When filter sorting is applied]

    If the changed cell address is sorted, the retrieved result will be the cell address after sorting.
    Example: If you change the value of cell A3 and perform a descending sort with filter, the retrieved cell address will be A2.
    ../../../../_images/img_13.en8.png