# Manual Entry from Persp.Table to MySQL

**URL:** <https://forum.inductiveautomation.com/t/manual-entry-from-persp-table-to-mysql/89854>\
**Category:** Ignition\
**Tags:** database, perspective\
**Created:** [May 2, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/manual-entry-from-persp-table-to-mysql/89854 "2024-05-02T20:00:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jorge\_Rocha](https://avatars.discourse-cdn.com/v4/letter/j/49beb7/32.png) [@Jorge\_Rocha](https://forum.inductiveautomation.com/u/Jorge_Rocha)\
**Post date:** [May 2, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/manual-entry-from-persp-table-to-mysql/89854/1 "2024-05-02T20:00:31Z")

</div>

In a Perspective Table that displays alarms from a conveying system, I am looking to add a functionality that allows users to input notes directly into each row, such as "Emergency stop pressed by accident." These notes should be stored alongside the existing data in MySQL.

Specifically, I need assistance on enabling row editing for user comments and scripting the process to write these entries to the database.

 ![ConveyorFaults](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/8/589ba3274b52783100c4fff999a49eb43abe602b.png)

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [May 2, 2024, 9:50pm UTC](https://forum.inductiveautomation.com/t/manual-entry-from-persp-table-to-mysql/89854/2 "2024-05-02T21:50:24Z")

</div>

You can set the notes column to editable like this:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/d/ad3fc539d05d2a8b4262d96576616bce8652bdb2.png)

I would create your sql update statement in a named query then run it with [system.db.runNamedQuery](https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runNamedQuery) in the table's `onEditCellCommit` component event. Refresh the table after you run the query with `self.refreshBinding('props.data')`

> **[Perspective Component Methods | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/perspective/scripting-in-perspective/perspective-component-methods#refreshing-bindings)**
>
> A component method is a function that is defined on a component object. For example, this is how we would call a component method defined on the component object self:

---

<div class="post-metadata">

**Author:** ![Jorge\_Rocha](https://avatars.discourse-cdn.com/v4/letter/j/49beb7/32.png) [@Jorge\_Rocha](https://forum.inductiveautomation.com/u/Jorge_Rocha)\
**Post date:** [May 4, 2024, 12:27am UTC](https://forum.inductiveautomation.com/t/manual-entry-from-persp-table-to-mysql/89854/3 "2024-05-04T00:27:29Z")

</div>

Thank you I will try and let you know