kintone table change event handler

1

I have a table with a field code “customer_quotes_table” and a text field with a field code “customer_quote” on the record.

I am implementing a change event listener for the table so that when a quote record is removed from the table, I want to get the quote no. from the deleted record.

When I console debug, I can see that the “changes.row” is null indicating the removal, and “changes.field” is an array containing the remaining records on the table.

How to get quote no. from the deleted row? I need this because I will use quote no. to delete the corresponding record in another table.

Your assistance will be greatly appreciated.

kintone.events.on("app.record.edit.change.customer_quotes_table", function (event) {
  console.log('quotes table change');
  console.log(event);
  if (event.changes.row === null) {
    console.log("row removed..");
  } else {
    console.log("row not removed ...");
  }
});
2

Hi annaylee,

There is no process to identify the removed rows.
Therefore, if you wish to achieve a similar process, please do the following;

  1. Obtain the table information in the record edit screen display event.
  2. Check the change event to determine if the row was deleted.
  3. If it was deleted, compare with the record information of 1 and identify the row.