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

This is going to be my issue soon too! Users submit many values on a daily basis. Mine is about check in, extra in and cover in where 18 admins check in 18 times a day plus extra in if they have free time to work plus cover in if someone is absent and someone else wants to cover him/her!

Looking forward to your brilliant solutions as usual @Lucas_Pires

2 Likes

The best thing is to use another google sheet with filtering archived data and this also can be done using Zapier to input the data because you wont be able to do it through glide

So use your forms to catch data in an empty sheet in the spreadsheet and then catch the data by zapier (new or updated row)
Then delete the data to avoid the count
3rd step to insert it in the other google sheet

So in the way above you will be able to use import range with filter and only show data to a certain dates or value

Let me know if this needs to be explained more

Hola @Errcomp

Have you tried to create the charts using quickchart.io that way you could use some rollups and maybe save some rows?

Zapier and intergromat needs google sheets? I actually need it on Glide Tables. I hit google sheet’s limit on simultaneous entries but GT handles it great. I just need more rows :pray:

For the suggestions from @Yasin_Hassanien @SantiagoPerez, @Lucas_Pires i think I’d also need google sheets for those too, no?

In my case, my method I use only glide

1 Like

Hey !

Based on the informations you mentioned I think that using the Glide spreadsheet may help you.

You may want to check this topic :

https://community.glideapps.com/t/please-help-us-test-glide-sheets/14194?u=aymenm

@Lucas_Pires oh that’s great! I’ll be interested to see! Neat name too.

1 Like

@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