Power table dynamic data edit

Ignition
1

ignition 7.9.

Hi

I’m following these guidelines for editing an SQL db through a Power table.

https://docs.inductiveautomation.com/display/DOC79/Updating+the+Database+through+the+Power+Table

I can get it to work fine but please can someone show me how to make the table name dynamic? I want to put this table in a template so I can use it as part of a recipe editor. Ideally, I would like this to a string property on the template.

thanks.

2

I have solved the issue with the help of this page.

http://nickmudge.info/post/ignition-power-tables

I have an “EDIT DATA” button which uses some of the code in the above link. It iterates through the column names and builds a new column attributes table. This table contains a field called “editable”.

screenshot.png1152×254 7.41 KB

screenshot edit mode.png1153×260 7.96 KB

I also used code from the following links to create the “add row” and “delete row” buttons.

https://docs.inductiveautomation.com/display/DOC/Edit+Data+in+Database

https://docs.inductiveautomation.com/display/DOC79/Updating+the+Database+through+the+Power+Table