# Not reflected on google sheet

**URL:** <https://community.glideapps.com/t/not-reflected-on-google-sheet/3348>\
**Category:** Report a Bug\
**Created:** [January 6, 2020, 1:57am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348 "2020-01-06T01:57:53Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![ehattori](https://avatars.discourse-cdn.com/v4/letter/e/cc9497/32.png) [@ehattori](https://community.glideapps.com/u/ehattori)\
**Post date:** [January 6, 2020, 1:57am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/1 "2020-01-06T01:57:53Z")

</div>

After January 1, 2020, data input from form screen is not reflected on google sheet.

---

<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:** [January 6, 2020, 2:06am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/2 "2020-01-06T02:06:29Z")

</div>

Did you look at the very bottom of the sheet?

There are countless posts about this.

> [@Issue With Google Sheets](https://community.glideapps.com/t/issue-with-google-sheets/3339):
>
> My app’s URL: [https://shalomorocco.glideapp.io](https://shalomorocco.glideapp.io) I created an application with glide and did some testing yesterday and it worked well. Today, when I fill out my form via the application, the data is not synchronized on google sheets. I see them on the data menu of the application but not on Google Sheets Anyone can help me please ?

---

<div class="post-metadata">

**Author:** ![ehattori](https://avatars.discourse-cdn.com/v4/letter/e/cc9497/32.png) [@ehattori](https://community.glideapps.com/u/ehattori)\
**Post date:** [January 6, 2020, 2:15am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/3 "2020-01-06T02:15:47Z")

</div>

The data row exists but contains no values.

I checked the form screen and found that the data entry fields were lost. The form screen has not been modified recently.

---

<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:** [January 6, 2020, 3:29am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/4 "2020-01-06T03:29:23Z")

</div>

Can you make a video of the bug please?

---

<div class="post-metadata">

**Author:** ![ehattori](https://avatars.discourse-cdn.com/v4/letter/e/cc9497/32.png) [@ehattori](https://community.glideapps.com/u/ehattori)\
**Post date:** [January 6, 2020, 4:19am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/5 "2020-01-06T04:19:07Z")

</div>

The input fields and display fields of the form that should have been set on the GlideApps screen have been lost, and have been restored by setting them again.

As a result, they misunderstood that the data rows in Google Sheets were not reflected.

I don’t know why the configured fields disappeared from the GlideApps app screen. It is difficult to reproduce and cannot be recorded on video. Excuse me.

---

<div class="post-metadata">

**Author:** ![periclesr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/periclesr/32/1131_2.png) [@periclesr](https://community.glideapps.com/u/periclesr)\
**Post date:** [January 6, 2020, 6:22pm UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/6 "2020-01-06T18:22:17Z")

</div>

Same problem here!

---

<div class="post-metadata">

**Author:** ![arod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arod/32/881_2.png) [@arod](https://community.glideapps.com/u/arod)\
**Post date:** [January 9, 2020, 3:56pm UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/7 "2020-01-09T15:56:42Z")

</div>

I had the exact problem. New data was reflected on the app (and on the Data tab on the builder) but not on Google Sheets.

I scrolled down (about 100 rows +/-) and found the data inputs. Not sure why or how this happened. What I did right after was deleting all the “excess” rows, so that freshly inputted data (in the app) does not wonder off too far 😉

---

<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:** [January 10, 2020, 12:13am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/8 "2020-01-10T00:13:09Z")

</div>

@arod What you did is the proper solution. Usually it’s arrayformula’s that cause new rows to go to the bottom of the sheet. Even if a row appears empty, any formulas that populate a column make any available rows be considered filled. Glide/Google doesn’t want to write new data to populated rows, so it creates a new row at the bottom.

---

<div class="post-metadata">

**Author:** ![arod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arod/32/881_2.png) [@arod](https://community.glideapps.com/u/arod)\
**Post date:** [January 15, 2020, 3:36am UTC](https://community.glideapps.com/t/not-reflected-on-google-sheet/3348/9 "2020-01-15T03:36:40Z")

</div>

Awesome!!
