# Time Based Visibility of an Object / a Row In a List

**URL:** <https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853>\
**Category:** Ask for Help\
**Created:** [August 1, 2021, 3:46pm UTC](https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853 "2021-08-01T15:46:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Iftach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/iftach/32/29848_2.png) [@Iftach](https://community.glideapps.com/u/Iftach)\
**Post date:** [August 1, 2021, 3:46pm UTC](https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853/1 "2021-08-01T15:46:40Z")

</div>

Hey there, I’m working on a city guide recommendations app, and I’d like the main screen to dynamically change according to the time of day. For instance, in the morning user will get top places to get brunch or breakfast and by the end of the day best places for a night-out will appear. How can it be done, considering I can’t use current time as a formula variable? Or maybe can I? Does the Google Sheets `now()` formula update frequency is quite satisfying? The new “Experimental Code” Column Type within Glide has got my attention, can it be used to pull the current time from an outside source? And if it could, how so? Thank you very much!

---

<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:** [August 1, 2021, 4:08pm UTC](https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853/2 "2021-08-01T16:08:47Z")

</div>

You can create a math column that returns the current hour of the day ‘HOUR(date)’. Then replace ‘date’ with Now in the math column. Then in your restaurants list, add a minimum and maximum hour column which determines which hours of the day that you want to display the restaurant in the list. From here, you can either filter your list or create an IF column to return true if the current hour fits within a restaurant hour range. IF column could then be used for your filter.

---

<div class="post-metadata">

**Author:** ![Iftach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/iftach/32/29848_2.png) [@Iftach](https://community.glideapps.com/u/Iftach)\
**Post date:** [August 1, 2021, 4:54pm UTC](https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853/3 "2021-08-01T16:54:15Z")

</div>

That is so simple yet so powerful! Thank you very much!

---

<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:51pm UTC](https://community.glideapps.com/t/time-based-visibility-of-an-object-a-row-in-a-list/29853/4 "2024-01-17T16:51:07Z")

</div>


