# Glide page doesn't update the gsheet when I use add function **URL:** \ **Category:** Ask for Help\ **Created:** [September 23, 2022, 7:29am UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982 "2022-09-23T07:29:40Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![ToPe](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@ToPe](https://community.glideapps.com/u/ToPe)\ **Post date:** [September 23, 2022, 7:29am UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/1 "2022-09-23T07:29:40Z")
I’ve used Glide 2 years ago and had no similar problems. Now I would use the page version, but in the case of the add action function, the google sheet is not updated (there is no new record). If an existing record is modified from Glide, the update runs fine. The new added record is visible inside the Glide, but not in the table. I tried closing it and leave open the table, but nothing happened. Snyc setting is on normal and I am far from the 1000 update monthly limit. What could be the problem? Thank you for your help ---
**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:** [September 23, 2022, 12:09pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/2 "2022-09-23T12:09:53Z")
Have you tried scrolling to the very bottom of your google sheet? ---
**Author:** ![ToPe](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@ToPe](https://community.glideapps.com/u/ToPe)\ **Post date:** [September 23, 2022, 12:13pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/3 "2022-09-23T12:13:57Z")
There are only 4 record 🙂 This would have been the fifth ---
**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:** [September 23, 2022, 12:18pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/4 "2022-09-23T12:18:15Z")
So nothing at the very bottom of the sheet? ---
**Author:** ![ToPe](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@ToPe](https://community.glideapps.com/u/ToPe)\ **Post date:** [September 23, 2022, 12:26pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/5 "2022-09-23T12:26:08Z")
Oooo, you are right! 🙂 Thanks! The added record is on line 50472. Why does it work this way? ---
**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:** [September 23, 2022, 12:28pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/6 "2022-09-23T12:28:37Z")
You are most likely using an Arrayformula. That makes all rows populated rows (even though they may seem to be empty) so glide will not overwrite them. What’s happening is it’s adding a new row to the sheet. Delete all of the rows that are empty. You should only have 5 visible rows in your sheet. ---
**Author:** ![ToPe](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@ToPe](https://community.glideapps.com/u/ToPe)\ **Post date:** [September 23, 2022, 12:43pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/7 "2022-09-23T12:43:31Z")
Yes I use arrayformula (exp. arrayformula(F2:F) . I deleted the empty rows and it’s working right now. Is it advisable to enter a fixed value in the arrayformula 2nd parameter exp: arrayformula (F2:F100)) ? Thank you for your help! 🙏 ---
**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:** [September 23, 2022, 6:28pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/8 "2022-09-23T18:28:56Z")
No, you would have the same problem if you used a fixed value. The way you have it with F2:F is better since you’re not limiting your formula to a certain number of rows. Ideally, if you can replicate the same formula using Glide computed columns, then you don’t have to use a sheet formula, and you won’t have any delays waiting for the sheet to re-sync with Glide. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 24, 2022, 6:28pm UTC](https://community.glideapps.com/t/glide-page-doesnt-update-the-gsheet-when-i-use-add-function/49982/9 "2022-09-24T18:28:56Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.