# How to alter data from a table?

**URL:** <https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230>\
**Category:** Ignition\
**Created:** [October 21, 2019, 7:35am UTC](https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230 "2019-10-21T07:35:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sac](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sac/32/11370_2.png) [@sac](https://forum.inductiveautomation.com/u/sac)\
**Post date:** [October 21, 2019, 7:35am UTC](https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230/1 "2019-10-21T07:35:03Z")

</div>

I have a table which is showing some data from my database. I’d like to modify the data from the table. I see that there is a allowEditOn property for the table and permissible values are single-click, double-click and long-press.  
However, I am not able to edit the table on any of these values. What else do I have to do to make the table editable.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 21, 2019, 1:20pm UTC](https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230/2 "2019-10-21T13:20:16Z")

</div>

You have to write a script to update the database table. Right click on the table, and select configure events. Choose the **onCellEditCommit** and add a script to that event to update the database. I’m not very familiar with Perspective yet, so try the [manual entry on tables.](https://docs.inductiveautomation.com/display/DOC80/Perspective+-+Table)