# Store every few hours, the meteorological accuracy of various locations **URL:** \ **Category:** Ask for Help\ **Created:** [January 8, 2022, 6:34pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857 "2022-01-08T18:34:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)\ **Post date:** [January 8, 2022, 6:34pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/1 "2022-01-08T18:34:44Z")
I have included in my web app, the weather forecast of the locations included in a small list. Every time I open the tab, the application freezes for a few seconds, just to load the weather elements. Is there a way to load the relative elements every 6 hours, for example, or once a day, to speed up this operation? Has anyone experimented with it? Thanks! 🙂@Robert_Petitto @Jeff_Hager @Darren_Murphy … ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 6:57pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/2 "2022-01-08T18:57:45Z")
You can write script with a time trigger ---
**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:** [January 8, 2022, 11:56pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/3 "2022-01-08T23:56:21Z")
How are you updating the forecast? Through an Experimental Code column? ---
**Author:** ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)\ **Post date:** [January 9, 2022, 10:22am UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/4 "2022-01-09T10:22:15Z")
Yes, just like that! ---
**Author:** ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)\ **Post date:** [January 15, 2022, 5:37pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/5 "2022-01-15T17:37:14Z")
Solved! I finally found a solution worthy of being called that. I’ve used a Google Sheet plug-in “Api connector” from [mixedanalytics.com](http://mixedanalytics.com) that works perfectly with Openweathermap to which you just have to feed data taken from a Google sheet, to populate a table with selectable fields. This is an example, my example: [https://api.openweathermap.org/data/2.5/weather?q=++Places!S2:S+++&units=metric&appid=API-key&lang=EN](https://api.openweathermap.org/data/2.5/weather?q=++Places!S2:S+++&units=metric&appid=API-key&lang=EN) The query part is as follows: +++Places!S2:S+++. where Places is the spreadsheet and S is the column (in my case from the second value to all values). Everything else can be easily developed in glide environment. The plugin is free as far as API operation is concerned (not only openweathermap). In my case where a time trigger was required, it would be chargeable. If some guru could think of a little code to run the plugin hourly, that would be great. Thank you @Uzo e @ThinhDinh for the support! ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 15, 2022, 7:38pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/6 "2022-01-15T19:38:32Z")
Hola @profxeni I might give a plan B to have a simpler solution and not use a GS script: You can use my new Toggle Trigger idea based on time to fire your API call, use Glide Tables instead and have an updated info every 20 sec, 120 sec, 10 min or 50 min. You can see it or copy the APP here [https://toggle-trigger.glideapp.io](https://toggle-trigger.glideapp.io) Saludos ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [January 16, 2022, 7:48am UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/7 "2022-01-16T07:48:48Z")
@gvalero could you elaborate on how you achieved that? It is a time trigger that hasn’t been possible inside glide until now I think. Own code? If so will you share the code? Thx👍 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 16, 2022, 9:58am UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/8 "2022-01-16T09:58:07Z")
I just tried your app, and it looks like it does the same thing as google scripts or regular time delay Glide duration math column… (both not time reliable methods) so my question is … what is the advantage? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 16, 2022, 2:53pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/9 "2022-01-16T14:53:14Z")
Hola @krivo and @uzo Let me create a new thread about it to explain the scope of this Toggle action Trigger based on time. Meanwhile, you can copy the APP and see the logic, it just a trick playing with Trunc() and Mod() functions. Saludos ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 17, 2022, 2:53pm UTC](https://community.glideapps.com/t/store-every-few-hours-the-meteorological-accuracy-of-various-locations/36857/10 "2022-01-17T14:53:42Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.