# Form Entries appear on the bottom of the spreadsheet

**URL:** <https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781>\
**Category:** Report a Bug\
**Created:** [December 11, 2019, 5:23am UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781 "2019-12-11T05:23:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![YogeshBansal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yogeshbansal/32/1955_2.png) [@YogeshBansal](https://community.glideapps.com/u/YogeshBansal)\
**Post date:** [December 11, 2019, 5:23am UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781/1 "2019-12-11T05:23:52Z")

</div>

My app’s URL: [https://beasport2.glideapp.io](https://beasport2.glideapp.io)

Hello, All form entries appear at the bottom of the spreadsheet.

---

<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:** [December 11, 2019, 5:33am UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781/2 "2019-12-11T05:33:55Z")

</div>

This isn’t a bug, it’s how Google Sheets works and it’s documented in our documentation.

---

<div class="post-metadata">

**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\
**Post date:** [December 11, 2019, 5:38am UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781/3 "2019-12-11T05:38:03Z")

</div>

What @david is saying is correct. Anytime you submit a form using the Form functionality in Glide, and also in Google Sheets, the information you capture in each of the fields is appended to the end of the spreadsheet.

If you are looking for a way to edit data already in your spreadsheet through Glide, you can use the Add/Edit screens for each of your tabs instead.

Hope this helps. 👍

---

<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:** [December 11, 2019, 6:19am UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781/4 "2019-12-11T06:19:48Z")

</div>

If you are using arrayformulas, be sure to delete any empty rows. Any rows that have any formulas in them will be considered filled rows and new data will be written on the first available empty row.

> [@Newly added rows do not extend formula columns, leaving some calculated columns empty](https://community.glideapps.com/t/newly-added-rows-do-not-extend-formula-columns-leaving-some-calculated-columns-empty/418):
>
> When a new value is added using the icon, lines containing formulas or functions are not written data, but a new line is created at the end of the worksheet. My app’s URL: [https://go.glideapps.com/play/xEresFO3nbR7mDEAhF8G](https://go.glideapps.com/play/xEresFO3nbR7mDEAhF8G)

---

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [December 30, 2019, 9:54pm UTC](https://community.glideapps.com/t/form-entries-appear-on-the-bottom-of-the-spreadsheet/2781/5 "2019-12-30T21:54:23Z")

</div>

one fix i use is deleting all empty rows so a new row only appears when there is a new form entry or us the following to run the formula the length of the sheet

=arrayformula(if(len(A2:a)=0,", then insert your formula here))