# Slow update of app data & Google Script

**URL:** <https://community.glideapps.com/t/slow-update-of-app-data-google-script/8349>\
**Category:** Report a Bug\
**Created:** [May 2, 2020, 2:18pm UTC](https://community.glideapps.com/t/slow-update-of-app-data-google-script/8349 "2020-05-02T14:18:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Florian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/florian/32/290_2.png) [@Florian](https://community.glideapps.com/u/Florian)\
**Post date:** [May 2, 2020, 2:18pm UTC](https://community.glideapps.com/t/slow-update-of-app-data-google-script/8349/1 "2020-05-02T14:18:27Z")

</div>

Hi !  
Enjoying very much Glide, I’m trying to push it to the limits 🤜 and I built a nice & simple shopping app.

However I am facing slow updates causing poor UX. 😢

Context as a user :  
I can add different items to my basket.  
I can confirm my basket to create an order.  
I can have a list of all my previous orders.

Once I confim my basket and create an order (through form button), I have a google script running that empties the basket (and so delete rows on spreadsheet).  
As you can see on following GIF, the basket takes time to be empty (\>1minute).  
[http://recordit.co/ksf9ixnAHs](http://recordit.co/ksf9ixnAHs)

 ![ksf9ixnAHs](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/33b0729ea9579f9a73431c9ca5f7d3eea46825a2.gif)

**Questions**

1. Is that expected behavior ? Changes by Google Script are not detected by Glide ?
2. Would the update be instanteneous with Glide Pro ?
3. Do you have any advice to bypass the problem ? Tech or UX.

Thank you very much for your help 🙂 🙏 ! Glide rocks 🤟  
Florian

---

<div class="post-metadata">

**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:** [May 2, 2020, 2:49pm UTC](https://community.glideapps.com/t/slow-update-of-app-data-google-script/8349/2 "2020-05-02T14:49:20Z")

</div>

Yes, this is expected behavior. I think Glide will check the sheet for update quickly after something changes, or within a few minutes if you have a pro account with background refresh enabled. Beyond that Glide will only be notified of updates from google periodically at the mercy of google. Sometimes quickly, and sometimes after a few minutes.

You would be better off building as much into Glide as possible by adding a relation from the basket to the order sheet. If a matching relation is found, then you can filter out records that are in the basket. The only problem is you will need some kind of unique value on each basket item that will match the order.

There have been a few similar discussions in the forum.

> [@How to create an app for taking Sales Orders](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/12):
>
> Here’s a bit of a wild idea. Create a column in your confirmed orders sheet that will contain only email and business. This can be 2 separate column joined with a template, or you can write it to the sheet later already joined from the form button. Doesn’t matter. We just need email and buiness only. Next on your products, sheet follow the instructions here to get a lookup column of the user’s signed in email into the products sheet. [List Relation "Data"](https://community.glideapps.com/t/list-relation-data/7659/5) Next in the products sheet, create…