Hi there I have a GlideApp that I’ve been building for awhile now, and for some reason when I shifted my google sheets over to this new sheet everything linked and has been working for months, but there is a recurring sync issue. Every so often the data won’t sync, and on the sync page it will show…

Do you have a google sheet tab that is built dynamically from a formula?

Hi Jeff, Initially yes I did, within my google sheets file I had a sheet named “MKPIs” that was pulling data from another sheet’s MKPIs section using the IMPORTRANGE() function, then I eventually decided to combine the google sheet files, and when I cloned over the new MKPIs from the older google sh…

The whole reason I asked if you used a formula to build a table is because, if the first row of headers is also imported as part of the IMPORTRANGE, then you can run into issues because there is a chance that the formula may be recalculating at the same moment that Glide is syncing the data. If that…

Wow that’s a great point! I had it importing over that first row and then I shifted over the sheets so maybe that is the issue. I have a sheet titled MKPIs but no first row importrange because the values are static instead of importing from another sheet. I removed the data grid headers that are li…

HI there @Jeff_Hager I still seem to have the issue…I tried renaming my sheet by appending NEW to it then sync, and it simply syncs the new sheet and keeps the old error. Is there a way to find what parts of my app are using those specific columns? Even when I click for the columns to be removed the…

Try making a duplicate of your Google sheet. Then go to your app → settings → Data → Replace the current Google sheet with new spreadsheet. Works for me most of the times.

Yeah, try @Hassan_Nadeem ’s idea. If that doesn’t work, then you can try duplicating the app and monitor the duplicate app to see if you have the same issue. I’m not really sure what’s going on here. Seems like you did what you needed to do to resolve the original issue by merging everything into …

[image] How to open a support ticket? Ask for Help Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the Glid…

Thank you all for your help and support, @Marcel (not sure which Glide username he is) suggested I had too many columns (over 500) and so what I did was remove columns and also some of my columns had duplicate headers which may have been an issue, this seems to have fixed it! I appreciate you all!

Recurring Sync Error

Report a Bug

ThinhDinh July 27, 2023, 12:03am 9

Here’s how to open a support ticket, just in case.

Topic		Replies	Views
Glide Cannot Sync Ask for Help	5	239	September 19, 2022
Glide cannot sync with your Google Sheet Ask for Help	25	2622	January 28, 2024
Whats the reason for this error? Ask for Help	5	750	June 4, 2021
Google Sheets stopped syncing? Let us know! Report a Bug	36	996	March 26, 2024
Google Sheet does not match data view in Glide Report a Bug	51	4646	October 2, 2023

Recurring Sync Error

Related topics