πŸ™πŸ™>25K rows in GT, or external database. So needed!

@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 :moneybag:

1 Like

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 ! :slight_smile:

@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…

1 Like

@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. :star_struck:

1 Like

I’d like to, but I cannot for a while :roll_eyes:

image

2 Likes

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.

2 Likes

@Jeff_Hager Thats interesting. Maybe that bottleneck would be fixed along with rolling out 100K+ rows per user…but we shall see :slight_smile:

1 Like

@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.

3 Likes

@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 :face_with_monocle:

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.

1 Like