# Power table dynamic data edit

**URL:** <https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762>\
**Category:** Ignition\
**Created:** [July 7, 2018, 1:38pm UTC](https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762 "2018-07-07T13:38:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![john.eichler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.eichler/32/24632_2.png) [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\
**Post date:** [July 7, 2018, 1:38pm UTC](https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762/1 "2018-07-07T13:38:02Z")

</div>

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](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.

---

<div class="post-metadata">

**Author:** ![john.eichler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.eichler/32/24632_2.png) [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\
**Post date:** [July 8, 2018, 8:53am UTC](https://forum.inductiveautomation.com/t/power-table-dynamic-data-edit/18762/2 "2018-07-08T08:53:14Z")

</div>

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

[http://nickmudge.info/post/ignition-power-tables](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”.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/656c0415fcc55a52e53a62fd15b47fa6ca5bb5d2.png)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4986d32b84b0ed6321467e98a3ea07285efd3cde.png)

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/DOC/Edit+Data+in+Database)

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