# How often APP refreshes itself

**URL:** <https://community.glideapps.com/t/how-often-app-refreshes-itself/18837>\
**Category:** Ask for Help\
**Created:** [November 23, 2020, 11:38pm UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837 "2020-11-23T23:38:27Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [November 23, 2020, 11:38pm UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/1 "2020-11-23T23:38:27Z")

</div>

Hi,  
I have a use case where I want button to appear only at certain time, say 2pm on a particular day. I expect that if the person opens the APP after the scheduled time, then the button would appear as expected due to refresh of the APP.  
However, if the person has the APP running in the background before the “button appear time”, then this button may not appear as latest content may not fetched.

So my question is “how often does the APP refresh itself while it is in operation”

Thank you.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 23, 2020, 11:49pm UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/2 "2020-11-23T23:49:40Z")

</div>

If you’re using a time-related visibility then I think Glide’s math columns would do it (use the now value).

---

<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:** [November 24, 2020, 12:00am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/3 "2020-11-24T00:00:34Z")

</div>

Calculated columns are calculated on the device, so it should be real time.

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 3:18am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/4 "2020-12-02T03:18:34Z")

</div>

I have the same question (though a different use case) and would love to learn more about the refresh frequency. In my case (Glide Pro app), I have an Google app script that writes to a column onChange, which unlocks the next screen a user can see. I’ve put a 5-second login animation in between the 2 screens (the trigger and the result) but user often gets stuck on the loading until i refresh the app from glide editor.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 2, 2020, 8:41am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/5 "2020-12-02T08:41:40Z")

</div>

> [@Sina\_Meraji](#):
>
> I have an Google app script that writes to a column onChange, which unlocks the next screen a user can see.

Is this solely because you need the animation to happen?

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 8:43am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/6 "2020-12-02T08:43:00Z")

</div>

no the animation is something that entertains them while they wait for glide and sheet to sync

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 2, 2020, 8:43am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/7 "2020-12-02T08:43:54Z")

</div>

So what specific value you are using that needs a script, may I ask? We may help you with a custom action.

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 8:47am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/8 "2020-12-02T08:47:34Z")

</div>

Sure. Check out the current experience here: [https://app.edupine.io/](https://app.edupine.io/)

I’ll add some context about my use case in another reply in a moment

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 8:54am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/9 "2020-12-02T08:54:40Z")

</div>

My Google Sheets has these sheets:

- Users
- Children
- Conversations
- Words

Within the Words sheet, i have a list of topics and conversation starters for them, for different age groups.

When a parent adds a new child, i use the child’s age and info to create a new row in Conversations and populate it with the right topic and conversation starters from Conversations sheet. I also add the topic to a column in Children to mark this process as done.

For this, I’m using an onChange trigger on app script where for each empty cell in topic column in Children, it’ll go and find the right topic for the kid and add a row to the Conversations sheet, which will also populate that Today screen on the app

According to the logs on app script, this takes 1-2sec

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 2, 2020, 9:08am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/10 "2020-12-02T09:08:30Z")

</div>

Can this process be automatically done inside Glide using a combination of set column + add row?

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 9:14am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/11 "2020-12-02T09:14:42Z")

</div>

the part that is a bit confusing to me in that is this:

i think i’d need a relation column with 2 filters instead of one (e.g. finding a row from Words sheet in which age\_group and day equal age\_group and day in Children sheet). that way i’ll know the word of the day for each child, and i can use that to add a new row in Conversations sheet and populate it with the right info

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 2, 2020, 10:42am UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/12 "2020-12-02T10:42:54Z")

</div>

Sounds a bit tricky, scripts are amazing but as you have seen it delays the process a bit, that’s why we intend to use methods inside the Editor first.

Your script is still working correctly I take it, just the delay that makes the UX bad?

---

<div class="post-metadata">

**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\
**Post date:** [December 2, 2020, 12:01pm UTC](https://community.glideapps.com/t/how-often-app-refreshes-itself/18837/13 "2020-12-02T12:01:57Z")

</div>

> Your script is still working correctly I take it, just the delay that makes the UX bad?

Yes. Shared the app with a few more people and seems like they’re not facing the delay issue. Let me do a little instagram ad and increase traffic to it a little bit tonight (we havent really launched yet) and see whether it’s something a lot of the users face (chance are the delay wont be too bad), and if it is, i’ll see whether they’re willing to put up with it while i reimplement it in a smoother way 😃
