# Need Ideas on how to get this done **URL:** \ **Category:** Ignition\ **Created:** [March 11, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013 "2020-03-11T16:36:01Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Post date:** [March 11, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/1 "2020-03-11T16:36:02Z")
I’m using 7.9.10 - I do have SQL Database. I would like to have the option of clicking a button and some type of a spreadsheet pop up that would allow the user to jot down parts that was used for a repair, a description of the problem and a written solution, I want all this stored so that I can query by dates, location names, etc. Can anybody recommend anything? ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [March 11, 2020, 4:51pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/2 "2020-03-11T16:51:28Z")
Check out the Editable Table in: [https://inductiveautomation.com/downloads/extra-material](https://inductiveautomation.com/downloads/extra-material) Setup your table with datatypes long enough (E.g. Varchar (500)) to take text Only allow the current user logged in to edit their own Notes Alternatively just create a script to grab lines of text and add to rows of DB Part of the IA tests is this “notes function” What SQL (Microsoft, My, Maria, etc) are you using? ---
**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Post date:** [March 11, 2020, 4:58pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/3 "2020-03-11T16:58:20Z")
Ok, I do only want the user who created the note to be able to edit only: And as Administrator I want to be able to edit/delete. I and using Microsoft. ---
**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Post date:** [March 11, 2020, 5:03pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/4 "2020-03-11T17:03:15Z")
I downloaded the file which is “Editable Table.vwin” What do I do with this file? ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [March 11, 2020, 5:36pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/5 "2020-03-11T17:36:32Z")
Open designer, go to your main windows folder, right click and import, select the file you downloaded Create a table in SQL (use management studio, drill down database/tables-\> right click new table) Go back to designer and follow the notes on the left of the table ---
**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Post date:** [March 11, 2020, 8:41pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/6 "2020-03-11T20:41:38Z")
Thanks, now this will allow me to add(insert) new records(rows) Right? ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [March 11, 2020, 8:52pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/7 "2020-03-11T20:52:37Z")
Yeah it comes preset with a button to add new rows… delete a row… refresh the data… ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [March 11, 2020, 9:04pm UTC](https://forum.inductiveautomation.com/t/need-ideas-on-how-to-get-this-done/33013/8 "2020-03-11T21:04:45Z")
I would just be creating this as a form in a popup with inputs for the data you want to collect. Then when the user presses OK or submit, you would write the fields into the sql table directly with an insert statement. To view them, create a template and use the template repeater to query the table and show the results. Entering this type of data into a spreadsheet is OK, but it’s not a great feel or aesthetic, especially when you are looking for so much detail.