No video

How to Read Data from Google Sheets in MIT App Inventor

  Рет қаралды 178,151

Allison John

Allison John

Күн бұрын

Пікірлер: 184
@ItaloBarbiero
@ItaloBarbiero 4 жыл бұрын
Very good tutorial. The only thing you need to fix is this: You shouldn't open Screen1 to go back, because you are actually opening another instance of Screen1, which will stack in memory, eventually making your app force close with a "not enough memory" error. Instead, you should CLOSE the Person screen.
@amandeepmaroke6267
@amandeepmaroke6267 4 жыл бұрын
This video was incredibly helpful and you explained the process very well, including why you were taking certain steps. Many thanks!
@guzmadera
@guzmadera Жыл бұрын
Muchas gracias y enhorabuena por el tutorial, llevo meses buscando esto, y hay que ver lo sencillo que lo haces y el resultado extraordinario🥰
@marcelocheves
@marcelocheves 5 жыл бұрын
Thanks Allison, with you explanation a bright light shine my brain and finnaly I finish my proyect, you are the best.
@eskandar326
@eskandar326 3 жыл бұрын
THANK YOU SO MUCH. YOU JUST SAVE MY COLLEGE DEGREE
@jmunozve
@jmunozve 11 ай бұрын
Thaks Allison... you explain very well. i made all... and great... I love you !!!!!
@arnavpro4001
@arnavpro4001 3 жыл бұрын
Very nice app. Worked superbly for me.
@niceman567
@niceman567 3 жыл бұрын
Thanks Allison! hope there will be videos in relation to delete/update google sheet records.
@lucianacontreras2966
@lucianacontreras2966 5 жыл бұрын
You Saved My Lije...... Thank you so much...... You deserve the world :)
@neelmalwatkar6095
@neelmalwatkar6095 4 жыл бұрын
Amazing video, would love to see more videos on MIT app Inventor. Helpful tutorial!
@RizzProductions786
@RizzProductions786 4 жыл бұрын
it was really helpful for me. I was actually searching for these things. Thank you So much.
@sandipp301
@sandipp301 5 жыл бұрын
Thanks Alison ,It works I developed same app with 500 people database but with search option and thinking to add some more features like calling from the screen
@thiagoavila9592
@thiagoavila9592 5 жыл бұрын
Can you tell me how you did for add search option and get the result?
@firerousgt7446
@firerousgt7446 5 жыл бұрын
search for loops in list
@thiagoavila9592
@thiagoavila9592 5 жыл бұрын
@@firerousgt7446 How i do that? im kinda newbie on it.
@youssefmossoba1823
@youssefmossoba1823 6 жыл бұрын
Excellent tutorial, I wish you can do more of that. Keep on the good work!
@gabrielfaveromiranda1503
@gabrielfaveromiranda1503 3 жыл бұрын
Thank you so much, this video really help me.
@thebrainc
@thebrainc 5 жыл бұрын
Great! Simple, complete and effective. Very good code. Thanks
@johnjurotte7256
@johnjurotte7256 4 жыл бұрын
Great video Allison, thanks!
@amiyaranjan2900
@amiyaranjan2900 5 жыл бұрын
You are suberb Allison...it was very helpful. Please resume making more videos. Regards
@vanthenkim2730
@vanthenkim2730 3 жыл бұрын
Thank you! Wonder you can make another video reading from google sheet but a specific sheet.
@HMR422
@HMR422 6 жыл бұрын
Thank you for the video! I'm using fusion tables to do something similar, it helped a lot!
@mungaomollo
@mungaomollo 4 жыл бұрын
community.kodular.io/t/custom-downloader-extension-for-kodular-free/16487 check this thread out.
@vincentxing8962
@vincentxing8962 6 жыл бұрын
Thanks for a clear illustration!
@projectdimpreza
@projectdimpreza 5 жыл бұрын
Hello can you help me with my project? I want to create an App that will read and display column 1 of google spreadsheet and display it as a text label in my android app whenever a button is pressed. Then display column 2 when the button is press again and so on..
@marconcio
@marconcio Жыл бұрын
Thanks a lot. Very clear.
@yiuan8085
@yiuan8085 2 жыл бұрын
very clear....
@redshop1234
@redshop1234 6 жыл бұрын
Thanks Allison. Great video!
@santramedia
@santramedia 4 жыл бұрын
tks for your help. Your video is very good. tks all
@wasitadjseeta2513
@wasitadjseeta2513 5 жыл бұрын
Thank you very much, will try to make it
@chanmh85
@chanmh85 6 жыл бұрын
Dear Alison, your video is great, clear and simple to understand. Thank you. However, it shows how we could pull data from goggle sheet. What about saving data from appinventor to goggle sheet ? Do you have a video on this or could you make and upload one ? Thanks again.
@chanmh85
@chanmh85 6 жыл бұрын
Thank you and appreciate very much
@AK-io7hj
@AK-io7hj 6 жыл бұрын
This is an easier work around groups.google.com/forum/#!topic/mitappinventortest/V_ppvsQkWNU
@MrJayajah
@MrJayajah 5 жыл бұрын
@@AK-io7hj Is this possible to use the same spreadsheet?
@AK-io7hj
@AK-io7hj 5 жыл бұрын
@@MrJayajah yes, i think.
@chanmh85
@chanmh85 5 жыл бұрын
@@AK-io7hj Appreciate very much, Adrian. I would thought there would be an easier way to export the entire tinydb to googlesheet or excel or even as a CSV file. You method requires individual data to be selected and sent to google sheet.
@dietergasser5778
@dietergasser5778 2 жыл бұрын
great, thanks a lot
@tusharmore6650
@tusharmore6650 3 жыл бұрын
Thank you!!
@chuenteo2177
@chuenteo2177 4 жыл бұрын
Thanks for the tutorial.
@tomaskopecky105
@tomaskopecky105 6 жыл бұрын
Thanks for video. Could you make video how to add items from csv to google sheets?
@jeffersonsousa3644
@jeffersonsousa3644 5 жыл бұрын
Great lesson thank you very much!!
@369vkr
@369vkr 6 жыл бұрын
this is awesome. to make it more complete, will you please add a splash screen, login and registration pages.
@anupludra
@anupludra 4 жыл бұрын
For Registration you should use firebase and not google sheets. Also u can incorporate a OTP based log in to authenticate the phone from where the log in is being done.
@miniskulit5628
@miniskulit5628 5 жыл бұрын
allison you did the great job, i got something from your tutorial... I hope you can help me on some part... thank you so much
@ayeletsharara7275
@ayeletsharara7275 3 жыл бұрын
Hi Allison, First of all thank you for your explanation. Second, can you help me to understand how can i build with google sheet. More then 2 table. Thank you.
@mergenserapis9721
@mergenserapis9721 6 жыл бұрын
Hi Allison. Thanks for the very helpful video. Is there a way of having the same data on the googlesheet amended and updated thru the same app? Perhaps thru a different screen?
@sandor97
@sandor97 6 жыл бұрын
You saved me! Thank you soooo much
@enton9422
@enton9422 3 жыл бұрын
Love this one. Good Job.
@martoon1221
@martoon1221 4 жыл бұрын
Nice, nice, nice and clear. Thank you! :D
@mbguantay
@mbguantay 5 жыл бұрын
Thank you very much, it was spectacular
@tanvirali4
@tanvirali4 4 жыл бұрын
dear ,its giving me this error cannot parse text argument to "list for csv table "as a CSV formatted table
@startronics6826
@startronics6826 2 жыл бұрын
any updates on this problem?
@tso1000
@tso1000 6 жыл бұрын
Congratulations! very useful!
@ishanshah123
@ishanshah123 6 жыл бұрын
Thanks it was very helpul...Have a question- can we have a dynamic data reflecting in the app. For example if I update the google spreadsheet, can we have the same reflected in the app?
@1tsmichiko893
@1tsmichiko893 5 жыл бұрын
Thanks Allison! This really helped me 😆
@kristajd
@kristajd 5 жыл бұрын
don't lie
@AdreyThe
@AdreyThe 3 жыл бұрын
Youre the best
@GopalKumar-bi3ge
@GopalKumar-bi3ge 4 жыл бұрын
I am getting this error "cannot parde text argument to "list from csv table" as a csv formatted table" Can u pls give suggestions for it
@bitfieldtech2297
@bitfieldtech2297 4 жыл бұрын
Same issue... have you got it resolved?
@krish2519
@krish2519 4 жыл бұрын
@@bitfieldtech2297 I'm also getting issue... is it resolve ? please help me
@krish2519
@krish2519 4 жыл бұрын
I'm also getting issue... is it resolve ? please help me
@bitfieldtech2297
@bitfieldtech2297 4 жыл бұрын
@@krish2519 resolved
@krish2519
@krish2519 4 жыл бұрын
@@bitfieldtech2297 how to resolve, please help me
@haziqramadhan8543
@haziqramadhan8543 Жыл бұрын
How about if we have many tab in google sheet the list view doesn't appear
@yannfontaine1502
@yannfontaine1502 5 жыл бұрын
Very helpful, thank you
@metodovanidir
@metodovanidir 6 жыл бұрын
Thank you so much. It is a great help
@wirot125
@wirot125 6 жыл бұрын
Thank you very much.
@srinireddy8416
@srinireddy8416 6 жыл бұрын
it's awesome.Your voice is so sweet
@fixfalcon979
@fixfalcon979 4 жыл бұрын
Greetings Allison John, why everything you explain works well only on Screen1 ??? When I do everything you say on a new screen (screen2) you only see the first line in the Listview. What should I do??
@miguelopez1
@miguelopez1 5 жыл бұрын
gracias!! muy util su video!!!
@lahrecheadame4327
@lahrecheadame4327 6 жыл бұрын
thank you so match for this video it s very interest
@chandansubedi6327
@chandansubedi6327 4 жыл бұрын
I want to use this technique too read multiple choice question from sheet to my app.. anyone ...How do I do it please help...
@thiagoavila9592
@thiagoavila9592 5 жыл бұрын
Hi Allison John, yr videos helped me a lot on my App, I'm really thankful, I can integrate my app easy with google sheets, but I got a question I hope you can help me, it's working just fine with List view, but I want to add a textbox and a search button, and them show the result only... almost like you did, but w/o the listview, I don't want to used to see the entire list. I have tried a lot of ways but no success, can you help me?
@martonnemeth5343
@martonnemeth5343 4 жыл бұрын
17:00 you should use close screen instead of open.
@bitfieldtech2297
@bitfieldtech2297 4 жыл бұрын
Yes Otherwise app wont close .
@danielmiranda1912
@danielmiranda1912 3 жыл бұрын
The CSV table concatenates the two columns with ",". So that I get an error because I actually don't have a csv table. What may cause it?
@pulangngantor
@pulangngantor 6 жыл бұрын
How send/post from app inventor google script to google script. But selection self. Select range E1. How ?
@sbimanda7010
@sbimanda7010 4 жыл бұрын
Thanks you for this tutorial . I used this tutorial in my company for production planing. But can you tell me how can i sent update messages in that sheet like " ok , proceed , and done"?
@VictorHernandez-vq5hx
@VictorHernandez-vq5hx Жыл бұрын
Hola, solo quiero mostra la fila b, todos los datos, no la de nombre como lo haria gracias
@fixfalcon979
@fixfalcon979 4 жыл бұрын
Excelente tutorial. Se podria ver los datos en labels en lugar de ListView??
@armancodeq3642
@armancodeq3642 4 жыл бұрын
How can i delete a list...and the changes shall also reflect in excel sheet
@RenatoMadrid
@RenatoMadrid 6 жыл бұрын
Thanks this is a awesome video, quick question if I wrote new data in my google sheet the app didn't refresh I need to close and open again. How can I make to refresh the data live. So when I inset new data in google sheet will be appear automatic in the app is that posible? thanks
@mdazar790
@mdazar790 4 жыл бұрын
Thank You Sister..... Love u...
@kalanzans
@kalanzans 3 жыл бұрын
Thank you from Brazil! +1 Like +1 subscribed! :^)
@ZarifIkram
@ZarifIkram 5 жыл бұрын
Hi @alison, I followed your tutorial and it ended up really great! But what if I wanted to include that sheet with the app for suppose, offline usage? What would I have to do?
@roselystorres7332
@roselystorres7332 3 жыл бұрын
Hola allison, gracias desde Colombia, oye una pregunta, si quiero un botón que abra un enlace almacenado en google sheets y que este cambie la información de cada persona, ¿como lo hago?, me puedes ayudar porfa 🙏🏽
@satyakamalmahanta5632
@satyakamalmahanta5632 4 жыл бұрын
Thank you Allison.Can you teach us the search function from google spreadsheet?
@alexk9513
@alexk9513 Жыл бұрын
ListView1 > ShowFilterBar > V
@carlosmesquita3574
@carlosmesquita3574 4 жыл бұрын
Hi, this tutorial helped me a lot, but I have a big list, is it possible to filter by name? How can I do it?
@thevipercris
@thevipercris 6 жыл бұрын
Thank you for your video :)
@jeannettemillandvigio3579
@jeannettemillandvigio3579 6 жыл бұрын
Allison, Is there a way to also write or save records on Google Sheets using the same app. Should I just let read and write priviledges will be enough?
@prettyfuncomputing
@prettyfuncomputing 5 жыл бұрын
Great! Thanks!
@adminm.2717
@adminm.2717 5 жыл бұрын
Good video, it is posible to filter it? like for person or month?
@startronics6826
@startronics6826 2 жыл бұрын
Hi Allison, I am getting following problem: Runtime error Cannot parse text argument to "list from csv table" as a CSV-formatted table Note: You will not see another error reported for 5 seconds. Cannot parse text argument to "list from csv row" as CSV-formatted row Note: You will not see another error reported for 5 seconds.
@naderghaliany
@naderghaliany Жыл бұрын
i have that error to. do u know how fix it?
@thebrainc
@thebrainc 5 жыл бұрын
Alternative option to fusion tables that are turning off next year
@tobuyquailmeat
@tobuyquailmeat Жыл бұрын
Why you made google sheet settings as public - any one can see data. ? It affects the privacy of app-user-data know? Any one can steal user data know? am i right? help me.
@micronems6774
@micronems6774 5 жыл бұрын
i have been assigned with a project to read exel sheet i made the front end which can read column 1 but it doesnt reads the other columns
@Mrolafex
@Mrolafex 6 жыл бұрын
thanks. great video. Can the app be downloaded somewhere?
@avfmul4027
@avfmul4027 4 жыл бұрын
Hi Allison thanks for the video. is it possible for MIT App Inventor to Read Data from Google Calendar ?
@danielaalejandraadarmeardi7864
@danielaalejandraadarmeardi7864 3 жыл бұрын
Hey, I have a problem and I was wondering if you could help me, when I change the final part of the link to "export?format=csv" and then open it on another browser, it shows a message which says that the field can not be opened and to try again, what could it be?
@balachandermadhaiyan2431
@balachandermadhaiyan2431 5 жыл бұрын
How to read shhet2,sheet3.... data in listview can you make a video for it. I can read sheet1 data but when I try to get sheet2 data it shows sheet1 data only. How to convert CSV format sheet2, sheet3....
@ricardovega972
@ricardovega972 5 жыл бұрын
Thank you!
@meddsistemas6359
@meddsistemas6359 5 жыл бұрын
Hello Allison Jhon, what a good tutorial .. I write to you from Colombia, could you do one where I can upload files like, pdf, doc, img, etc. to Google Sheet with the MIT App Inventor?
@firerousgt7446
@firerousgt7446 5 жыл бұрын
spreadsheets only support text, after all its csv,comma separated values and those are not csv
@satdun02
@satdun02 6 жыл бұрын
love your video could you add to it that if user type in name of the person it return the information thanks
@farzeha6973
@farzeha6973 5 жыл бұрын
thanks for the video, continue. I have a question: how to save the * .csv file in my mobile
@bagasuta_33
@bagasuta_33 4 жыл бұрын
Can you share how to create send image to google sheet with app inventor or kodular?
@husainyou
@husainyou 5 жыл бұрын
It is very great service for learning Mr. Allison thank you very much this kind of service i hope my problems solve by you please please send me a video or guide to me retrieve data from google sheet or sql database please it is like a search record from database
@kevinsilva6512
@kevinsilva6512 6 жыл бұрын
How can I make a login screen with this method? Please, i need help.
@kennethfaulkner3160
@kennethfaulkner3160 5 жыл бұрын
Our school has a sheet that records all of our students accumulated points and I want to make an app that will allow them to search their number to see how many points they have available but the sheet has about 900 entries and it locks up the app when I attempt to access it as a table. Is there a better solution?
@razimuhammedpc7800
@razimuhammedpc7800 Жыл бұрын
thnx
@rohitjonnadula1753
@rohitjonnadula1753 5 жыл бұрын
Mam please make a video to make a live wallpaper app with Google sheets.
@veenadikupathak484
@veenadikupathak484 6 жыл бұрын
Can we Shorting Data ??? or can we make Query on it to Retrive Data like Today's Birthdate List, Month Birthdate List,etc
@imanulikhsan2970
@imanulikhsan2970 6 жыл бұрын
thanks very hopefull
@gopalr2358
@gopalr2358 6 жыл бұрын
hi, how to post the data's from app inventor to google sheets?
@sumudusandaruwan5831
@sumudusandaruwan5831 6 жыл бұрын
thanks, working
@thegautamverma
@thegautamverma 5 жыл бұрын
Your video helped me alot. Please tell how to get data from SHEET 2 ?
@firerousgt7446
@firerousgt7446 5 жыл бұрын
just simply go to sheet 2 and get the link from there
@efaraah
@efaraah 3 жыл бұрын
Hi guys, how come I dont see the call .get function?
@joelimbergamo639
@joelimbergamo639 6 жыл бұрын
Thanks it's super usefull!!!
@meassrmsc9013
@meassrmsc9013 5 жыл бұрын
thank u so much
Make Your Google Sheets Look PRO in Under 10 Minutes!
9:25
Next Generation Teacher
Рет қаралды 345 М.
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 53 МЛН
Whoa
01:00
Justin Flom
Рет қаралды 38 МЛН
The Joker kisses Harley Quinn underwater!#Harley Quinn #joker
00:49
Harley Quinn with the Joker
Рет қаралды 16 МЛН
Кадр сыртындағы қызықтар | Келінжан
00:16
Introduction to Dash Plotly - Data Visualization in Python
29:21
Charming Data
Рет қаралды 784 М.
Google Forms - Drop Down List from Spreadsheet Using Apps Script
34:39
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 441 М.
How to Publish Your MIT App Inventor App to Google Play
25:11
Coding Mind
Рет қаралды 93 М.
My Workflow for Building any Streamlit Dashboard Project
9:40
Fanilo Andrianasolo
Рет қаралды 82 М.
App Inventor: Toggle Menu
7:59
Pixii Bomb
Рет қаралды 84 М.
I've been using Redis wrong this whole time...
20:53
Dreams of Code
Рет қаралды 354 М.
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 53 МЛН