# Budapest App

**URL:** <https://community.glideapps.com/t/budapest-app/3812>\
**Category:** Project Showcase\
**Created:** [January 20, 2020, 9:51pm UTC](https://community.glideapps.com/t/budapest-app/3812 "2020-01-20T21:51:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![thebepps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thebepps/32/2956_2.png) [@thebepps](https://community.glideapps.com/u/thebepps)\
**Post date:** [January 20, 2020, 9:51pm UTC](https://community.glideapps.com/t/budapest-app/3812/1 "2020-01-20T21:51:45Z")

</div>

Hi,  
here my newest app, [Budapest](https://budapest.glideapp.io) guide for personal use for my upcoming trip. I say for personal use as I’ve placed only the POIs I’m going to visit.   
In the drawer you can find a translator tab, a currency conversion tab and a weather tab; the weather forecasts are in step of three hours. Next thing I’m going to do is to group the forecasts by day using the relations.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [January 20, 2020, 9:55pm UTC](https://community.glideapps.com/t/budapest-app/3812/2 "2020-01-20T21:55:35Z")

</div>

I love the weather forecast screen! What service do you use to get the data in? If you did that in Google Sheets, could you share how you did it here?

Also: you should visit the [Hospital in the Rock](https://www.sziklakorhaz.eu/en/).

---

<div class="post-metadata">

**Author:** ![thebepps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thebepps/32/2956_2.png) [@thebepps](https://community.glideapps.com/u/thebepps)\
**Post date:** [January 20, 2020, 10:11pm UTC](https://community.glideapps.com/t/budapest-app/3812/3 "2020-01-20T22:11:11Z")

</div>

Hey Mark, I use a script to pull the data from openweathermap, free plan allow to get 5 days forecast in step of three hours. I’ll send you the sheet in private msg as in the script there is my api key. In the script i have a function to calculate the time difference between the UTC time and Rome time and display the forecast in local time. I don’t use openweathermap icons because the icons are low quality.

Thanks for the suggestion.

---

<div class="post-metadata">

**Author:** ![thebepps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thebepps/32/2956_2.png) [@thebepps](https://community.glideapps.com/u/thebepps)\
**Post date:** [January 20, 2020, 10:25pm UTC](https://community.glideapps.com/t/budapest-app/3812/4 "2020-01-20T22:25:16Z")

</div>

Here is the script to get the data:

function myMeteo\_Budapest() {

var location = ‘Budapest,hu’;  
var apikey = ‘XXXXXXXXXXXXXX’; // Replace with your API key  
var forecastWeatherUrl = ‘[http://api.openweathermap.org/data/2.5/forecast?q=](http://api.openweathermap.org/data/2.5/forecast?q=)’ +  
location + ‘&units=metric&lang=it&apikey=’ + apikey;  
var response = UrlFetchApp.fetch(forecastWeatherUrl);  
var json = response.getContentText();  
var weatherData = JSON.parse(json);

[//Logger.log](https://Logger.log)(weatherData)

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘ImportApi’);

sheet.clear();

```
for (i=0; i<40; i++) {

var data_ora_prev = weatherData.list[i].dt_txt;
var meteo_icona = weatherData.list[i].weather[0].icon;
var meteo_descrizione = weatherData.list[i].weather[0].description;
var min_temp = weatherData.list[i].main.temp_min;
var max_temp = weatherData.list[i].main.temp_max;
var pressione = weatherData.list[i].main.pressure;
var umidita = weatherData.list[i].main.humidity;
var copertura = weatherData.list[i].clouds.all;
var dir_vento = weatherData.list[i].wind.deg;
var vel_vento = weatherData.list[i].wind.speed;

sheet.appendRow([data_ora_prev, meteo_icona, meteo_descrizione, min_temp, max_temp, pressione, umidita, copertura, dir_vento, vel_vento]);

}

```

var getTimeUrl = ‘[http://api.timezonedb.com/v2.1/convert-time-zone?key=XMBBZ92QIVM0&format=json&from=UTC&to=Europe/Budapest](http://api.timezonedb.com/v2.1/convert-time-zone?key=XMBBZ92QIVM0&format=json&from=UTC&to=Europe/Budapest)’;  
var resptime = UrlFetchApp.fetch(getTimeUrl);  
var json = resptime.getContentText();  
var time = JSON.parse(json);  
var diff\_orario = time.offset;

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘ImportApi’);  
sheet.getLastRow();  
sheet.appendRow([diff\_orario]);

}

---

<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:** [January 20, 2020, 10:28pm UTC](https://community.glideapps.com/t/budapest-app/3812/5 "2020-01-20T22:28:23Z")

</div>

Very cool! Both the app and the script!  
Great job 👍🏻