I was wondering what the maximum amount of tables is that you can create in one Glide App and what the maximum amount of rows and columns is within a single table?
(I am using the free version if that would make a difference)
There probably is a technical limit to the number of tables & columns, but I have no idea what it is.
In practical terms, I’d expect that it is way more than you would ever need.
I have Apps with more than 100 tables, and more than 1000 columns.
When it comes to rows, there is a limit which is determined by your plan. On the free plan, that limit is 500 rows per project.
Hi, you mention 500 rows per project.
Does this mean I have to count all rows in all tabs? So 1 tab with 400 rows and one tab with 101 rows (in the same google sheet) is too much?
Do I get a warning then?
In my project, I added a new tab and in Glide, only 10 rows are displayed BUT these are random, not the first 10 rows in that new tab. Very strange…
Yes, any tables in use by the project would have all rows in those tables counted. So in your example, you would have a total of 501 rows as long as both of those tables are being used by the app. With google sheets, it seems like it randomly restricts the rows that are brought into glide. I haven’t really understood how or why. I’ve even had a project that was within usage limits but still did not bring in all of the google sheet rows. Somehow it eventually cleared up.
The selective random rows makes it really hard to start building a project. I still have an App project in the My Apps folder. In anticipation of it eventually moving to a team folder, I wanted to start rebuilding it as a Page project. My google sheet has 10k+ rows, so most tables get stripped down to only 10 random rows per table. With so many missing rows, I don’t have enough data to start building a fully functional page project. Many components and screens just won’t show due to missing data. Then I got an email that I’ve exceeded storage limits, even though my original App is within limits. Fearing that it would start deleting files, I scrapped the whole attempt. At this point, I’m just going to wait until everything migrates to team folders.
I think the limit would be the same as what the limit is for glide. I have done 20 google sheets in the past, but then I moved everything to google glide.
I see earlier Darren had an app with 100 tables, I would think that each can be attached to googlesheet.
Keep in mind, that you will need to keep these synced and it will consume updates. I am assuming you have a good reason not to do the forms in Glide tables directly.
data collection for non app users - I didnt think that was possible for glide forms
in my use case the google forms function as a public landing page for non app users
and the app user is a sort of sales worker position they send the link to the form to non app users
and then if the non app users submits a form the non app user gets added to sales workers sales pipeline
Do you know if I can do this with glide forms id much rather do that if its possible
You don’t have to get users to sign up to complete a form. Theoretically you can have a public app, then build different tabs for different forms with form containers, then hide all those tabs from navigation. Allow your “app users” to get those tab links and share them to non-users.
I was thinking the same thing. You have a paid plan (Team or Business). You have the main app for internal use. Setup a new app, In settings → privacy make it a public app.
Setup a glide table for your forms. That glide table can be accessed by your internal app as it both apps are part of the same Team.