Add spreadsheet row data to labels

[joseph.2023]

Hello All,
I have a google sheet where I will update weather data of 10 different areas starting from row 2 as row 1 is header. Column A is date and time, Column B is Area name and from Column C is where the actual weather data starts. Like temperature in Column C, Column D is Pressure, Column E is humidity percentage, column F is weather description and so on. The new data gets rewritten on existing rows frequently, which is working fine. Now I want to create an app in which when the user selects one of the 10 areas from the spinner, then the weather data of that particular area is auto fetched from that particular row of the google sheet and placed in the respective weather data labels. Is this possible?

Thank You

[ABG]

How much Designer work have you invested so far into the display?

What you want is very possible, within the constraints of the google sheet download frequency capacity.

P.S. Lazy way to display a Sheet in YAML:

Browse Google Sheets in YAML format

This tutorial is meant to show an alternative way to display wide table data in portrait mode. It uses YAML. YAML is a data serialization language that is often used for writing configuration files. Depending on whom you ask, YAML stands for yet another markup language or YAML ain't markup language (a recursive acronym), which emphasizes that YAML is for data, not documents. This tutorial is browse-oriented, and centers around a value procedure that can take a table (row of rows) with a heade…

Also, more techniques for Google Sheets:

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[TIMAI2]

I showed something similar yesterday

https://community.appinventor.mit.edu/t/which-layout-instead-of-tablearrangement/83542/13

[ABG]

P.S. Pull in a Clock component from the Sensors Drawer for the auto-refresh.
Don't be a pest to the server.

[joseph.2023]

Thank you @ABG and @TIMAI2. I did try out TIMAI's method of making the sheet public and then pulling the data for the rows and it works brilliantly. Now I have a few more questions.. You said "Don't be a pest to the server.". If my users keep checking the weather data, it will frequently open the public google sheet, then would my google account get banned for high usage or the sheet temporarily becoming offline? Second question is, if my users frequently check weather data, the app would be opening csv file of the google sheet, would that increase the app cache size, if yes how to tackle it?

Thanks

[ABG]

@joseph.2023

If my users keep checking the weather data, it will frequently open the public google sheet, then would my google account get banned for high usage or the sheet temporarily becoming offline?

Certainly don't go polling the weather spreadsheet in a Clock Timer, weather doesn't change that frequently.

Make your users click a Button to get a download, or just download once when the app starts.

Google's quota response would depend on your user count. See

ขีดจำกัดการใช้งาน  |  Google Sheets  |  Google for...

to get an idea of the limits.

@joseph.2023

Second question is, if my users frequently check weather data, the app would be opening csv file of the google sheet, would that increase the app cache size, if yes how to tackle it?

I can't imagine any harm from saving the last download locally in the phone.
Even if you have a weather history pack rat, this is a tiny bit of data in the grand scheme of things.