@AymenM thanks for pointing me to that discussion! That thread says Glide wants to provide 100K+ rows in GT. However, everything Iāve read says GT still has a 25K row limit. I would LOVE LOVE LOVE if they expanded it soon! I have a paying customer
Hello back,
I can be wrong but based on the mentioned topic it looks like thereās an unlimited amount of rows that you can create :
Hope this helps !
@AymenM Iāve heard and read different things as far as what is available now. One clue is there is still the 25K counter now which counts GT rows.
Maybe @david could chime in? Question is whether we can have 100K+ rows per user in GT currently, or is that still to come?
If you have the ability, try to add a csv file this will allow you to get an answer quickly. But a @staff member will confirm !
You cannot import CSV into Glide tables. Also, mentioning ā@staffā does not mention the team.
I am wondering about the same thingā¦
@Pablo_books, @AymenM, @Lucas_Pires, @SantiagoPerez, @Yasin_Hassanien, @DareSteps, @Darren_Murphy
Thanks for contributing to the discussion and the help! Please consider an upvote if you havenāt already. I think this would help us all out tremendously.
Iād like to, but I cannot for a while
Iāve tested well above 25k rows but with very simple data. I donāt think itās a strongly enforced limit by Glide. At least not that Iām aware of. I canāt vouch for the limits that you want to push it with almost 1M rows per year. If anything, youāll have more of an issue if you are trying to sync thousands of rows of data on to each userās device each time they open the app.
@Jeff_Hager Thats interesting. Maybe that bottleneck would be fixed along with rolling out 100K+ rows per userā¦but we shall see
@Drearystate , do you have a method to use virtually limitless rows?
I need it too, I still have to study what you sent me to understand how to use it ^^
You list your database in another workbook all together. Then you use vlookup to pull the data. you can use the importrange function directly in the vlookup or set it separately.
I recently started using the importrange function directly in the vlookup to save time.
It looks like this:
=VLOOKUP(A1,(IMPORTRANGE( "sheet url here", SHEET1!A1:B10)), 2, FALSE))
You can do the same with with an arrayformula just widen the range and add the function at the beginning like this:
=ARRAYFORMULA(VLOOKUP(A1:A,(IMPORTRANGE("sheet url here", SHEET1!A1:B10)), 2, FALSE))
I hope that helps you better.
@Drearystate We reached the limit of simultaneous entries on google sheets, and need to scale to even more users. I guess the technical term is ācapacityāā¦we need more capacity. GT actually handles that part like a champ. Now just trying to see if we can run calculations in GT like in Google Sheets
You can now, it might take more than 1 column to do so but Glide has come a long way since I had to begin importing data to save space. You still are limited to rows though and that still pertains to Glide Sheet rows I believe.
Curious if we can do this for Users sheetā¦ as it would reduce the number of users to just the number of signed in usersā¦ wild idea but have you tried that by chance?
How would you expect that to work?
I mean, what would the process flow look like?
ā¦ hmmmā¦ If I remember wellā¦ you are my Long time ago customer @Blue_Community, just email me, and ill make it for you.
will do buddyā¦ thanks for reaching outā¦
Shipped. Big Tables supports tens of millions of rows, and we also support SQL now.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.