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.
1 Like