Tengo un problema con la extracción de datos de google sheets a mi aplicacion en mit app inventor

[Josh0706]

Hello, timai2, yes it works for me but I need you to make the connection with a google meet sheet as a database where the data that the list will show in the application is generated

[TIMAI2]

[Josh0706]

I thank you for your quick answer TIMAI2, the first link is from the sheet, but where are the second and third links from?.

I can't find it since I have it in Spanish

[TIMAI2]

@Josh0706

where are the second and third links

There is only one link / spreadsheet url ?

[Josh0706]

me refiero al segundo, luego del link de la hoja, por que el tercero es del rango que se va a enviar

[TIMAI2]

I am sorry, I do not understand what you mean....

[Josh0706]

1. where did this come from?
   

2.Where did the table viewer come from or from which block is n taken?

[TIMAI2]

1. It is just a google sheet (ID) I use with a table of data, for examples and demonstrations...

2. If you go back to post number 2 in this topic, I suggested using Tableviewer to display your two columns of data....

[Josh0706]

Could you send me the extension, I can't find it, I'm very new to this so do you know how I can get the (ID) from my google sheets sheet?

[TIMAI2]

@Josh0706

Could you send me the extension

Go to THIS URL, you want v6

@Josh0706

how I can get the (ID) from my google sheet

If you open a google sheet you will see its url in the url address bar at the top. The ID is the long string of characters in the middle of the url.
for example:

https://docs.google.com/spreadsheets/d/1IdpGILd7Nii8nq5yb2Qu3kVFyyL50eo5la2xbDN1Cok/edit#gid=0

The ID is:

1IdpGILd7Nii8nq5yb2Qu3kVFyyL50eo5la2xbDN1Cok

[Josh0706]

keep bugging about cvs

[TIMAI2]

What does your responseContent look like ?

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

[Josh0706]

It looks something like this when I ask for the list

[TIMAI2]

What does your responseContent look like (see my previous post for how to show it) ?

[Josh0706]

Done, thank you for your help, I already solved why it didn't send or mark the problem with the CSV format, it was because it was badly written, although I try it with other projects and despite being well written, it marks the same error, but it works where I need. One more thing, do you know how to rewrite google sheets cells of a form after having already used the cell (no problem if you don't know :smiley )

[TIMAI2]

@Josh0706

do you know how to rewrite google sheets cells of a form after having already used the cell

Please explain what you mean....

[Alwen]

Can you please tell me how to rewrite google sheets cells of a form after having already used the cell

[TIMAI2]

Please explain what you mean...

[Alwen]

How to change data of a cell in which has other data?

[TIMAI2]

You want to update the value in a google sheet cell ?

Use the native Spreadsheet component

or Google Apps Script