heh… I just had a crazy thought…
what you might be able to do is build an external service that would fetch the data from the Google Spreadsheet, and then feed it into Glide via an app in a browser view - a little bit like screen scraping in reverse
In theory, no there is no hard row limit that is currently enforced in google sheets or glide tables, but you have to consider the amount of data that’s synced between google sheets > glide servers > user’s device. Glide tables won’t make any difference for the sync between glide servers and the device, but it does remove the bottleneck between glide servers and google sheets. A lot of data means a lot to sync. Regardless, the sync between glide and google should be transparent to the user as long as there are no formulas in the Google sheet and all calculations are performed using glide functionality.
If you are using Row Owners, you can reduce the amount of data that’s synced to the user’s device and not overload the user with too much data. This is what truly provides you with the theoretical “no row limit”.
Hmmm difficult decision to make. My data will be created to 100% in the app. I have no sheet magic. I did all in the gde with relations, lookups and so on. The only sheet I need in google is the profile sheet because I connected it with integromat.
A kind of lazy loding would be nice. In my case the sale point options are displayed with an inline list with selapoint row id as filter value. It woulb be perfect if glide loads this data when it have to display them.