Google sheets did not log data for 9 hrs this AM

[Errcomp]

This morning google sheets did not update when about 40 entries from 15 people were entered via add row when pressing inline list buttons. However, there is also an add row action that simultaneously writes to a Glide Table, and the entries were recorded there! I’m glad I have it writing to two places! But I’m really disappointed that Google Sheets dropped the ball. This has never happened before. Any ideas why Google Sheets did this? Do I need to make sure I close the sheet at night when I’m not editing it (that might have nothing to do with it, but wondering)?

[Jeff_Hager]

This may or may not shed some light if you think it’s a similar case.

CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet

Hi gliders, Decided to leave the topic as “Uncategorized” as I don’t really know where to put this story. TL"DR - 200 user sent 20 answers to trivia game in a period of 30 min caused huge dealy (hours) in writing data to the sheet and update the app back, Full story: I built a trivia app as a small entry project for what could have a been a huge customer for me on the glide platform, a municipality here in Israel. The game itself was relatively simple, 20 questions (answers were submited us…

CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet

Sometimes Google Sheets will slow us down, limiting us to 1 action every few seconds. To avoid this: Use Glide Tables — we don’t have any limits on actions here Google has a quota per Google Account for how often you can update a Google Sheet each minute, so if you have many apps connected through the same Google account, these are all sharing the quota. So, if you have apps for 100 different clients under your My Apps, these are all sharing a single update quota tied to your Google account. I…