# 500 Row Limit - What Counts? **URL:** \ **Category:** Ask for Help\ **Created:** [December 11, 2020, 8:47am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702 "2020-12-11T08:47:07Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 14, 2020, 10:12pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/22 "2020-12-14T22:12:20Z")
Now thats a reply. ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 14, 2020, 10:18pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/23 "2020-12-14T22:18:56Z")
> [@ThinhDinh](#): > > I’m not sure how much delay it would introduce to use a Vlookup on a big set of data instead of a relation as well. Sorry to go off topic, but do all formulas in Google sheets cause a delay, or only ones like this Vlookup? I ask because I put a column into my Google sheet that’s simply a lowercase conversion formula, and ever since then my app takes five full seconds to load instead of the immediate load it had before. (I have a relation within Glide to this lowercase column too) I had made several changes at once in addition to this one before the delay occurred so I’ve been avoiding the nightmare of trying to track down the culprit! Are formulas a main suspect? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 14, 2020, 10:47pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/24 "2020-12-14T22:47:18Z")
The delay is in Glide really, so when you send/enter new data it just has a delay to refresh its data,you would see the data in your sheets within seconds, the formula is instant its just how long glide looks back at the data again. Glide says they refresh the data every minute or upon data being edited. The problem with this is a fornula result changing isn’t considered a sheet edit, it’s considered a sheet change. And Glide only updates on a sheet edit and every minute. With that being said, when google sheets are closed and you are using formulas for returned values it actually takes about a 3rd of the time. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 14, 2020, 11:23pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/25 "2020-12-14T23:23:42Z")
So there is one way around this, I’m sure they don’t want us doing this but you can write a script (I actually have here on the site) that works with onChange edits and creates a edited event that Glide immediately sees and refreshes your app, this brings it down to 4 to 7 seconds. Again, I am sure I will be told to not tell people about this because I think Glide says it costs them a per edit cost, now I am unsure of that. I’ve tried to find the google sheets api pricing but all I can find is this article from google regarding their sheets api pricing where they say it’s free.([Límites de uso  |  Google Docs  |  Google for Developers](https://developers.google.com/docs/api/pricing)). But maybe the cost is on Glide’s end with data processing and data retrieval. I am unsure but there you go. > [@Scripts, scripts, scripts!](https://community.glideapps.com/t/scripts-scripts-scripts/18965): > > I was helping someone earlier and it occured to me that we do not have a Forum Page dedicated to helpful scripts. Now I know some of us cling to our scripts because they are in some ways what makes our apps great. Well, I use a ton of scripts in my apps and in my daily job and with that being said I would like for us to list off scripts here to help each other out. I will post most of my scripts that I still use to hopefully be an example of this. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [December 15, 2020, 12:24am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/26 "2020-12-15T00:24:10Z")
> [@Drearystate](#): > > The delay is in Glide really, so when you send/enter new data it just has a delay to refresh its data,you would see the data in your sheets within seconds, the formula is instant its just how long glide looks back at the data again. This isn’t true. The Google Drive API notifies us of sheet changes at most every three minutes. > [@Drearystate](#): > > onChange edits and creates a edited event that Glide immediately sees and refreshes your app, this brings it down to 4 to 7 seconds I also think this is not true, but go ahead if it works! It will count against your sheet reload quota so you could run out of reloads. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 15, 2020, 2:49am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/27 "2020-12-15T02:49:33Z")
Like I said it is probably frowned upon, but if you have PRO or more your sheet loads are unlimited. I did do a test on this @David a few months back and put the results somewhere in the forums I spent 3 days attempting to speed up the process which led me to this result. I don’t know where it is but it was a week long forum conversation I believe. I was trying to have instantaneous information fed to the app before we had Glide sheets as an option. > [@Glideapp Update frequency](https://community.glideapps.com/t/glideapp-update-frequency/9372): > > Does anyone know exactly how often Glidapps updates on it’s own with the PRO accounts. I honestly need mine to update every minute if not more frequently and it seems like it does it every 5 to 10 minutes unless we manually enter in data. I’m looking for an exact number if possible. I know I can run a script timer that forces it to update every 30 seconds but I was hoping to not have to do this. Here’s the posting, in this post I had it down to a consistent 1 minute for a few days. Shortly after posting that finding it went right back up to 3:45. Then I implemented the most recent mention that forces the edit. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 15, 2020, 4:56am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/28 "2020-12-15T04:56:03Z")
Glide should be pretty good about dealing with emails in a variety of character cases. I know Glide has worked on a few bugs regarding emails and mixed character case. Are all of your email columns marked as email columns? What is the reason for doing the lowercase conversion? If email case is a concern for you, I would consider creating a Unique ID to go along with that email or user. Then use that unique ID for all of your relations. However, if you are relying on the use of Row Owners, then you still need to use the email, but in most cases, the letter case shouldn’t make much of a difference for emails, unless you are running into a particular issue that you could explain. ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 17, 2020, 8:34pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/29 "2020-12-17T20:34:59Z")
@Jeff_Hager I have an email column marked as row owner in my User Data sheet. This is the email address the user logged in with. Also in the User Data sheet I have an email relation column which connects User Data to the member directory sheet where members have input their own email address, sometimes using mixed case. I then have a look-up column which specifically looks up the email address that the member input into the member directory sheet. All of this is so the app knows when a logged in user is a directory member or not. I discovered an issue as soon as I shared the app with a few test users where Glide does not match mixed case email addresses in the lookup column - meaning a member who used a capital “D” in her address was not being recognized as a member. I fixed this issue by creating a hidden column in my directory sheet with a formula that converts all emails to lowercase. I then changed my Glide sheet to reference that column instead. I did some research on the forums and it seemed that Glide’s relations _are_ case-sensitive? I am guessing that columns marked as “email address” are not, but there is no way to mark a look-up column as “email address” - right? Is there a better solution? (I don’t want to ask my users to modify their behavior - my gut says that is never the solution) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [December 17, 2020, 8:39pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/30 "2020-12-17T20:39:18Z")
Hi Amanda, Are you using an email picker to collect the emails? I believe that would help you with your problem. ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 17, 2020, 8:44pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/31 "2020-12-17T20:44:04Z")
Is an email picker something within Glide or something within Google Sheets? ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 17, 2020, 8:51pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/32 "2020-12-17T20:51:42Z")
[https://docs.glideapps.com/all/reference/components/input/email-entry](https://docs.glideapps.com/all/reference/components/input/email-entry) ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 17, 2020, 8:59pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/33 "2020-12-17T20:59:58Z")
> [@SantiagoPerez](#): > > Are you using an email picker to collect the emails? I believe that would help you with your problem. > [@Rosewebstudio](#): > > [Glide Docs](https://docs.glideapps.com/all/reference/components/input/email-entry) @SantiagoPerez @Rosewebstudio the profiles within my app are using the email entry component to display and edit email addresses. The initial entry of the email address happens on the shared Google sheet. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 29, 2020, 8:06pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/34 "2020-12-29T20:06:15Z")
I would probably have a second column in your google sheet that takes the original entry and uses an arrayformula to lowercase the email. You could probably hide that column from view so the other members don’t mess with it. Relations are case sensitive, but doing it this way will give you the second lowercase column to use for the relation. ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 30, 2020, 2:08am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/35 "2020-12-30T02:08:04Z")
@Jeff_Hager that is exactly how I set it up 🕶 ---
**Author:** ![KevBec](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevbec/32/35917_2.png) [@KevBec](https://community.glideapps.com/u/KevBec)\ **Post date:** [January 10, 2022, 11:14am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/36 "2022-01-10T11:14:08Z")
Hi, Where can I confirm my row count with the free plan ? By the way, where can I buy the $5/month boost to increase the number of data rows ? Thanks a lot, ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 10, 2022, 11:25am UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/37 "2022-01-10T11:25:56Z")
In the builder, hover over the link at the top right that shows your plan type, and it’ll show how many rows you have used. ![Screen Shot 2022-01-10 at 7.23.35 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/09fd97b3b76e4a756f07bd05f8a1c77a131c8e13.png) Paid boosts are no longer available. If you want more rows, you need to upgrade to a paid plan. ---
**Author:** ![Matt\_Cleen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_cleen/32/89872_2.png) [@Matt\_Cleen](https://community.glideapps.com/u/Matt_Cleen)\ **Post date:** [April 30, 2022, 2:04pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/38 "2022-04-30T14:04:20Z")
Hi all - new to Glide and excited to build out an internal app for our field service workers to create/update work orders that fit with how we use Airtable to manage our operations. I’m trying to better understand best practices to reduce the number of rows and updates that Glide counts for in our app. **MINIMIZING ROWS** To start, if we sync a table from Airtable, what can we do to filter/prevent Glide from counting rows that we don’t need in the app? If we filter out rows in Glide, does this make them stop counting? Is there a way to sync a specific Table View from Airtable that has already pre-filtered the unneeded rows so they don’t count? **MINIMIZING USAGE** If we have our technicians update 20+ fields in a given work order, would this count as 20 updates? Or would this count as one update once they publish? Thank you! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [April 30, 2022, 4:13pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/39 "2022-04-30T16:13:36Z")
@Matt_Cleen we only count rows used in your app, and you can remove unused Airtable tables. If your work orders are created via a form, or edited via an edit screen, where the 20 entries are edited before being submitted, that is just one update. ---
**Author:** ![EIG](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eig/32/36949_2.png) [@EIG](https://community.glideapps.com/u/EIG)\ **Post date:** [March 29, 2023, 6:59pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/40 "2023-03-29T18:59:12Z")
Hello, I have read several posts in the community regarding rows. I understand the application of rows to the app as any row used in the app and all rows in a table that data is being pulled from even when residing outside of the app itself. I have made several updates to the backend to ensure referenced table rows are limited and thus far have seen no reduction in the rows counted. In fact the rows fluctuate wildly by a few hundred seemingly randomly. I tried to use the Data tab as a reference to find the rows but it doesn’t seem like there are unique identifiers within it. Is there any way to verify where the rows are that are being counted? Any help would be greatly appreciated. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 29, 2023, 11:22pm UTC](https://community.glideapps.com/t/500-row-limit-what-counts/19702/41 "2023-03-29T23:22:43Z")
The general rule is that any table that is being used in ANY way by the app, will have ALL of the rows in that table counted against your row count. If you have extra tables in your project that aren’t being used by the app then the rows in those tables won’t be counted, even though they are listed in the project. [Previous page](https://community.glideapps.com/t/500-row-limit-what-counts/19702.md?page=1) [Next page](https://community.glideapps.com/t/500-row-limit-what-counts/19702.md?page=3)