# Reloading

**URL:** <https://community.glideapps.com/t/reloading/5050>\
**Category:** Ask for Help\
**Created:** [February 29, 2020, 10:35pm UTC](https://community.glideapps.com/t/reloading/5050 "2020-02-29T22:35:15Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pedro\_Gonzalez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedro_gonzalez/32/3759_2.png) [@Pedro\_Gonzalez](https://community.glideapps.com/u/Pedro_Gonzalez)\
**Post date:** [February 29, 2020, 10:35pm UTC](https://community.glideapps.com/t/reloading/5050/1 "2020-02-29T22:35:15Z")

</div>

Hi Glide community,

I have an app that i feed data through a query ( =QUERY(IMPORTRANGE(“https://”,“Respuestas de formulario 1!A:AP”),“where Col2=‘xxxxxx’”) ) From a sheet that is connected through a Google Forms. I finally have setup everything exactly like i wanted and ready to start using but I find that the new rows do not load automatically to my glide app I have to manually open the glideapps web page and press the reload button to have the information updated. Will this be something I always have to do or am I missing somesort of setup so that it loads automatically.

I already setup my two sheets to calculate if there are changes and every minute from reading another post but still no luck. Someone please help me.

This is my app [https://autopiloto-master.glideapp.io](https://autopiloto-master.glideapp.io)

---

<div class="post-metadata">

**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:** [February 29, 2020, 10:45pm UTC](https://community.glideapps.com/t/reloading/5050/2 "2020-02-29T22:45:40Z")

</div>

Glide gets notifications from Google when humans make changes to Google sheets. Glide does not get notifications from Google when scripts or import formulas like the one you’re using change the spreadsheet. We have a feature for Pro apps which causes your sheet to be reloaded every few minutes to work around this limitation.

To reiterate, Google doesn’t tell Glide that your sheet has changed when using this formula.

---

<div class="post-metadata">

**Author:** ![Pedro\_Gonzalez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedro_gonzalez/32/3759_2.png) [@Pedro\_Gonzalez](https://community.glideapps.com/u/Pedro_Gonzalez)\
**Post date:** [February 29, 2020, 11:38pm UTC](https://community.glideapps.com/t/reloading/5050/3 "2020-02-29T23:38:09Z")

</div>

So only by upgrading to pro this can be optimized

---

<div class="post-metadata">

**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:** [February 29, 2020, 11:49pm UTC](https://community.glideapps.com/t/reloading/5050/4 "2020-02-29T23:49:23Z")

</div>

That’s right.

---

<div class="post-metadata">

**Author:** ![Eduardo\_Padial](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eduardo_padial/32/4064_2.png) [@Eduardo\_Padial](https://community.glideapps.com/u/Eduardo_Padial)\
**Post date:** [March 4, 2020, 3:24pm UTC](https://community.glideapps.com/t/reloading/5050/5 "2020-03-04T15:24:24Z")

</div>

David,  
Thanks for responding to this thread!

We are trying to make a real-time app. If a new “human” data entry is made, to be reflected immediately (less than 20 seconds). It’s basically like a draft style app, and people have to make quick decisions based on the data input that has been edited real-time.

Currently using Sheets to display this; not sure via Pro it is possible that the reloading or data is reflected that quick in the app.

Thanks!  
Eduardo

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 4, 2020, 5:52pm UTC](https://community.glideapps.com/t/reloading/5050/6 "2020-03-04T17:52:55Z")

</div>

The only way to have instant data calculated and displayed is to do all your calculations within Glide rather than formulas within the sheet.

> [@Optimize operation and calculation loads sheet/app](https://community.glideapps.com/t/optimize-operation-and-calculation-loads-sheet-app/5128/2):
>
> The more executions/filters/calculations you do within Glide, the better performance you’ll have. That being said, There are some formulas that Glide can’t do internally (yet) Any columns you create or calculations you do within Glide will not be accessible within the sheet…plan accordingly Personally, I’ve found that using Glide data columns results in the best user experience…though it takes some thought and redundancy to produce the same results as a simply Sheets formula. Worth it in my…

---

<div class="post-metadata">

**Author:** ![Eduardo\_Padial](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eduardo_padial/32/4064_2.png) [@Eduardo\_Padial](https://community.glideapps.com/u/Eduardo_Padial)\
**Post date:** [March 4, 2020, 6:04pm UTC](https://community.glideapps.com/t/reloading/5050/7 "2020-03-04T18:04:29Z")

</div>

Thanks Robert! Will look into it.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [March 4, 2020, 6:51pm UTC](https://community.glideapps.com/t/reloading/5050/8 "2020-03-04T18:51:15Z")

</div>

I would add that if data is edited or added in the Glide app then it is written to the Google Sheet within a few seconds. After it is written the sheet is polled by Glide and any changes are pull back to the app. So your 20 second requirement would be met. The only exception to this would be if some of the functions in your sheet are custom functions that take a significant time to complete. The result of these may miss the window between the writing of the updated data being sent by Glide and the pole that happens right after the write is completed. Yes do as much as you can within the Glide Math column or other Glide Column types but if something is missing all is not lost, you can get good results using sheet formulas.
