Manual Entry from Persp.Table to MySQL

Ignition
,
1

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
ConveyorFaults1909×171 10.3 KB

2

You can set the notes column to editable like this:
image

I would create your sql update statement in a named query then run it with system.db.runNamedQuery in the table's onEditCellCommit component event. Refresh the table after you run the query with self.refreshBinding('props.data')

3

Thank you I will try and let you know