Cannot access edited cell data (event, newlyEditedData, editedData all undefined) in Table Change Cell handler

[MiguelOrtiz]

Hey there @rennielee5 and welcome to the forum!

Shawn is pointing you in the right direction!

Just wanted to also share this post, where I shared a tutorial that may be helpful for you right now. It explains how you can update the variable, and also trigger a query to update your back end. You can easily add another query there to make the other calculations you mentioned.

Make your Retool Table "Feel" like a spreadsheet

It is very common for retool users to want to replicate the look and feel of a "spreadsheet". Although I often advise clients to try and embrace the options that retool gives in terms of adding new records, visualising data and interacting with tables, I also try to replicate the experience that they've had for many many years, i.e. a spreadsheet. On this tutorial I provide some tips on how you can make a Retool Table component "feel more" like a spreadsheet (it will never be a spreadsheet thou…

We're here to help, but as Shawn mentioned, it would be great if you can provide more screenshots, and, in particular with regards to the downstream calculations you're trying to do, maybe sharing a JSON of yorur table's data and what changes you would liek to achive.

Cheers!