500 Row Limit - What Counts?

[Drearystate]

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). 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!

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.