Bad List argument to Foreach

MIT App Inventor Help
, ,
1

i got this error when i follow this tutorial

this the error

crud
crud764×1600 29 KB

anyone know how fix that?

2

Your problem lies with your google apps script. Ensure you have the correct url for the script in your app, and that you have published/deployed it correctly after making any changes to the script.

If all that checks out for you, then we need to see the entire content of what is being returned (the second argument) to identify where you have a problem.

Because the web app script uses doGet(e), you can test if the script is working in your computer browser with this url:

<scriptURL>?ID=<SpreadsheetID>&SH=<CRUDII>&FN=READ

e.g.

https://script.google.com/macros/s/
AKfycbyK5jPRw-HqD8yCihIyhVwHFaVdC6R_u9m3NsX_L0HwCV9WggE/exec
?ID=1GeU67XhCFpBbYkgORpFUc3Z9y9AexPMNtC7d-J3ju4c&SH=CRUDII&FN=READ

This should return the contents of your spreadsheet to the browser (or, depending on your settings, save the data to a csv file) - or an error message if things aren't working

3

this the error message

error
error1433×183 14.3 KB

4

Your spreadsheetID is incorrect

5

This my Spreadheet ID
ID

6

Open your spreadsheet (is it your spreadsheet?), and check the ID in the url address bar

then in your app check it matches what you have in the variable id

image