# Some questions about "Sheet edits"

**URL:** <https://community.glideapps.com/t/some-questions-about-sheet-edits/26927>\
**Category:** Ask for Help\
**Created:** [May 18, 2021, 4:54pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927 "2021-05-18T16:54:55Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [May 18, 2021, 4:54pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/1 "2021-05-18T16:54:55Z")

</div>

Hello,  
I have some questions about “sheet edits” and their account. Indeed, I use one of my apps with my club and I see the sheet edits account scrolling very quickly while most of the data is static. The only modifications to the sheet should be the additions of administrators’ data (rare because I am the only administrator) and the record of absences via a form (around 10 per week).  
However, I observed that after connections the Google Sheet workbook auto-reloads every minute for about an hour then every hour for about two days which causes several dozen “sheet edits”. Even when I modify the settings of Google Sheets to force a reload that after a modification it comes back on its own on frequent automatic reloads.

Did you make the same observations?

Is something in my sheet causing these reloads?

---

<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:** [May 18, 2021, 5:28pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/2 "2021-05-18T17:28:28Z")

</div>

Do you keep your google sheet open in a browser tab? Do you observe a slowdown in counts if you close the sheet?

> [@Sheet Edits Quota—1000 per month?](https://community.glideapps.com/t/sheet-edits-quota-1000-per-month/12907/100):
>
> @mthakershi I will reset your edits. While your Google Sheet is open in Chrome, it continuously sends data updates to Glide, which is what is being measured here.

Do you have any actions that may be incrementing a count, or some other action by the user that may be updating a value behind the scenes, but they are not directly making updates to data?

Do you keep the app open with background refresh turned on? Not sure if that makes a difference, but could be contributing to the count.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [May 18, 2021, 7:24pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/3 "2021-05-18T19:24:39Z")

</div>

No, i don’t keep Google Sheet open in a browser.  
I don’t think to have any actions that may explain this count. Some automatic reloads of the Google Sheets arrive at the middle of the night when nobody use the app. I don’t use any function with “now”…  
I don’t keep the app open with refresh turned on.

---

<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:** [May 18, 2021, 7:28pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/4 "2021-05-18T19:28:20Z")

</div>

Not really sure then. Those were the only thoughts I had.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [May 18, 2021, 7:44pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/5 "2021-05-18T19:44:57Z")

</div>

I don’t understand these automatical reloads whereas my app isn’t PRO.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [May 19, 2021, 6:44am UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/6 "2021-05-19T06:44:26Z")

</div>

Nobody has noted that ?

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 6, 2021, 9:50am UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/7 "2021-06-06T09:50:19Z")

</div>

In just 6 days my app counted more than 200 sheet edits while only one change occurred on the Google sheet via a form.  
So I have a few new questions to try to understand this phenomenon:

1. Can a Computed column cause a sheet edit?
2. Can a user-specific column cause a sheet edit?
3. Does anyone have an idea as to why sheet edits occur in the middle of the night when no one is using the app?  
If you have any leads, I am interested.

---

<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:** [June 6, 2021, 12:54pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/8 "2021-06-06T12:54:45Z")

</div>

Computed columns only compute on the user’s device. There is no server interaction for computed columns to work. So that shouldn’t affect sheet edits.

User Specific Columns only live on a user’s device if they are not signed in, or on Glide’s server in they are signed in, but never lives on the google sheet, so shouldn’t affect sheet edits.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 7, 2021, 10:32am UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/9 "2021-06-07T10:32:16Z")

</div>

A lot of sheet edits whereas no modifications

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c5e227ee98d1419bef4dddd539e0fbdf6deb2da.jpeg "GlideApp Sheet Edit") ](https://www.youtube.com/watch?v=60hu4nPxGjU)

---

<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:** [June 7, 2021, 11:57am UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/10 "2021-06-07T11:57:22Z")

</div>

I would suggest checking all the things that your app interact with the Sheet, go through all the possible things a user can do, all the action flows etc. to see if there’s something you may have missed.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 7, 2021, 2:07pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/11 "2021-06-07T14:07:28Z")

</div>

I’m ok but that don’t explain why sheet edits arrive at the middle of the night. Only automatic change can explain that, can’t it?

---

<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:** [June 7, 2021, 3:01pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/12 "2021-06-07T15:01:54Z")

</div>

Is there no chance your users don’t use that app during the middle of the night?

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 7, 2021, 4:14pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/13 "2021-06-07T16:14:09Z")

</div>

i’m absolutly sure about that

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 7, 2021, 4:45pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/14 "2021-06-07T16:45:16Z")

</div>

I can give access if somebody want to watch inside the App…

---

<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:** [June 7, 2021, 11:17pm UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/15 "2021-06-07T23:17:48Z")

</div>

[https://glide-help.zendesk.com/hc/en-us/requests/new](https://glide-help.zendesk.com/hc/en-us/requests/new)

Then I would advise creating a ticket here.

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [June 8, 2021, 11:53am UTC](https://community.glideapps.com/t/some-questions-about-sheet-edits/26927/16 "2021-06-08T11:53:47Z")

</div>

I’m going to do that 👍
