Hello everyone.
I am working on perspective and I have a table with a data binding and a transform script- it also has json as a return format. I made sure that the columns and rows are editable. I also have the onEditcellCommit script. I get no errors when I go in on a cell to make changes and then click enter and my database is not updating on edit cell commits.
I'm not sure if I'm forgetting something or maybe it has something to do with the json format?
You are just updating the prop data. That doesn't understand how to insert the data into the database.
You will need to write in that script the logic to update the database as well, using something like system.db.runPrepUpdate.
In the oneditCellcommit?
Yep.
I'll generally lookup the ID with the event.row data, and then use the event.column and event.value to update the database.
If an error occurs, refresh the props so the data stays consistent.
Thank you so much for your help! 
