How to Send Data to a Google Sheet with MIT App Inventor
ฝัง
- เผยแพร่เมื่อ 3 พ.ย. 2024
- This video shows how to set up a Google Sheet with a form so that you can submit data to the sheet through your MIT App Inventor app.
To learn about how to read the data from the sheet, check out my tutorial How to use Google Sheets in MIT App Inventor: • How to Read Data from ...
Thanks for watching!
Smash those like and subscribe buttons :)
![How to send data to a google sheet with MIT app inventor [ Easy Way ]](http://i.ytimg.com/vi/PVM7h5QCnnM/mqdefault.jpg)
![⭐ฮิตในTikTok!! ( หมูเด้ง MooDeng ) Ver. แดนซ์โจ๊ะๆ ReMix BY [ ดีเจกิต รีมิกซ์ ]](http://i.ytimg.com/vi/3krsyfWUeHU/mqdefault.jpg)
![How to send data to a google sheet with MIT app inventor [ Google Sheet Database ]](/img/n.gif)
I really liked the way you explained things. I followed you step by step and finally got it after several failed attempts. Thanks a lot.
Worked perfectly first time. Big thanks for showing this technique. Opens up lots of possibilities.
Hey Bob, I was wondering if you could share your blocks with me if it wasn't a problem for you. I followed the same method as shown in the video, but it is not working for me. Thanks!
@@anarchygaminghd8114 I will, but I will have to dig around to find the app I built to test.
Thank you so much! This worked like charm. This solved a big headache for me since I wanted to collect GPS and Accelerometer data in large volumes with data just 1 second apart. Did not observe any performance issues inspite of this.
Hi, i did same programming, but not work for me. There is any conf. in button click set web url?
@Greicy Soares What is the exact issue you are facing? I didn't follow the exact steps in this video but used the overall idea to push sensor data from mobile into Google sheets using when Clock.Timer.
Thank you so much, I have finally finished my project, it's now working perfectly
That only work for one user?
or do you know if it can work with several users?
I cant get the links figured out
This was a fantastic tutorial. Very clear and well explained. Thank you!
Thank you.... your application works... it is a short and precise training video. Wonderful!
Thank you, Allison. Very clear and easy to follow, and awesome.
To work with Date Picker, you should create a variable (date) in the format year-month-day. And the month and day should have 2 digits to be accepted on google forms using the method of video. So, you should use a IF Month
I've tried it and it works!!! I'm looking for the second part of the video (for several users) but i didn't find it....
I dont think i got the links right
thank you, how can i read the device on which this app is installed & add it to a data cell to google sheet ?
Getting this "Cannot parse text argument to "list from csv table" as a CSV-formatted table"
@Ledger Kalel fake account
@@bentonbodie7994 fake account
I had the same issue, i solved it by setting the permission for my shared link for the google sheet from restricted to anyone can view it with the link and that solved it
@@markcahill9525 Gracias Amigo
I missed the "export" part of the change made to the url, it must end in /export?format=csv
Hi ! Nice video easy to reproduce on my example ! THANK YOU ! :) I just need now to find how to copy the contents of the answer sheet to a new one and to clear the answers' sheet ! !
Amazing! This is what I needed! Thanks a lot!
this probably wont get answered, but is there a way to remove the timestamp on the list view?
I have a problem. I Downloaded and runned this application, programming it exactly as in the video, but it don't let me use it because a error message appears
"Syntax Error: quote in unquoted cell
Cannot parse text argument to "list from csv table" as a CSV-formatted table"
Can you solve this problem?
I had the same error simply because I missed the crucial "export" part of the change made to the spreadsheet url - it needs to end in /export?format=csv
Quem for trabalhar com data, sugiro criar uma variável de texto no formato ano-mês-dia. Importante salientar que o mês e dia tem que ter 2 dígitos para ser aceito no google forms. Ou seja, colocar um "if" (Se) o mês do selecionador de data for menor que 10, adicionar um zero antes do mês na variável da data que você criar (ano-0mês-dia), senão data=(ano-mês-dia). O mesmo teste tem que ser feito para o dia.
I have 2 questions. At first if I delete the data from whole file and add a new value it comes as the next available and not at line 2 again, how can I fix it. And also how can I delete a line from the app
Allison I'm doing a song request app I've followed this tutorial for my app but when I test the app I'm getting timestamp name songname artist name NOT the person's name who submitted the form?
Thanks for sharing your amazing knowledge!!
Haii John by the way I am Neela and I wish you to make more vedios which are helpfull to us.
Very useful, but i have a small problem: I've used the app a lot and now have to really scroll down the google document to see the new restaurants I've rated, how can i refresh the document page so that the new restaurants will start reappearing from the top?
Got an error here. Please help me. Runtime Error - The operation Elements cannot accept the arguments: , ["Timestamp,ControlNumber, ...."]
Thank you! I am very grateful for this! Perfect clear explanation :-)
Thank you so much！ I could do it!
Thanks, this week I have homework to make a fill-in-the-blank quiz on app inventor with Google sheet, but how can I make the questions show up randomly in one label.
Hi. I followed your tutorial and it work. But can it be done sending data to two different excel and we can choose which excel to be send?
I can create a Google form that send data to Google sheets.. So what's the addition?
Hi there Allison, first thank you for this tutorial. I followed it to the letter. but I have one problem with it. Once I finished putting it all together and try to run it i get the following error, "cannot parse text argument to "list from csv table" as csv formatted table. i assume the returned text is not a csv table so that the block cat read it. But how or what do i need to do to get the right return from the sheet. thank you in advance. never mind :) i found in one of your previous videos that i needed to make the google sheet available to everyone with the link.
Ola! qual video ela mostra como corrigir o erro? O meu app deu o mesmo erro.
It doesn't work. I press the submit button and nothing happens. I also get this error: "cannot parse text argument to list from csv table as a csv-formatted table"
Merci beaucoup pour ce tutoriel très clair.
Hallo Allison, thanks a lot for the tutorial, it is explained perfectly. I am receiving an error though, "Cannot parse text argument to "list from csv table" as a CSV-formatted table". I checked three times and followed all your steps, what am I doing wrong? thanks!!
allright, figured it myself, it was in the share permission of the google sheet
I've done exactly as you did but it's not working, it sends error message that it can not accept the argument to csv list, pls help
I had a doubt reagarding this...i am creating a app in which i am trying to fugure out what free database i can use.My question is how much simultaneous connections can this method showed in ur video handle
Nice and unique ideas
I have a question ?
How do I send a sender's email compulsory in the application page?
I am a begginer and I just wanted to know: why your commands are different from mine? // I cannot use set __ .url nor call__.get // Please help me I would love to complete this tutorial
hello i have 2 questions 1st how can i read the latest order first? and 2nd how can i "clean" the submit button from the last order? thanks alot nice video !!
Hello! I tried to this tutorial but its not working for me. Plz help
How can I add more than one row at once? with a key perhaps? Your way of explaining is really great. I'll wait for more videos from you :)
Do you have part II?
I'm really like your video. After I follow your step on your video I have some problem I got some runtime error about "list from csv table". Can you help me about this runtime error?
Question: in the link, you add formResponse after which / slash / ?? and isn't the sheet called form responses 1 ???
hi tanks for your course . plz can i change my sheeet to register data (can i change responsefilename) into one database
Theoretically I can make a simple shared ledger system in google sheets with this method correct?
thank you - I was able to follow alone and got my app working just fine. I was able to take info and use it as a guide to complete a custom app for tracking information I gather while driving UBER and Lyft.
Thanks for sharing this.
how can I create a user and that each user has its independent database list ... likewise exporting in excel
Dear madame, thanks a lot for your great tutorials, you mentioned that this tutorial is part 1 of a 2 parts series, unfortunately I can't find part 2, can you please post it? Thanks again
Grande aula, parabens , informação seria possivel ao gerar um arquivo .csv enviar para uma pasta no google drive?
Awesome work, only one question, what emutor you use for run de app?
Sir, how to include Date filed at the time of join. (Because join is using for TXT button)
what are url 4 web1forreading and web2foradding tq
Great work ...Please make more videos 👍
This video is very helpful, I already make apk for my home task, but I have problem. can you help me? How to minus the data from airtable and show the data after we minus or update data after minus(like I have 10 stock of medicine and take 2 medicine and the the data will show 8) I hope you will help me and thanks for the best tutorial
how can you upload images to google sheet or google drive, using appinventor
Me too
Please I also need to know?
for me dont work. When push the button nothing happen. But when i simulate a link in web browser, app receive entry in a list. an anyone help me please?
Hello, i get an error stated "Cannot parse text argument to "list from csv table" as a csv-formatted table" can you help me with this?
Use The right list to csv
@@larvenkarlsson440 hi Larven, what do you mean by Use The right list to csv? I too am facing this issue and need to resolve it asap. Thanks for your help.
Can anybody help with this?
Ok people, google sheets has changed since then.... so the format has change.
the "formResponse" part change to "formResponse?usp=pp_url" and the end you need to add "&submit=Submit"
so example
original: docs.google.com/forms/d/e/1FAIpQLScQALhcKng47Bt2lL2h73qzRbh1bQF5dIf6cVawXqJwMvlizw/viewform?usp=pp_url&entry.890692672=x&entry.1377968603=y&entry.1162799495=z
new:
docs.google.com/forms/d/e/1FAIpQLScQALhcKng47Bt2lL2h73qzRbh1bQF5dIf6cVawXqJwMvlizw/formResponse?usp=pp_url&entry.890692672=x&entry.1377968603=y&entry.1162799495=z&submit=Submit
same problem here
Thanks a lot, really useful!
why google sheet not support arabic language .... so when i wrtie arabic text in app and send the text to Google sheet ,the text not show and hidden?
Do you have any tutorial for updating the data from MIT to google sheet?
This what I was looking for, thanks 😍😍
Keep sharing and helping 😉
How do we update existing data?
How do you have a variable for only one cell in google sheets?
thank you
I liked this video
I tried the exercise from your adorable video but received this error message: "error 1109 the specified URL is not valid" Incidentally despite the message the data was posted on the spreadsheets, Could you please tell me what I did wrong?
in Initialize Global ____ to ; how to find the name of blank? How do you get "restaurantList" as for typing
Could you help me out with this? My list viewer is clogged up with parentheses
sorry i’m too dumb to explain
This is exactly what I wanted to do! Thank you!
How to combine mit with barcode scanner with spreadsheet output??
how to validate user. can we use this for User Authentication.
Hi, am getting response code 400. Could you help me with it
Thank you for information. If I put a picture on form, how can I get to entry?
to google drive?
Cannot parse text argument to" list from csv table "as a CSV-formatted table.
I'm facing this error mam, please guide to overcome this error, thank you
mee too
Thanks for ur video
Terimakasih, sangat menolong...
We tried and have her this to work. We triple checked.
Why can't make you video on search or filter list view
Hi!
How to notify successful shipment?
I get a syntax error:quote in unquoted cell...Cannot parse text argument to "list from csv table" as a csv-formatted table. Can u help me to fix this.
Getting same error
Use The right list to csv
@@larvenkarlsson440 hi Larven, what do you mean by Use The right list to csv? I too am facing this issue and need to resolve it asap. Thanks for your help.
You are using The wrong block, read it carefully
@@larvenkarlsson440 hi Larven, I've spent a few hours literally starring at this problem but can't see how I've picked the wrong block. Can you please tell me which is the right block?
great Video... thanks… helped me alot… but how can i retrieve the data without the time? thank you very much
You can create another column that will transform the string into date value. I think that this link will be useful: exceljet.net/formula/convert-date-string-to-date-time
or you could just remove the 1st in row when you get the second list
i tried but name is not shown in excel sheet
Hi i really like the tutorial,
could you do a tutorial where you can show us how to add in one screen and see the list on another screen
Thank you !
woow i like this
Nice
Señorita buenas tardes, que tendria que hacer para modificar un registro ya grabado, siguiendo la misma tematica que implemento usted. Gracias de antemano y saludos desde Los Mochis, Sinaloa, México.
Than You....
How to use android studio emulator for mit app inventor
EXATAMENTE O QUE EU PRECISAVA! SIMPLES E DIRETO! MUITÍSSIMO OBRIGADO!!!
please help to solve this error
Muito bom. Me ajudou muito.
Hola Excelente tutorial vengo realizando una App en APP Inventor que me permita copiar datos de la tabla inicial en una segunda tabla pero ciertos datos filtrados y que los muestre en un mapa , para esto vengo trabajando con fusion tables y estoy tratando con la siguiente sintaxis : INSERT INTO tabla2 SELECT Fecha, Nombre, Apellidos, DNI, Celular, NumeroPedido, Latitud, Longitud, AgenteComercial FROM tabla1 WHERE DNI = '12345' . Quiero insertar en la tabla 2 todas las columnas en la tabla 1 donde el DNI sea igual a 12345. Me aparece error, he probado con encerrar en parentesis los nombres de las columnas de la tabla1 igual aparece error: Error 2601: Fusion tables returned an error... The response was: 400 bad request invalid query: Parse error near 'SELECT' (line 1, position 54). Por favor su apoyo cual seria la sintaxis correcta u otras acciones para que funcione. Gracias por su Respuesta. Saludos
How to code( MIT APP INVENTOR), if i wish to save an image to the spreadsheet from the uploaded image on the app screen?
spreadsheets arent meant for images, you can instead have the link of the image or use a different database like cloud db
Nice that's job
nice... i have follow every single step, but when i test into phone, the popup show
"Bad arguments to list csv table
The operation list to csv table cannot accept the arguments:,
[Timestamp,Name,Rating
.................................
................................]
why ya? somebody can help me plisss
same here
@@onnojogot9014 i found the prob... check the puzzle blue "list from csv table text"... its work alhmdllah
@@shahkhir7428 Which one ooz am having the same error message
@@Richakitchen916 check the blue puzzle
Followed Everything you did And it does not work. Triple checked still nothing.
Hi, great tutorial!
Is possible to update the insered data from app?
That s what I need too
Thank you for sharing this tutorials. I would like to ask you one question, how to delete data information from google sheet with MIT APP INVENTOR 2 . Please answer my questions!
makasih sudah membantu
thanks a lot
Boa tarde muito, seu tutorial e Excepcional. Grande abraço, Bruno Fernandes.
Good afternoon, your tutorial and Exceptional. Big hug, Bruno Fernandes