Read data from google sheet V2

MIT App Inventor Help
1

Hello everyone, a few months ago, I created an application to read the data of a google sheet in MIT APP INVENTOR in labels. This application allows to load the google sheet in CSV format. This application worked perfectly until today. It turns out that the apk downloaded and installed on my phone still works, but that the app with the companion and when one generates a QR code no longer works. I would like to point out that this application has not been changed one iota since its creation and operation.
Has MIT APPINVENTOR made an update regarding this manipulation?

In addition, I had a project to create another application on the same basis and I had copied the blocks identically in my new applicationbut it doesn’t work either.

I would really need the new block solution to repair my old application and create the new one.

This solution allowed me to read the Google Sheet data in real time, just by updating on MIT APP INVENTOR.

Thank you in advance for your help.

Capture d’écran 2021-02-16 091145
Capture d’écran 2021-02-16 0911451337×618 68.8 KB

1 Like
2

Capture d’écran 2021-02-16 091102
Capture d’écran 2021-02-16 0911021343×635 148 KB

3

The app for blocs : Forum_help.aia (3.3 MB)

4

This

image

looks wrong, you are setting the sheet name to the spreadsheet ID ?

1 Like
5

Hello, yet it was still 2 months ago that it worked. In your opinion, what should be changed?

1 Like
6

oui, je pense pouvez vous regarder dans le .aia pour être sûr

1 Like
7

Try changing it to "ID_sheet_name". Does your app works as expected then ?

1 Like
8

Could you explain me what i can change

1 Like
9

image

1 Like
10

I try and i have an error : Select list item: Attempt to get item number 2 of a list of length 1: ["https://docs.google.com/spreadsheets/d/1QT6vUsYcXuw8zGuISbY6KUUSYO4nRP4yRcH_EvPq6ws/gviz/tq?tqx=out:csv&sheet=SITE 1"]

1 Like
11

Could you edit the app and return me with modifications ?

1 Like
12

I am with a client online at the moment, will have a look later on.

1 Like
13

ok thanks you very much for your help !

1 Like
14

Your spreadsheet does not appear to have "anyone can view" permission. it will not work in App inventor without it.

1 Like
15

How can i make that ?

1 Like
16

On spreadsheet click here (top right)
image

Click on "Change to anyone with the link"
image

Should then look like this:

image

Click on Done.

1 Like
17

Made a few block changes, also re encoded your gif and put it in a webview, removing 5mb of files. Errors gone ....

Forum_help_revised.aia (371.9 KB)

1 Like
18

The problem was on the second screen on the and it still doesn’t work out do you have a solution to read the data from the google sheet? I authorized via the link the modification as you asked me above

1 Like
19

It is reading the google sheet....

1 Like
20

Ah, I see you have changed the sheet name from STOCK BENNES to SITE 1.

Edit the ID_sheet_name block to SITE1 and edit the spreadsheet tab names to SITE1, SITE2, SITE3....

(Spaces are never a good thing)

1 Like