# Automatically insert data in Power Table

**URL:** <https://forum.inductiveautomation.com/t/automatically-insert-data-in-power-table/89906>\
**Category:** Ignition\
**Tags:** ignition79, database, scripting, vision\
**Created:** [May 3, 2024, 6:07pm UTC](https://forum.inductiveautomation.com/t/automatically-insert-data-in-power-table/89906 "2024-05-03T18:07:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mia\_Galatis](https://avatars.discourse-cdn.com/v4/letter/m/f14d63/32.png) [@Mia\_Galatis](https://forum.inductiveautomation.com/u/Mia_Galatis)\
**Post date:** [May 3, 2024, 6:07pm UTC](https://forum.inductiveautomation.com/t/automatically-insert-data-in-power-table/89906/1 "2024-05-03T18:07:31Z")

</div>

Hi, I want to automatically insert data into a database I have during certain times. Is this possible? For example, at 9am everyday, I want it to insert a new row with certain values into my power table.

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [May 3, 2024, 6:44pm UTC](https://forum.inductiveautomation.com/t/automatically-insert-data-in-power-table/89906/2 "2024-05-03T18:44:38Z")

</div>

That is exactly what the SQL Bridge module and Transaction Groups are for. Or alternatively scripting the data into the database from a gateway event.

You would use them to insert the data, and then have the PowerTable refresh on a schedule, or have a tag that triggers a refresh on the table.