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

Feature Requests
21

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

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:

23

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

24

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 !

25

You cannot import CSV into Glide tables. Also, mentioning ā€˜@staffā€™ does not mention the team.

I am wondering about the same thingā€¦

1 Like
26

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

Iā€™d like to, but I cannot for a while :roll_eyes:

image

2 Likes
28

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
29

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

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

31

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.

4 Likes
32

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

33

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
34

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?

35

How would you expect that to work?
I mean, what would the process flow look like?

36

:wink: ā€¦ hmmmā€¦ If I remember wellā€¦ you are my Long time ago customer @Blue_Community, just email me, and ill make it for you.

1 Like
37

will do buddyā€¦ thanks for reaching outā€¦