# Insert time

**URL:** <https://community.glideapps.com/t/insert-time/40675>\
**Category:** Ask for Help\
**Created:** [April 13, 2022, 1:44am UTC](https://community.glideapps.com/t/insert-time/40675 "2022-04-13T01:44:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [April 13, 2022, 1:44am UTC](https://community.glideapps.com/t/insert-time/40675/1 "2022-04-13T01:44:07Z")

</div>

How can you insert data from a website in real time? I would like to insert the Colombian clock through code so that it is reflected in Glide

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/9160231695b07265654b98fcc041148e1be097af.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 13, 2022, 2:03am UTC](https://community.glideapps.com/t/insert-time/40675/2 "2022-04-13T02:03:01Z")

</div>

If your app is pro, you could use a [Webview](https://docs.glideapps.com/all/topics/components/media/webview-component) component.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [April 13, 2022, 2:05am UTC](https://community.glideapps.com/t/insert-time/40675/3 "2022-04-13T02:05:06Z")

</div>

> [@Darren\_Murphy](#):
>
> Webview

Sure! I am a pro but I would like to set conditions regarding the time in Colombia that is reflected on the clock

---

<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:** [April 13, 2022, 3:28am UTC](https://community.glideapps.com/t/insert-time/40675/4 "2022-04-13T03:28:49Z")

</div>

Rather than trying to pull the time from an outside source, I thing you would be better off calculating it yourself. Have a look at this thread. Rather than calculating GMT time, you can set the correct timezone to calculate to Columbian time. Then you will have a value in your table that can be used for conditions in the app.

> [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524):
>
> This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to…

---

<div class="post-metadata">

**Author:** ![resepsionis\_ganteng](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/resepsionis_ganteng/32/39081_2.png) [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)\
**Post date:** [April 13, 2022, 7:41am UTC](https://community.glideapps.com/t/insert-time/40675/5 "2022-04-13T07:41:53Z")

</div>

if you use google sheet as database, just use the formula =Now() then display it with Text in glideapps. hope it can help you

---

<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:** [April 13, 2022, 11:44am UTC](https://community.glideapps.com/t/insert-time/40675/6 "2022-04-13T11:44:21Z")

</div>

Using Now in a math column in glide will allow the time to automatically update approximately every 10 seconds. This can be done regardless if you use Glide Tables, Airtable, Google sheets, or Excel as a data source. If you use Now in a google sheet, then it will not always be the current time because it may not synchronize with glide all of time. If a realtime current time is important for conditions, then it would be better to calculate it in glide using a math column, instead of the sheet, as it would always be current and update directly on the user’s device instead of having to sync the time value from google → to glide → to the end user.
