How to read single line in google sheet according to date

MIT App Inventor Help
1

HI,
I create a google sheet with following heading
date name age address
and I would like to retrieve data in the sheet according to the current todays date, where it will show different data every day according to google sheet....
Any Idea?
thanks

2

This is possibly the best method:

Query Any Google Sheet with a Web App

(note: if your locale uses semi-colons in formulas instead of commas, you will need to edit the formula in the script)

I have got to get around to changing this.....:wink:

3

an alternative solution would be the Google Visualization API, see an example here App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

4

guess I have create a simple google sheet with the following headings
Date----Name----Age----weight
and then I added records to google sheet directly
Q:
How can I lookup a specific Date (date of the system) when I load the screen and show all the records in the same row. NOT on list view, but.just show it on text boxes or labels.
thanks for supporting ... just new to the community and MIT.

5

you already asked that question... let me suggest you to read the answers...
I now merged the 2 threads..

Taifun

6

Thank you for your help..
I don't want to show up data on list.. Just show it separetly with text or label
Thanks again Taifun

7

follow one of the 2 suggestions.. try something...
and if you get stuck, then post a screenshot of your relevant blocks...
see also tip 2 here https://puravidaapps.com/learn.php

Taifun

8

You can refer to YouTube tutorials

Or you can used CloudSheets Extension
Or SkySheets Extension

2 Likes
9

Links would be useful, along with whether they are paid or not .....

10

It's an amazing project by @Mateja and has some free plans available with AI2/Kodular extensions.

https://skysheets.com

2 Likes