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
If your app is pro, you could use a Webview component.
Sure! I am a pro but I would like to set conditions regarding the time in Colombia that is reflected on the clock
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.
4 Likes
if you use google sheet as database, just use the formula =Now() then display it with Text in glideapps. hope it can help you
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.
3 Likes