# Add row to power table?

**URL:** <https://forum.inductiveautomation.com/t/add-row-to-power-table/10032>\
**Category:** Ignition\
**Created:** [May 18, 2015, 8:45pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032 "2015-05-18T20:45:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![fledder](https://avatars.discourse-cdn.com/v4/letter/f/e19b73/32.png) [@fledder](https://forum.inductiveautomation.com/u/fledder)\
**Post date:** [May 18, 2015, 8:45pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032/1 "2015-05-18T20:45:13Z")

</div>

Am I missing something? I don’t see a way to add a row to a power table…

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 18, 2015, 8:58pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032/2 "2015-05-18T20:58:26Z")

</div>

Could you give a context?

Through the dataset viewer?  
Programmatically?  
Using drag and drop?

---

<div class="post-metadata">

**Author:** ![fledder](https://avatars.discourse-cdn.com/v4/letter/f/e19b73/32.png) [@fledder](https://forum.inductiveautomation.com/u/fledder)\
**Post date:** [May 18, 2015, 9:27pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032/3 "2015-05-18T21:27:10Z")

</div>

Sorry, yes. I have a power table I’ve linked to a SQL query to show a table I’m interested in editing. I have editing turned on, and I’d like to add another row during runtime to the table (an INSERT rather than an UPDATE) but can’t seem to figure out how. Is that possible? (e.g. like Access where you have the blank row at the bottom for adding a record)

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [May 18, 2015, 10:24pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032/4 "2015-05-18T22:24:08Z")

</div>

The table component is going to return the data that is in the database. Since there isn’t an empty record in the database at the bottom of the table you will need to create one. You can run an insert query from a button press and have it insert a new record that contains no data. You could then edit the cells in the table that would update the record in the database.

---

<div class="post-metadata">

**Author:** ![fledder](https://avatars.discourse-cdn.com/v4/letter/f/e19b73/32.png) [@fledder](https://forum.inductiveautomation.com/u/fledder)\
**Post date:** [May 18, 2015, 10:43pm UTC](https://forum.inductiveautomation.com/t/add-row-to-power-table/10032/5 "2015-05-18T22:43:02Z")

</div>

Got it. Thanks!