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.
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..
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 🙏🏽
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??
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?
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?
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....
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
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:,[..]"
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.
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"?
Hi ... Do you know how I can separate the two lists ? For example, I want to use the name in one list and the birthday on another list. Could you help me ?
Hello, I have also made a copy of your app, but still receive an error when I tick one of the entries to move on to Screen5 for full table resut: Runtime Error The operation select list item cannot accept the arguments: , [((70563 Stuttgart Vaihingen Katzenbachstr. 27) (70597 Stuttgart Johannes- Krämer- Str. 2- 4) (70469 Stuttgart Stuttgarter Str. 15))], [70597 Stuttgart Johannes- Krämer- Str. 2- 4] You see I get the ticked one of 3 items at the end as repeating item and no change to the new screen. Thank you in advance for any helpfull hint.!
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.
@@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.
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?
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
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 ???
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.
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?
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.
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?
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?
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.
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?
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?
Just use your Google account to create a new Google Sheet and either type in your data manually or copy and paste from another source. I copied and pasted from a Google Sheet I had already made to make sure the video wasn't too long. There's nothing you have to do that's different from how you would normally add data, but if you've never used Google Sheets before, try this video: ua-cam.com/video/QTgvX5MLPC8/v-deo.html
It returns a message when I try to launch: "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."
Are you referring to the string formatting step at 9:25 when I added the ? The makes a "new line" which puts the birth date under name, but if you want the birth date to be next to the name, replace with a space.
This video was incredibly helpful and you explained the process very well, including why you were taking certain steps. Many thanks!
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.
Thanks Allison, with you explanation a bright light shine my brain and finnaly I finish my proyect, you are the best.
Muchas gracias y enhorabuena por el tutorial, llevo meses buscando esto, y hay que ver lo sencillo que lo haces y el resultado extraordinario🥰
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..
How send/post from app inventor google script to google script. But selection self. Select range E1. How ?
You Saved My Lije...... Thank you so much...... You deserve the world :)
How about if we have many tab in google sheet the list view doesn't appear
How can i delete a list...and the changes shall also reflect in excel sheet
Thanks Allison! hope there will be videos in relation to delete/update google sheet records.
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
Same issue... have you got it resolved?
@@bitfieldtech2297 I'm also getting issue... is it resolve ? please help me
I'm also getting issue... is it resolve ? please help me
@@krish2519 resolved
@@bitfieldtech2297 how to resolve, please help me
Amazing video, would love to see more videos on MIT app Inventor. Helpful tutorial!
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 🙏🏽
it was really helpful for me. I was actually searching for these things. Thank you So much.
dear ,its giving me this error cannot parse text argument to "list for csv table "as a CSV formatted table
any updates on this problem?
Very nice app. Worked superbly for me.
What a wonderful person you are.❤❤
Excellent tutorial, I wish you can do more of that. Keep on the good work!
Hola, solo quiero mostra la fila b, todos los datos, no la de nombre como lo haria gracias
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?
Thank you! Wonder you can make another video reading from google sheet but a specific sheet.
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??
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?
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?
Can you share how to create send image to google sheet with app inventor or kodular?
help me, i need google sheet text colour in mit app list view text colour????
How can I make a login screen with this method? Please, i need help.
Hi guys, how come I dont see the call .get function?
THANK YOU SO MUCH. YOU JUST SAVE MY COLLEGE DEGREE
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
hi, how to post the data's from app inventor to google sheets?
I want to use this technique too read multiple choice question from sheet to my app.. anyone ...How do I do it please help...
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....
Hello,
How can i read a data in index1 / 3.row
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
Can you tell me how you did for add search option and get the result?
search for loops in list
@@firerousgt7446 How i do that? im kinda newbie on it.
Hi Allison
thanks for the video.
is it possible for MIT App Inventor to Read Data from Google Calendar ?
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:,[..]"
I have the sam problem. I notice that data in csv file is not a table but solid text seperate only by comma
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.
i have that error to. do u know how fix it?
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"?
Hi ... Do you know how I can separate the two lists ? For example, I want to use the name in one list and the birthday on another list. Could you help me ?
you just simply remove index no.2 on the name list and remove index no.1 on the birthday list
Hello, I have also made a copy of your app, but still receive an error when I tick one of the entries to move on to Screen5 for full table resut:
Runtime Error
The operation select list item cannot accept the arguments: , [((70563 Stuttgart Vaihingen Katzenbachstr. 27) (70597 Stuttgart Johannes- Krämer- Str. 2- 4) (70469 Stuttgart Stuttgarter Str. 15))], [70597 Stuttgart Johannes- Krämer- Str. 2- 4]
You see I get the ticked one of 3 items at the end as repeating item and no change to the new screen.
Thank you in advance for any helpfull hint.!
Same Problem! anyone knows how to solve?
@@wingkuan8063 Hello, may be you find your answer here:
groups.google.com/forum/?#!forum/mitappinventortest
groups.google.com/forum/?#!topic/mitappinventortest/XbS9w45s9FA Thanks for the solution!
Excelente tutorial. Se podria ver los datos en labels en lugar de ListView??
Thanks, can we have a JPG or PDF of all the blocks for download ?
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.
Thank you and appreciate very much
This is an easier work around groups.google.com/forum/#!topic/mitappinventortest/V_ppvsQkWNU
@@AK-io7hj Is this possible to use the same spreadsheet?
@@MrJayajah yes, i think.
@@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.
Great! Simple, complete and effective. Very good code. Thanks
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?
Can we Shorting Data ??? or can we make Query on it to Retrive Data like Today's Birthdate List, Month Birthdate List,etc
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
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?
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 ???
Have you managed to find a solution to this?
Can this data see online
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.
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?
this is awesome. to make it more complete, will you please add a splash screen, login and registration pages.
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.
Thank you for the video! I'm using fusion tables to do something similar, it helped a lot!
community.kodular.io/t/custom-downloader-extension-for-kodular-free/16487 check this thread out.
Thank you so much, this video really help me.
Good video, it is posible to filter it? like for person or month?
Thanks for a clear illustration!
Thaks Allison... you explain very well. i made all... and great... I love you !!!!!
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?
Thanks for video. Could you make video how to add items from csv to google sheets?
It is showing error that the operation list to csv table cannot accept the arguments. Please help me anyone from this.
updates? same problem
Can we access only one column using this technique.
No, we can in fact access as many as you want
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?
thanks. great video. Can the app be downloaded somewhere?
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
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.
@@anupludra thanks
Thanks
But mine is showing" cannot parsed text argument to list from CSV row as CSV formatted row
I have the same ? Did you fix that ?
you need to choose 'list from csv table text" not "list from csv row text"
any updates on this problem?
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?
yes
@@firerousgt7446 please tell me how
Thank you Allison.Can you teach us the search function from google spreadsheet?
ListView1 > ShowFilterBar > V
17:00 you should use close screen instead of open.
Yes
Otherwise app wont close .
You saved me! Thank you soooo much
Thanks Allison. Great video!
Can you give me the aia file pls of this project???
Love this one. Good Job.
You are suberb Allison...it was very helpful. Please resume making more videos. Regards
Thanks a lot. Very clear.
Congratulations! very useful!
very clear....
Nice, nice, nice and clear. Thank you! :D
Hi,
Can you share aia file please?
Thanks for the tutorial.
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?
spreadsheets only support text, after all its csv,comma separated values and those are not csv
Thanks Allison! This really helped me 😆
don't lie
Thanks. How do you add data?
Just use your Google account to create a new Google Sheet and either type in your data manually or copy and paste from another source. I copied and pasted from a Google Sheet I had already made to make sure the video wasn't too long. There's nothing you have to do that's different from how you would normally add data, but if you've never used Google Sheets before, try this video: ua-cam.com/video/QTgvX5MLPC8/v-deo.html
it's awesome.Your voice is so sweet
Thank you very much, will try to make it
Thanks!!! I know is about another topic, but do you know how to connect Google Sheets with html?
Unfortunately, no. Good luck in figuring it out though!
It returns a message when I try to launch: "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."
Copy original Google sheet content to another new Google sheet. Replace URL with new Google sheet link in MIT App. It should work next.
I Tried but it is displaying the same.Can you please tell me how to overcome this?
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
Thank you very much, it was spectacular
thanks for the video, continue.
I have a question: how to save the * .csv file in my mobile
love your video could you add to it that if user type in name of the person it return the information thanks
Great lesson thank you very much!!
Your video helped me alot.
Please tell how to get data from SHEET 2 ?
just simply go to sheet 2 and get the link from there
Dear Alison, do you have similar for IOS.
appinventor2 sadly isnt for ios
Mam please make a video to make a live wallpaper app with Google sheets.
Madame Madam, who has kept a berth date under Name, I have not kept him in the side of Name, please teach me please
Are you referring to the string formatting step at 9:25 when I added the
? The
makes a "new line" which puts the birth date under name, but if you want the birth date to be next to the name, replace
with a space.
Thank you so much. It is a great help
tks for your help. Your video is very good. tks all
Very helpful, thank you