Identifying the last updated row in table

Queries and Resources
1

Hi, I am trying to record edits of a cell in a table to a database (bigQuery) soon after they happen. Essentially, I am looking to add a new record to the Database table with the updated contents of the cell, using the cell change trigger.

However, I haven't found a way of identifying the row number of the last changed cell. I found that selectedRow can be used when the user presses return after an edit, but is not useful when the user selects a different soon after editing the cell.
Thanks in advance for any pointers.
Pramudi

2

@pramudi

Hey there :wave: One thing you could do is set table.recordUpdates to a temp state variable so that when the user clicks save, even though recordUpdates disappears, you still have access to it. Would this work for your use case?