No video

How to Send Data to a Google Sheet with MIT App Inventor

  Рет қаралды 186,739

Allison John

Allison John

Күн бұрын

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 :)

Пікірлер: 192
@bobhoward3555
@bobhoward3555 4 жыл бұрын
Worked perfectly first time. Big thanks for showing this technique. Opens up lots of possibilities.
@anarchygaminghd8114
@anarchygaminghd8114 4 жыл бұрын
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!
@bobhoward3555
@bobhoward3555 4 жыл бұрын
@@anarchygaminghd8114 I will, but I will have to dig around to find the app I built to test.
@abdullahialfa1476
@abdullahialfa1476 3 жыл бұрын
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.
@disenoccmacapulco8792
@disenoccmacapulco8792 5 жыл бұрын
Thank you so much, I have finally finished my project, it's now working perfectly
@javierreyna5321
@javierreyna5321 4 жыл бұрын
That only work for one user? or do you know if it can work with several users?
@haroldcrenshaw5630
@haroldcrenshaw5630 4 жыл бұрын
I cant get the links figured out
@MrBanks14
@MrBanks14 3 жыл бұрын
Getting this "Cannot parse text argument to "list from csv table" as a CSV-formatted table"
@MrBanks14
@MrBanks14 3 жыл бұрын
@Ledger Kalel fake account
@MrBanks14
@MrBanks14 3 жыл бұрын
@@bentonbodie7994 fake account
@markcahill9525
@markcahill9525 3 жыл бұрын
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
@johanbike
@johanbike 3 жыл бұрын
@@markcahill9525 Gracias Amigo
@mc-rt5pm
@mc-rt5pm 3 жыл бұрын
I missed the "export" part of the change made to the url, it must end in /export?format=csv
@cosmosandchill
@cosmosandchill 3 жыл бұрын
This was a fantastic tutorial. Very clear and well explained. Thank you!
@rafaelnogueira9447
@rafaelnogueira9447 5 жыл бұрын
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
@davidsnaith9041
@davidsnaith9041 4 жыл бұрын
Thank you, Allison. Very clear and easy to follow, and awesome.
@AlexanderVaidhyan
@AlexanderVaidhyan 2 жыл бұрын
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.
@greicysoares366
@greicysoares366 2 жыл бұрын
Hi, i did same programming, but not work for me. There is any conf. in button click set web url?
@AlexanderVaidhyan
@AlexanderVaidhyan 2 жыл бұрын
​ @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.
@alanwtlim4531
@alanwtlim4531 3 жыл бұрын
Thank you.... your application works... it is a short and precise training video. Wonderful!
@fredericblanchard6358
@fredericblanchard6358 4 жыл бұрын
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 ! !
@pilucapiluca9735
@pilucapiluca9735 4 жыл бұрын
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....
@haroldcrenshaw5630
@haroldcrenshaw5630 4 жыл бұрын
I dont think i got the links right
@nurijeong6235
@nurijeong6235 5 жыл бұрын
Amazing! This is what I needed! Thanks a lot!
@joelmirramos5096
@joelmirramos5096 3 жыл бұрын
Thanks for sharing your amazing knowledge!!
@rafaelnogueira9447
@rafaelnogueira9447 5 жыл бұрын
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.
@Carlsaver
@Carlsaver 4 жыл бұрын
Thank you! I am very grateful for this! Perfect clear explanation :-)
@ilnias94
@ilnias94 3 жыл бұрын
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?
@mc-rt5pm
@mc-rt5pm 3 жыл бұрын
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
@user-zj2xx9hw5k
@user-zj2xx9hw5k Жыл бұрын
Haii John by the way I am Neela and I wish you to make more vedios which are helpfull to us.
@imtiazavi
@imtiazavi 5 жыл бұрын
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 :)
@coolvibesreloaded7946
@coolvibesreloaded7946 16 күн бұрын
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?
@yedekhpahle9119
@yedekhpahle9119 5 жыл бұрын
Great work ...Please make more videos 👍
@neronlaqua
@neronlaqua 3 жыл бұрын
Merci beaucoup pour ce tutoriel très clair.
@SoulCast7
@SoulCast7 4 жыл бұрын
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"
@VerdictGonzales
@VerdictGonzales 4 жыл бұрын
Got an error here. Please help me. Runtime Error - The operation Elements cannot accept the arguments: , ["Timestamp,ControlNumber, ...."]
@JinaneKarhaniRawda
@JinaneKarhaniRawda Жыл бұрын
thank you, how can i read the device on which this app is installed & add it to a data cell to google sheet ?
@elysion8747
@elysion8747 4 ай бұрын
this probably wont get answered, but is there a way to remove the timestamp on the list view?
@roquefabian
@roquefabian 4 жыл бұрын
how can you upload images to google sheet or google drive, using appinventor
@naveensingh3785
@naveensingh3785 4 жыл бұрын
Me too
@reniervanrensburg1664
@reniervanrensburg1664 4 жыл бұрын
Please I also need to know?
@user-mf6kb1ql5v
@user-mf6kb1ql5v 4 жыл бұрын
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
@sarahqanawaty
@sarahqanawaty 2 жыл бұрын
I can create a Google form that send data to Google sheets.. So what's the addition?
@kingsken7336
@kingsken7336 2 жыл бұрын
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
@danicakate741
@danicakate741 2 жыл бұрын
Hello! I tried to this tutorial but its not working for me. Plz help
@daniaabdulrahman6694
@daniaabdulrahman6694 5 жыл бұрын
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?
@larvenkarlsson440
@larvenkarlsson440 5 жыл бұрын
Use The right list to csv
@imranyaaqub1704
@imranyaaqub1704 5 жыл бұрын
@@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.
@markdeeming4765
@markdeeming4765 5 жыл бұрын
Can anybody help with this?
@firerousgt7446
@firerousgt7446 5 жыл бұрын
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
@onnojogot9014
@onnojogot9014 4 жыл бұрын
same problem here
@user-xt3my9jc2f
@user-xt3my9jc2f Жыл бұрын
Thank you so much! I could do it!
@phoneguy4901
@phoneguy4901 5 жыл бұрын
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.
@monaelwy
@monaelwy 5 жыл бұрын
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
@greicysoares366
@greicysoares366 2 жыл бұрын
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?
@bassamdaowdaljbory4349
@bassamdaowdaljbory4349 3 жыл бұрын
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?
@Assassinso-w5c
@Assassinso-w5c 2 жыл бұрын
i cannot understand the last how to export app
@dimitrioschatzifoteinos3809
@dimitrioschatzifoteinos3809 4 жыл бұрын
Thanks a lot, really useful!
@madart666
@madart666 4 жыл бұрын
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 !!
@mohdzainuddinbinmahmoodkpm3842
@mohdzainuddinbinmahmoodkpm3842 3 ай бұрын
what are url 4 web1forreading and web2foradding tq
@rocco9008
@rocco9008 3 жыл бұрын
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.
@dancarll1091
@dancarll1091 3 жыл бұрын
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.
@Elizabeth-io4rh
@Elizabeth-io4rh 2 жыл бұрын
Ola! qual video ela mostra como corrigir o erro? O meu app deu o mesmo erro.
@pmasfp
@pmasfp Жыл бұрын
Do you have part II?
@farizahalim7246
@farizahalim7246 10 ай бұрын
How do we update existing data?
@FilipeGhesla
@FilipeGhesla 4 жыл бұрын
Thanks for sharing this.
@flaviodavideborriello5128
@flaviodavideborriello5128 4 жыл бұрын
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?
@rajeshkumarratilalvasava74
@rajeshkumarratilalvasava74 3 жыл бұрын
i tried but name is not shown in excel sheet
@hermannrudas
@hermannrudas 4 жыл бұрын
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
@shahkhir7428
@shahkhir7428 4 жыл бұрын
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
@onnojogot9014
@onnojogot9014 4 жыл бұрын
same here
@shahkhir7428
@shahkhir7428 4 жыл бұрын
@@onnojogot9014 i found the prob... check the puzzle blue "list from csv table text"... its work alhmdllah
@Richakitchen916
@Richakitchen916 4 жыл бұрын
@@shahkhir7428 Which one ooz am having the same error message
@shahkhir7428
@shahkhir7428 4 жыл бұрын
@@Richakitchen916 check the blue puzzle
@sushrutkrishna1727
@sushrutkrishna1727 5 жыл бұрын
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.
@SandeepSingh-wn9gw
@SandeepSingh-wn9gw 5 жыл бұрын
Getting same error
@larvenkarlsson440
@larvenkarlsson440 5 жыл бұрын
Use The right list to csv
@imranyaaqub1704
@imranyaaqub1704 5 жыл бұрын
@@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.
@larvenkarlsson440
@larvenkarlsson440 5 жыл бұрын
You are using The wrong block, read it carefully
@imranyaaqub1704
@imranyaaqub1704 5 жыл бұрын
@@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?
@DiegoGarcia-sq2yu
@DiegoGarcia-sq2yu 4 жыл бұрын
how can I create a user and that each user has its independent database list ... likewise exporting in excel
5 жыл бұрын
Awesome work, only one question, what emutor you use for run de app?
@Stuckathomemom
@Stuckathomemom 3 жыл бұрын
Where is part 2?
@haroldcrenshaw5630
@haroldcrenshaw5630 4 жыл бұрын
Question: in the link, you add formResponse after which / slash / ?? and isn't the sheet called form responses 1 ???
@Sammy213
@Sammy213 4 жыл бұрын
This is exactly what I wanted to do! Thank you!
@The848382
@The848382 4 жыл бұрын
Nice and unique ideas I have a question ? How do I send a sender's email compulsory in the application page?
@DirectionFilms
@DirectionFilms 4 жыл бұрын
how to validate user. can we use this for User Authentication.
@narendrakumarkoratamaddi6521
@narendrakumarkoratamaddi6521 4 жыл бұрын
Sir, how to include Date filed at the time of join. (Because join is using for TXT button)
@midokaram2186
@midokaram2186 4 жыл бұрын
hi tanks for your course . plz can i change my sheeet to register data (can i change responsefilename) into one database
@MrJayajah
@MrJayajah 5 жыл бұрын
This what I was looking for, thanks 😍😍 Keep sharing and helping 😉
@Build_the_Future
@Build_the_Future 4 жыл бұрын
How do you have a variable for only one cell in google sheets?
@fishingwalker92
@fishingwalker92 4 жыл бұрын
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?
@mmtech6012
@mmtech6012 2 жыл бұрын
Followed Everything you did And it does not work. Triple checked still nothing.
@kabibabdullah4177
@kabibabdullah4177 4 жыл бұрын
How to combine mit with barcode scanner with spreadsheet output??
@NinjaNuggets21
@NinjaNuggets21 3 жыл бұрын
Theoretically I can make a simple shared ledger system in google sheets with this method correct?
@djefi
@djefi 5 жыл бұрын
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?
@shreshthshrivastava5932
@shreshthshrivastava5932 3 жыл бұрын
Could you help me out with this? My list viewer is clogged up with parentheses
@adithyabalaji5132
@adithyabalaji5132 3 жыл бұрын
sorry i’m too dumb to explain
@rajeshkumarratilalvasava74
@rajeshkumarratilalvasava74 3 жыл бұрын
please help to solve this error
@haslinatawyer7513
@haslinatawyer7513 2 жыл бұрын
i follow everthing but its didnt working...
@IshitaIyer2014
@IshitaIyer2014 2 жыл бұрын
I liked this video
@wahyuhidayat1500
@wahyuhidayat1500 4 жыл бұрын
in Initialize Global ____ to ; how to find the name of blank? How do you get "restaurantList" as for typing
@jimstevediapera2610
@jimstevediapera2610 4 жыл бұрын
Do you have any tutorial for updating the data from MIT to google sheet?
@riccardomussi2865
@riccardomussi2865 Жыл бұрын
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!!
@riccardomussi2865
@riccardomussi2865 Жыл бұрын
allright, figured it myself, it was in the share permission of the google sheet
@joaocarlos198
@joaocarlos198 Жыл бұрын
Grande aula, parabens , informação seria possivel ao gerar um arquivo .csv enviar para uma pasta no google drive?
@gastongatti456
@gastongatti456 4 жыл бұрын
Hi! How to notify successful shipment?
@florinlica4986
@florinlica4986 4 жыл бұрын
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 !
@sanarci
@sanarci 3 жыл бұрын
thank you
@lagimegabekasi
@lagimegabekasi 5 жыл бұрын
please make video how to update that...
@mortuzaalamrubel8217
@mortuzaalamrubel8217 5 жыл бұрын
Thanks for ur video
@sciencedude3335
@sciencedude3335 4 жыл бұрын
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
@damuha4751
@damuha4751 4 жыл бұрын
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?
@leonardocabral8000
@leonardocabral8000 5 жыл бұрын
how to search by date in the list and display the result.
@LeandroBranquinho
@LeandroBranquinho 5 жыл бұрын
EXATAMENTE O QUE EU PRECISAVA! SIMPLES E DIRETO! MUITÍSSIMO OBRIGADO!!!
@anandh1967
@anandh1967 4 жыл бұрын
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
@rajaaswathaman4652
@rajaaswathaman4652 4 жыл бұрын
mee too
@mirrotullailym7438
@mirrotullailym7438 5 жыл бұрын
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
@ganeshsanthosh4858
@ganeshsanthosh4858 4 жыл бұрын
How to use android studio emulator for mit app inventor
@sankalphumara1832
@sankalphumara1832 4 жыл бұрын
Hi, am getting response code 400. Could you help me with it
@forheenahmed7173
@forheenahmed7173 5 жыл бұрын
How to code( MIT APP INVENTOR), if i wish to save an image to the spreadsheet from the uploaded image on the app screen?
@firerousgt7446
@firerousgt7446 5 жыл бұрын
spreadsheets arent meant for images, you can instead have the link of the image or use a different database like cloud db
@LEOPLP
@LEOPLP 4 жыл бұрын
Muito bom. Me ajudou muito.
@ivanmiskovic6897
@ivanmiskovic6897 5 жыл бұрын
great Video... thanks… helped me alot… but how can i retrieve the data without the time? thank you very much
@gabrielmiyahara3786
@gabrielmiyahara3786 5 жыл бұрын
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
@firerousgt7446
@firerousgt7446 5 жыл бұрын
or you could just remove the 1st in row when you get the second list
@checko07
@checko07 4 жыл бұрын
We tried and have her this to work. We triple checked.
@anilshahane8398
@anilshahane8398 4 жыл бұрын
Why can't make you video on search or filter list view
@sicsolucoesbyfedericolongh6090
@sicsolucoesbyfedericolongh6090 5 жыл бұрын
Thanks for your work..... i want to know if is there posibility of send to app ipertestual text .... new hanks
@digitalistan
@digitalistan 5 жыл бұрын
Thank you for information. If I put a picture on form, how can I get to entry?
@digitalistan
@digitalistan 5 жыл бұрын
to google drive?
@oggieunaltropost
@oggieunaltropost 5 жыл бұрын
Hi, great tutorial! Is possible to update the insered data from app?
@pedropellegrini
@pedropellegrini 4 жыл бұрын
That s what I need too
@brunofernandes162
@brunofernandes162 5 жыл бұрын
Boa tarde muito, seu tutorial e Excepcional. Grande abraço, Bruno Fernandes. Good afternoon, your tutorial and Exceptional. Big hug, Bruno Fernandes
@CarlosSanchez-uf8jj
@CarlosSanchez-uf8jj 2 жыл бұрын
I literally copied word by word and its not working
@nuriselamet4549
@nuriselamet4549 5 жыл бұрын
Terimakasih, sangat menolong...
@jismaelcr
@jismaelcr 5 жыл бұрын
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.
@coolvibesreloaded7946
@coolvibesreloaded7946 16 күн бұрын
#Allison mines not working help
How to send data to a google sheet with MIT app inventor [ Easy Way ]
8:06
How to Read Data from Google Sheets in MIT App Inventor
17:55
Allison John
Рет қаралды 178 М.
PEDRO PEDRO INSIDEOUT
00:10
MOOMOO STUDIO [무무 스튜디오]
Рет қаралды 18 МЛН
WILL IT BURST?
00:31
Natan por Aí
Рет қаралды 28 МЛН
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 85 МЛН
How to get google sheet data in MIT App Inventor app.
10:04
The Coding Bus
Рет қаралды 10 М.
App Inventor #3 - writing to and reading from a database
12:34
pineapple999 dot net
Рет қаралды 266 М.
Store Data using Tiny DB In MIT app inventor 2 | Part 1
6:21
electronics forever
Рет қаралды 96 М.
How to Publish Your MIT App Inventor App to Google Play
25:11
Coding Mind
Рет қаралды 93 М.
App Inventor 2 Tutorial - How to create and store text files on your phone
7:22
MIT App Inventor + Google Spreadsheet (Hoja de cálculo de Google)
1:42:26
Curso de App Inventor 2 (José Luis Núñez)
Рет қаралды 87 М.