# Perspective table data entry

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-data-entry/67774>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [December 19, 2022, 8:02am UTC](https://forum.inductiveautomation.com/t/perspective-table-data-entry/67774 "2022-12-19T08:02:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![avantica](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@avantica](https://forum.inductiveautomation.com/u/avantica)\
**Post date:** [December 19, 2022, 8:02am UTC](https://forum.inductiveautomation.com/t/perspective-table-data-entry/67774/1 "2022-12-19T08:02:53Z")

</div>

Hi all, looking for some advice on designing a view for data entry to be used to insert values into an SQL table. I would like to have a similar grid to an excel table or similar experience.

What is the recommendation? A table component with the editable columns enabled or a flex repeater?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [December 19, 2022, 3:32pm UTC](https://forum.inductiveautomation.com/t/perspective-table-data-entry/67774/2 "2022-12-19T15:32:49Z")

</div>

I use a table for this. you can add buttons to add rows, delete rows, then edit the cells as needed. Once the data is ready, loop over the table data and insert into the DB table.
