Hello friends, I’m having problems sending data to the spreadsheet, it’s only sending some data and not others. He writes on top of others,
Follow below.
how and saved
how do you send
Apps script have 10 col but you are trying to send 11 col
You can use another apps script in which you can send all the data at once instead of sending one after another.
I always use this code to send 200+ rows of data at once using loop. Because we cannot send data more than 95 at once
I’ll take a look
but I don’t see any error in the code
Script code doesnot have error alert.
Use response code it will throw 400
Script code have 10 col but in blocks, make a list there are 11 items, so it doesnt work
that’s right here
I don’t know how to use
can help
Use response code it will throw 400
What about reading the response content?
Note: it might be a response in html format…
Taifun
hello friend
no error comes
it is just sub writing the data
this with more than 4 data to send
it disappears with the first or last
can help
You have 2 options
-
send each row asynchronously, i.e. send 1 row and AFTER it has been sent in the Web.GotText event send the next row, for an example of asynchronous processing see App Inventor Tutorials and Examples: Webprefetch File by File | Pura Vida Apps
-
follow the suggestion from @Still-learning
Taifun
1 Like
nothing
without leaving the place
somebody
???
Read my previous answer and choose one of the 2 options… option 2 will be the faster approach
Taifun