# Showing a component for a specific time duration

**URL:** <https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263>\
**Category:** Ask for Help\
**Created:** [March 7, 2020, 12:25pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263 "2020-03-07T12:25:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 7, 2020, 12:25pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/1 "2020-03-07T12:25:36Z")

</div>

Does anybody know a way of showing a component for a defined time duration, say 2 minutes. After 2 minutes, the component will not be visible. I would like to know how this can be achieved using google spreadsheet magic or glide features?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [March 7, 2020, 12:53pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/2 "2020-03-07T12:53:55Z")

</div>

Even with a Pro account, Glide only updates about every few minutes unless changes are made to the sheet. Without a Pro account, the app only ever updates if the sheet changes in some way.

I seem to remember seeing a similar post about this question. I don’t think anything substantial came out of it, other than a recommendation to have the timer extended so that the Pro app would update in a decent amount of time to allow for a reliable timer function. I don’t think anything less than 5 minutes should be relied upon.

---

<div class="post-metadata">

**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\
**Post date:** [March 7, 2020, 2:17pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/3 "2020-03-07T14:17:36Z")

</div>

Using zapier, there’s maybe a way to set up a zap that would write something in your gsheet upon an event from this same gsheet. Using zapier, you can set “delays” before a zap runs. Nevertheless, not sure that zapier would allow a 2 min delay, as long as zap are executed every nearly 10 minutes, except if you have an enterprise account.

So… a google script with a sleep 120?

---

<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 7, 2020, 2:25pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/4 "2020-03-07T14:25:53Z")

</div>

Even with script, I believe that it won’t register the change as a “spreadsheet edit”. So the sheet would change but the app won’t. This is the same for both NOW and TODAY formulas.

I had suggested a feature be built within Glide to provide a new data column type called Current DateTime—go upvote!

[A new home for Glide Feature Requests](https://community.glideapps.com/t/a-new-home-for-glide-feature-requests/4765)

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 8, 2020, 9:41am UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/5 "2020-03-08T09:41:29Z")

</div>

Thanks for the info.I thought about of the best way to use the constraints, and this is what i have come upon. I use a Time column which registers a time of entry of a form value and I use google sheets formula to enter a time = Time plus 5 seconds in another Timeout column and then use a google sheets formula to change the value in a Timeout flag column which is set to True, when Timeout column is before NOW(). So, within five seconds, after the form is submitted,the Timeout flag turns TRUE. I keep the visibility condition of the component to be when Timeout flag is FALSE. By, the time, google sheet update of The Timeout flag reaches Glideapp, it will be about two minutes, and that seems sufficient time for me to show the component. It works ok, the time of update in glideapp is unpredictable. When I go PRO, it should be better.

---

<div class="post-metadata">

**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\
**Post date:** [February 28, 2021, 11:43pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/6 "2021-02-28T23:43:41Z")

</div>

You can do it directly in a Glide sheet with math operators on time columns and using the NOW function. Similar to what you have done.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/showing-a-component-for-a-specific-time-duration/5263/7 "2024-01-17T16:53:13Z")

</div>


