“Unable to fetch app definition. Very large/slow loading table or a cross-table cycle in formulas”
this is accompanied by a very slow to no sync at all (timed out)
also seeing the error “Google drive Rate Limiting Exception”. I wonder if they’re both related
thanks in advance.
Yes, they are both related. There is processing that is slowing down the loading of the data. Since you are also getting Google limits message, I suspect you probably have sheet side formulas. Are they sheet-side formulas?
If you do have sheet-side formulas, I strongly recommend to limit their use to back-end processing type scenarios ONLY. E.g. creating/updating a summary sheet OR for data viewed outside of the AppSheet app. For your app live data, use AppSheet or AppScripts to perform the necessary updates.
When there are sheet-side formulas that run as data is inserted or updated, AppSheet waits for those formulas to complete before attempting to bring in the updated rows. Not only might the formulas take longer as the number of rows increase but if several formulas are interdependent, they can create a significant pause in data loading/downloading. Couple that with numerous users all trying to perform similar updates and the sheet becomes a bottleneck for transmitting data updates.