# Changes on Cell Commit Don't go Through

**URL:** <https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 12, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762 "2024-06-12T16:48:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Villasenor\_Es](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/miguel_villasenor_es/32/60416_2.png) [@Miguel\_Villasenor\_Es](https://forum.inductiveautomation.com/u/Miguel_Villasenor_Es)\
**Post date:** [June 12, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762/1 "2024-06-12T16:48:39Z")

</div>

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?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/e/2e27c67bcd21e5074335f6ca4b5f6f3af0583009.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ffce3aa4d8e13a0e3fa1f8672eafaa3c1bdc7a03.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/7/57b2c1730e0e961eb0aab935508e5791548cdba4.png)

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [June 12, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762/2 "2024-06-12T16:50:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Miguel\_Villasenor\_Es](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/miguel_villasenor_es/32/60416_2.png) [@Miguel\_Villasenor\_Es](https://forum.inductiveautomation.com/u/Miguel_Villasenor_Es)\
**Post date:** [June 12, 2024, 4:51pm UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762/3 "2024-06-12T16:51:40Z")

</div>

In the oneditCellcommit?

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [June 12, 2024, 5:03pm UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762/4 "2024-06-12T17:03:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Miguel\_Villasenor\_Es](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/miguel_villasenor_es/32/60416_2.png) [@Miguel\_Villasenor\_Es](https://forum.inductiveautomation.com/u/Miguel_Villasenor_Es)\
**Post date:** [June 13, 2024, 11:41am UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762/5 "2024-06-13T11:41:45Z")

</div>

Thank you so much for your help! 🙂