# Transferring user-entered form info into spreadsheet

**URL:** <https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595>\
**Category:** Ask for Help\
**Created:** [March 19, 2020, 4:51pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595 "2020-03-19T16:51:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jfranklin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jfranklin/32/4394_2.png) [@Jfranklin](https://community.glideapps.com/u/Jfranklin)\
**Post date:** [March 19, 2020, 4:51pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/1 "2020-03-19T16:51:02Z")

</div>

Hello. I have created an app, and I want to put a form in it. I would like to have the information that the user enters saved in the spreadsheet. Is it possible? If yes, how would I do that?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [March 19, 2020, 4:55pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/2 "2020-03-19T16:55:27Z")

</div>

Add a form button.

Click the form button to open the form.

Add fields that correspond to columns in your spreadsheet. The sheet where you want to gather responses will need to have column names (not just a blank sheet), then you can link each form field in the app to a column of the sheet. Each submission of the form will be a new row in your sheet.

---

<div class="post-metadata">

**Author:** ![Jfranklin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jfranklin/32/4394_2.png) [@Jfranklin](https://community.glideapps.com/u/Jfranklin)\
**Post date:** [March 19, 2020, 5:16pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/3 "2020-03-19T17:16:32Z")

</div>

Ok, thank you. It works now.

Is there a way to make the data go into a specific row, or does it have to create a new row to be inserted?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 19, 2020, 5:31pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/4 "2020-03-19T17:31:51Z")

</div>

It just inserts data on the next empty row after the last filled row in the sheet. If you want to edit an existing row, then I would display the details for that existing row and turn on editing.

---

<div class="post-metadata">

**Author:** ![Jfranklin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jfranklin/32/4394_2.png) [@Jfranklin](https://community.glideapps.com/u/Jfranklin)\
**Post date:** [March 19, 2020, 5:49pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/5 "2020-03-19T17:49:44Z")

</div>

How do I display the details for that row?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 19, 2020, 6:11pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/6 "2020-03-19T18:11:29Z")

</div>

Are you currently displaying any existing data in your app? No different than that.

---

<div class="post-metadata">

**Author:** ![Jfranklin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jfranklin/32/4394_2.png) [@Jfranklin](https://community.glideapps.com/u/Jfranklin)\
**Post date:** [March 19, 2020, 7:02pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/7 "2020-03-19T19:02:59Z")

</div>

Ok, thank you. How do I make the data in a box on a sheet show different lines on the app?  
In the template, it shows 2 “#” in front of each element, but I tried that in my spreadsheet, and it didn’t work.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [March 19, 2020, 7:08pm UTC](https://community.glideapps.com/t/transferring-user-entered-form-info-into-spreadsheet/5595/8 "2020-03-19T19:08:09Z")

</div>

@Jfranklin have you watched the videos and followed any of the tutorials or checked out our documentation? [https://docs.glideapps.com/](https://docs.glideapps.com/)

In the forum, you should post a new topic per question when you cannot find the answer, but please don’t ask question after question in the same topic–this is not what the forum is for.
