# Insert blank lines in the google sheet when submitting the form
**URL:** https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604
**Category:** Ask for Help
**Created:** [December 9, 2022, 3:20pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604 "2022-12-09T15:20:33Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Dorian\_Libotte](https://community.glideapps.com/u/Dorian_Libotte)
#### Post date: [December 9, 2022, 3:20pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/1 "2022-12-09T15:20:33Z")
Hello, I have a form on my application and when I submit it it fills a google sheet and I just saw that between 2 forms that I submitted about 400 empty lines are created but that in the google sheet, on glide the empty lines do not appear (this is not from today but I just noticed) knowing that I can submit the form if I have all the fields filled, would you have any idea what happened?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 9, 2022, 3:22pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/2 "2022-12-09T15:22:05Z")
Are you using any arrayformulas in that sheet?
---
### Author:  [@Dorian\_Libotte](https://community.glideapps.com/u/Dorian_Libotte)
#### Post date: [December 9, 2022, 3:34pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/3 "2022-12-09T15:34:39Z")
No I don’t have arrayformulas
---
### Author:  [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)
#### Post date: [December 9, 2022, 4:14pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/4 "2022-12-09T16:14:48Z")
I used to have this too.
I deleted all the empty lines in the sheet and it fixed it.
Hope this helps
---
### Author:  [@Dorian\_Libotte](https://community.glideapps.com/u/Dorian_Libotte)
#### Post date: [December 9, 2022, 4:19pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/5 "2022-12-09T16:19:51Z")
Since I don’t know how it happened I’m afraid that if I fix it it will come back in the future, do you know how you got it?
---
### Author:  [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)
#### Post date: [December 9, 2022, 4:26pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/6 "2022-12-09T16:26:33Z")
I think it happened when I started deleting rows directly from the Glide data editor and at the same time from the sheet.
I’m not sure.
But its been more than 6 months and it did not come back.
I just make sure the in every sheet the last row has data and I have no empty row in between.
---
### Author:  [@Dorian\_Libotte](https://community.glideapps.com/u/Dorian_Libotte)
#### Post date: [December 9, 2022, 5:01pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/7 "2022-12-09T17:01:59Z")
Okay thank you very much to you, I will do that and see if it comes back.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [December 10, 2022, 5:02pm UTC](https://community.glideapps.com/t/insert-blank-lines-in-the-google-sheet-when-submitting-the-form/55604/8 "2022-12-10T17:02:40Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.