How to Read Data from Google Sheets in MIT App Inventor

Поделиться
HTML-код
  • Опубликовано: 24 ноя 2024

Комментарии • 185

  • @ItaloBarbiero
    @ItaloBarbiero 4 года назад +1

    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 года назад +3

    This video was incredibly helpful and you explained the process very well, including why you were taking certain steps. Many thanks!

  • @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

  • @guzmadera
    @guzmadera Год назад +1

    Muchas gracias y enhorabuena por el tutorial, llevo meses buscando esto, y hay que ver lo sencillo que lo haces y el resultado extraordinario🥰

  • @niceman567
    @niceman567 3 года назад

    Thanks Allison! hope there will be videos in relation to delete/update google sheet records.

  • @neelmalwatkar6095
    @neelmalwatkar6095 4 года назад

    Amazing video, would love to see more videos on MIT app Inventor. Helpful tutorial!

  • @lucianacontreras2966
    @lucianacontreras2966 5 лет назад +1

    You Saved My Lije...... Thank you so much...... You deserve the world :)

  • @arnavpro4001
    @arnavpro4001 4 года назад +1

    Very nice app. Worked superbly for me.

  • @AmalRoy1987
    @AmalRoy1987 2 месяца назад

    What a wonderful person you are.❤❤

  • @RizzProductions786
    @RizzProductions786 4 года назад +1

    it was really helpful for me. I was actually searching for these things. Thank you So much.

  • @youssefmossoba1823
    @youssefmossoba1823 6 лет назад

    Excellent tutorial, I wish you can do more of that. Keep on the good work!

  • @vanthenkim2730
    @vanthenkim2730 4 года назад

    Thank you! Wonder you can make another video reading from google sheet but a specific sheet.

  • @sandipspsolapur
    @sandipspsolapur 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.

  • @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.

  • @thebrainc
    @thebrainc 6 лет назад

    Great! Simple, complete and effective. Very good code. Thanks

  • @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?

  • @chanmh85
    @chanmh85 6 лет назад +2

    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 лет назад +1

      This is an easier work around groups.google.com/forum/#!topic/mitappinventortest/V_ppvsQkWNU

    • @MrJayajah
      @MrJayajah 6 лет назад

      @@AK-io7hj Is this possible to use the same spreadsheet?

    • @AK-io7hj
      @AK-io7hj 6 лет назад

      @@MrJayajah yes, i think.

    • @chanmh85
      @chanmh85 6 лет назад

      @@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.

  • @fixfalcon979
    @fixfalcon979 4 года назад

    Excelente tutorial. Se podria ver los datos en labels en lugar de ListView??

  • @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.

  • @jmunozve
    @jmunozve Год назад

    Thaks Allison... you explain very well. i made all... and great... I love you !!!!!

  • @projectdimpreza
    @projectdimpreza 5 лет назад +1

    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..

  • @gabrielfaveromiranda1503
    @gabrielfaveromiranda1503 4 года назад +1

    Thank you so much, this video really help me.

  • @tomaskopecky105
    @tomaskopecky105 6 лет назад

    Thanks for video. Could you make video how to add items from csv to google sheets?

  • @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.

  • @vincentxing8962
    @vincentxing8962 7 лет назад

    Thanks for a clear illustration!

  • @amiyaranjan2900
    @amiyaranjan2900 5 лет назад

    You are suberb Allison...it was very helpful. Please resume making more videos. Regards

  • @sbimanda7010
    @sbimanda7010 5 лет назад

    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"?

  • @adminm.2717
    @adminm.2717 6 лет назад

    Good video, it is posible to filter it? like for person or month?

  • @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?

  • @marconcio
    @marconcio Год назад

    Thanks a lot. Very clear.

  • @Mrolafex
    @Mrolafex 6 лет назад

    thanks. great video. Can the app be downloaded somewhere?

  • @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

  • @avfmul4027
    @avfmul4027 4 года назад

    Hi Allison
    thanks for the video.
    is it possible for MIT App Inventor to Read Data from Google Calendar ?

  • @satyakamalmahanta5632
    @satyakamalmahanta5632 4 года назад

    Thank you Allison.Can you teach us the search function from google spreadsheet?

    • @alexk9513
      @alexk9513 Год назад +1

      ListView1 > ShowFilterBar > V

  • @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??

  • @redshop1234
    @redshop1234 6 лет назад

    Thanks Allison. Great video!

  • @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 🙏🏽

  • @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

  • @enton9422
    @enton9422 4 года назад

    Love this one. Good Job.

  • @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?

  • @bagasuta_33
    @bagasuta_33 4 года назад

    Can you share how to create send image to google sheet with app inventor or kodular?

  • @haziqramadhan8543
    @haziqramadhan8543 2 года назад

    How about if we have many tab in google sheet the list view doesn't appear

  • @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?

  • @martoon1221
    @martoon1221 4 года назад

    Nice, nice, nice and clear. Thank you! :D

  • @1tsmichiko893
    @1tsmichiko893 5 лет назад

    Thanks Allison! This really helped me 😆

  • @pulangngantor
    @pulangngantor 6 лет назад

    How send/post from app inventor google script to google script. But selection self. Select range E1. How ?

  • @tso1000
    @tso1000 6 лет назад

    Congratulations! very useful!

  • @chuenteo2177
    @chuenteo2177 4 года назад

    Thanks for the tutorial.

  • @sandor97
    @sandor97 6 лет назад

    You saved me! Thank you soooo much

  • @ZarifIkram
    @ZarifIkram 6 лет назад

    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?

  • @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....

  • @chandansubedi6327
    @chandansubedi6327 4 года назад +2

    I want to use this technique too read multiple choice question from sheet to my app.. anyone ...How do I do it please help...

  • @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?

  • @tanvirali4
    @tanvirali4 4 года назад +1

    dear ,its giving me this error cannot parse text argument to "list for csv table "as a CSV formatted table

  • @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?

  • @farzeha6973
    @farzeha6973 6 лет назад

    thanks for the video, continue.
    I have a question: how to save the * .csv file in my mobile

  • @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

  • @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?

  • @srinireddy8416
    @srinireddy8416 6 лет назад

    it's awesome.Your voice is so sweet

  • @wasitadjseeta2513
    @wasitadjseeta2513 5 лет назад

    Thank you very much, will try to make it

  • @CK-qp5sg
    @CK-qp5sg 6 лет назад

    Thanks, can we have a JPG or PDF of all the blocks for download ?

  • @santramedia
    @santramedia 4 года назад

    tks for your help. Your video is very good. tks all

  • @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?

  • @armancodeq3642
    @armancodeq3642 4 года назад

    How can i delete a list...and the changes shall also reflect in excel sheet

  • @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

  • @martonnemeth5343
    @martonnemeth5343 5 лет назад +1

    17:00 you should use close screen instead of open.

  • @jeffersonsousa3644
    @jeffersonsousa3644 5 лет назад

    Great lesson thank you very much!!

  • @rohitjonnadula1753
    @rohitjonnadula1753 5 лет назад

    Mam please make a video to make a live wallpaper app with Google sheets.

  • @GopalKumar-bi3ge
    @GopalKumar-bi3ge 4 года назад +2

    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 года назад +1

      @@bitfieldtech2297 I'm also getting issue... is it resolve ? please help me

    • @krish2519
      @krish2519 4 года назад +1

      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

  • @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

  • @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?

  • @kevinsilva6512
    @kevinsilva6512 6 лет назад

    How can I make a login screen with this method? Please, i need help.

  • @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

  • @thebrainc
    @thebrainc 6 лет назад

    Alternative option to fusion tables that are turning off next year

  • @mbguantay
    @mbguantay 5 лет назад

    Thank you very much, it was spectacular

  • @AdreyThe
    @AdreyThe 3 года назад

    Youre the best

  • @kalanzans
    @kalanzans 4 года назад

    Thank you from Brazil! +1 Like +1 subscribed! :^)

  • @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

  • @KerryPalacios
    @KerryPalacios 6 лет назад

    This is great!!
    I really want to accomplish this on the same page, but I'm having issues. Do you think my idea is possible on ai2?

    • @allisonjohn6011
      @allisonjohn6011  6 лет назад

      Thank you!
      I'm not exactly sure what you mean by "on the same page," but if you just want all the info to be in the list view rather than having to click the name first, you could definitely just join another
      followed by the other info to the string in the format procedure.

    • @KerryPalacios
      @KerryPalacios 6 лет назад +1

      Actually, I somehow figured it out!
      What I meant was to put a horizontal arrangement under the scrolling list and have the respective slots populate using the selection index after I select a list item. I have it where I can see the first column of data on the list, and 5 other columns populate with the rest of the row after I make a selection.
      Your video was a massive help!

  • @metodovanidir
    @metodovanidir 6 лет назад

    Thank you so much. It is a great help

  • @yannfontaine1502
    @yannfontaine1502 5 лет назад

    Very helpful, thank you

  • @VictorHernandez-vq5hx
    @VictorHernandez-vq5hx Год назад

    Hola, solo quiero mostra la fila b, todos los datos, no la de nombre como lo haria gracias

  • @fixfalcon979
    @fixfalcon979 6 лет назад

    Dear Allison, thank you for the explanation in your video, I have done it and it was the same as the one you show. Now I would like to have on the spreadsheet a list of 30 ID data and Names these appear on the cell phone according to the ID that is written in a text box and the name is displayed on a label.
    Instead of Listview
    How can I do this ???

    • @maglit777
      @maglit777 5 лет назад

      Have you managed to find a solution to this?

  • @efaraah
    @efaraah 3 года назад

    Hi guys, how come I dont see the call .get function?

  • @gopalr2358
    @gopalr2358 6 лет назад

    hi, how to post the data's from app inventor to google sheets?

  • @yiuan8085
    @yiuan8085 2 года назад

    very clear....

  • @josealexandrereis
    @josealexandrereis 6 лет назад

    Hi
    Thanks for tour video
    Think you can expand a little and explain how to make a search of a Google Sheet? Imagine that I want to search for someone on that list and get the information. Thanks

    • @allisonjohn6011
      @allisonjohn6011  6 лет назад +1

      Hi José,
      You can use any search/sort algorithm on the list of names and information, or you could add each of the lists with name and information into tinyDB with the name as the tag and the information as valueToStore. This way, the internal dictionary structure of tinyDB can do the search automatically. If you were thinking about just importing a single line of the Google Sheet, I'm not sure I can help you with that yet. However, I am thinking about making another video with more advanced Google-App Inventor techniques. Hope this helps!

    • @sandipspsolapur
      @sandipspsolapur 5 лет назад

      Make the option filter bar checked on listview option , it will put the things searchable

  • @abedjabaly7786
    @abedjabaly7786 4 года назад

    hi i did exactly do as the video and when the app work its give me messege like this:"Bad arguments to list to CSV row.. the opretion list to csv row cannot accept the arguments:,[..]"

    • @bonzo909
      @bonzo909 4 года назад

      I have the sam problem. I notice that data in csv file is not a table but solid text seperate only by comma

  • @sumudusandaruwan5831
    @sumudusandaruwan5831 5 лет назад

    help me, i need google sheet text colour in mit app list view text colour????

  • @thevipercris
    @thevipercris 6 лет назад

    Thank you for your video :)

  • @prettyfuncomputing
    @prettyfuncomputing 5 лет назад

    Great! Thanks!

  • @GB-vo6ly
    @GB-vo6ly 4 года назад

    Hello,
    How can i read a data in index1 / 3.row

  • @lahrecheadame4327
    @lahrecheadame4327 6 лет назад

    thank you so match for this video it s very interest

  • @wirot125
    @wirot125 6 лет назад

    Thank you very much.

  • @jeannettemilland9792
    @jeannettemilland9792 6 лет назад

    Thanks!!! I know is about another topic, but do you know how to connect Google Sheets with html?

    • @allisonjohn6011
      @allisonjohn6011  6 лет назад

      Unfortunately, no. Good luck in figuring it out though!

  • @miguelopez1
    @miguelopez1 5 лет назад

    gracias!! muy util su video!!!

  • @mdazar790
    @mdazar790 4 года назад

    Thank You Sister..... Love u...

  • @husainyou
    @husainyou 6 лет назад

    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

  • @paragmathur6016
    @paragmathur6016 4 года назад +1

    Hey pls tell how should I use this to make a login signup system pls tell
    And make a video on this plsssssss
    Need this

    • @anupludra
      @anupludra 4 года назад +1

      For a log in system, user firebase and not Google Sheets. You can include a OTP based authentication app to authenticate the mobile phone frm which the log in procedure is being carried out.

    • @paragmathur6016
      @paragmathur6016 4 года назад

      @@anupludra thanks