EXCEL/GLIDE Synchronization

[Jeff_Hager]

I don’t agree with the way Glide handles this with external data sources, but essentially they will only sync the number of rows that your plan allows. If you have 5000 rows of data in Excel, but your plan only allows 500 rows, then they are only going to sync 500 random rows across all tables. In addition to that 500, they will at least load a minimum of 10 rows in each table, so at least they are not empty. And unfortunately, it seems that the rows that are loaded randomly change day to day.

It does make it really hard to test and prototype, especially when data is missing that is required to build some of the screens. I’ve had to push off projects or update my plan, just so I can build my project. Unfortunately I’m using production data, so I can’t just delete rows. I talk more about it below.

@Jeff_Hager

• I’m trying to rewrite a Legacy Plan Classic App as a New App on a new Starter team plan. I only upgraded the plan on the new team so it’s slightly less annoying to build the app with a bunch of missing data. For whatever reason, Glide will not sync all data from external sources if the plan row limit is too low. I’ve never completely understood the logic behind this. My data is in Google Sheets and I intend to keep it that way. Right now my data far exceeds the row limit of the plan as it’s linked to a legacy app that doesn’t have the current row limits. I understand that I would not be able to have a functioning published version of this new app due to row limits. I’m working on processes to clean up old data in the time being. But the problem is that it’s very hard to build the app when a lot of the crucial data is missing from rows that are limited to only 10 random rows on seemingly random tables. Most of my data is heavily reliant on relations to other tables. I also have resource tables that store global images, choices, etc. and it’s hard to build the interface when that crucial data is missing, since many things do not display properly if there is not associated data. Also, what’s accessible seems to change randomly so it varies from day to day. In my opinion, ALL data should at least sync to the builder so we can at build our projects. I can’t tear into my data to reduce rows since it’s also being used on a published legacy classic app. I know this is a very rare case these days and this is largely my own problem due to having legacy apps. However, I’m not in a particular hurry to rewrite the app, and some hard stop features just aren’t there, so right now I’m picking away at it as I have time and as new features become available, but meanwhile I’m paying for an app that won’t be published anytime soon. I know I’m in a weird situation for many reasons due to still having legacy apps, and when they eventually get migrated to team folders, it will be different story, but overall it seems to make more sense to sync ALL external data regardless of plan limits. Only for the fact that it could allow people to build faster, see the fruits of their effort, and upgrade to a higher paid plan sooner.

I’ve seen several posts where people get confused as to why all of there data is not syncing. Seems beneficial to at least show all data, but still apply restrictions to the published app.