# User input data goes in row 455 rather than next empty row

**URL:** <https://community.glideapps.com/t/user-input-data-goes-in-row-455-rather-than-next-empty-row/15680>\
**Category:** Feature Requests\
**Created:** [September 12, 2020, 8:58am UTC](https://community.glideapps.com/t/user-input-data-goes-in-row-455-rather-than-next-empty-row/15680 "2020-09-12T08:58:03Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 12, 2020, 9:32am UTC](https://community.glideapps.com/t/user-input-data-goes-in-row-455-rather-than-next-empty-row/15680/4 "2020-09-12T09:32:52Z")

</div>

Because you already have data for those lines, it will not be messed with by Glide, Glide must use a complete empty row to input new data.

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 
> 
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …

Use arrayformula and give those a null value instead of a 0 here.

---

_[View the full topic](https://community.glideapps.com/t/user-input-data-goes-in-row-455-rather-than-next-empty-row/15680)._
