I’ve since updated from Classic App to the current Glide App, and switched from primarily using Google Sheets to primarily using Glide Tables.
I believe the issue was due to using very large data sheets with many computations, and something about the delayed syncing messed up the writes. In line with what Jeff was talking about here:
Jeff_Hager:
I will say this though. A couple of years back, my Google sheet did a lot of the heavy lifting as far as formulas and calculations. Whenever data was changed in the app, it would cause my google sheet to start churning and calculating. Sometimes for several minutes. If a form was being submitted several times in rapid succession, then some of those form entries would get lost because they won’t be written to the google sheet until it’s done doing it’s calculations. If a sync occured in that time, then any submissions that didn’t yet sync to google would be lost because they didn’t exist in the google sheet. At the time I ended up creating a completely separate google worksheet, which did the heavy lifting and used Import formulas to move data between the app worksheet and the calculation worksheet. It solved the problem at the time, but led to a large delay before updated calculations were eventually synced back to the original worksheet and back to the app. Since then I’ve moved most of the logic into glide and haven’t looked back. Hard to say if that is the same situation you are having, but it sounds like your sheet is doing a lot of work.
2 Likes
system
Closed
October 2, 2023, 2:55pm
23
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.