New Update from Google: After making your form with its questions, click on the Publish button on the top and choose manage option from the dialog that opens up. The share permissions dialog will open up where you have to change General access to "Anyone with link". Click on the Done button. After this, click on the publish button on the dialog. Written Tutorial: obsidiansofteducation.com/index.php/send-data-to-google-sheet-from-mit-app-inventor/
When are you getting the error? When you read or when you send data? In both cases, look at the url. Also, use separate Web components for reading and sending. For reading, you give url in designer view, but for sending, you construct the url using text blocks and the syntax has to be correct. Make sure that you are constructing the url properly as explained in tutorial.
For that, we need to go through a web app. I am working on a CRUD tutorial for the Google sheet for adding, updating, and deleting rows from the Google sheet . Hopefully, the tutorial will be published on Tuesday.
Thanks for making this video! I have one question. Is it possible to save some data files (e.g. CSV) in the phone and then share it with others by other means such as email or google drive? Thanks! :)
Most welcome :) I believe this tutorial series might help you. There are two parts. I am teaching in themm how to upload photos, sound files and text files to Google Drive. This is part 1: ua-cam.com/video/U-tlpOdMGUs/v-deo.html
Hi this tutorial os working fine. Thanks for this. I have one doubt. I have made an app where user enters scores for several attributes during a fashion show. Following the tutorial the values are being added to the spreadsheet. But if i delete all entries in the apreadsheet and start again, the entries are then starting from the row where it was left writing last time. How can this be fixed.
Unfortunately, it cannot be fixed. This is how Google Form submission works. Giving you the official explanation from Google here: "By design, Google Form submission does not overwrite any rows. At all times the new rows are inserted." The easiest way of writing to Google sheets from MIT App inventor is by using the method explained in this video i.e. by using Google form submission. However, it has limitations which you have discovered. If you want more control, try exploring web apps. This tutorial is helpful: ai2.metricrat.co.uk/guides/post-data-to-a-google-sheet I will try to make a video tutorial soon.
Thank you for your reply. Also can you please tell how I can make a total score option wherein all the scores entered by the user are added up and total is stored. Is it possible to make a tabular form wherein scores for each contestant can be entered parallel to his name and total score can be made available at the end
I am assuming that you have a list of scores. Just use the for each item block from control and use the plus block from math and keep on adding each item to your score variable. Don't forget to initialize the score as 0.
Your front end of the app in mit app inventor can have any way of providing data such as checkboxes and dropdown menus as long as you are sending data to the google sheet similar to this: docs.google.com/forms/d/e/1FAGycfw/viewform?usp=pp_url&entry.1932012884=obsidian&entry.1402638227=100 Here obsidian and 100 are the data being sent to the google sheet.
Please check that you are looking at the correct sheet named form responses 1. You can also verify your code by looking at the written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Mam, in this app I was download my mobile or some one. now app owner changed Google sheets name or age that impact they already downloaded app reflected or not.
You are only sending data to Google sheet in this tutorial and not reading it. If someone changes data that you sent to Google sheet , you will only learn about it if you are also reading data from sheet. and yes, if you use my other tutorial to read data from sheet, you will be able to see any changes in data too if sheet is manually changed by someone.
can i sent data from different screens to the same google sheet? I tried to do it this way but it only works if I sumbit data from one screen. Thanks in advance!
Theoretically it should work but remember that you will be putting entries in the same google form. So, if the google form has name and age questions, the corresponding google sheet will have name and age columns and you can only add rows to this data. If you have more than one screen writing to the same sheet, it will also be adding to the same sheet with name and age.
Thank so much for this video. This is My first application 🙂. But I have problem, when I send data in google sheet in that row I lost same formula in next columns. How I can send data just in one column, example "B" , don't to cleared C,D.. in that row?
The method I have shown in this video is the easiest way of writing to Google Sheets using Google Forms. So, it has limitations. You can't write to a specific cell using this way. You will have to write JavaScript for your purpose. I will try to make a tutorial but it will take time as I have other topics planned for the following months.
Please make sure that you have written the form response in app inventor project as shown in the video. For more help, you can have a look at the written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
I didn't share the aia file as it would have pointed to my Google sheet. Best wishes with your project. This method definitely works as I used it recently for another project that I was working on.
Please set up the url the same way as i have shown in the video otherwise the submit button will not work. You can also compare your code with my written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Make sure that you have copied the link correctly and that you have given the rights of editing to anyone. This process has been explained in the tutorial.
Yes, it does. Just made a project with a new Google sheet and the data is being added successfully to the sheet. Make sure that you are connected to the internet and that you are looking for the data in the correct sheet. The data is added to a sheet called "form responses 1" inside your main spreadsheet. You can also have a look at the written tutorial to compare your code. obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Hi, thanks for the video. Just have 1 question to ask, how to reset(delete) all data so that the new data will be at on top back? Because i just try to manual delete at line 100, but the new data still appear at the 101 line. If possible i want the new data back to line number 1.
right click and delete the rows instead of removing the data. I have observed this that clearing the data sometimes works and sometimes doesn't. The best way to make sure is to delete the rows from the spreadsheet.
![Send Data To Google Sheet From MIT App Inventor [Google Sheet Database] || EASIEST METHOD 2025!](/img/n.gif)
New Update from Google: After making your form with its questions, click on the Publish button on the top and choose manage option from the dialog that opens up. The share permissions dialog will open up where you have to change General access to "Anyone with link". Click on the Done button. After this, click on the publish button on the dialog.
Written Tutorial: obsidiansofteducation.com/index.php/send-data-to-google-sheet-from-mit-app-inventor/
Wow that's awesome. Really easy way to connect the Google sheets with MIT app inventor
syntax error quote in unquoted cell, cannot parse text argument to list from csv table as formattable table error in my application please help
i am trying both send data and read data on same screen
When are you getting the error? When you read or when you send data? In both cases, look at the url. Also, use separate Web components for reading and sending. For reading, you give url in designer view, but for sending, you construct the url using text blocks and the syntax has to be correct. Make sure that you are constructing the url properly as explained in tutorial.
Thanks for sharing easiest way to work on Google sheets & link that to MIT App converter. Simple to apply
Most welcome 😊
Thank you for sharing this easy way of working
I love watching your videos with full of authentic knowledge. It is always a learning process for me..
Wonderful
Thanks for sharing informative video in very easy manner..keep sharing more
So nice of you
wow, amazing job, really it's so much easy
Thanks a lot, it works great with dropdown answers too! Top Lady! 💐
Most welcome :)
You're doing an amazing job, thanks for this video 👍
Great outstanding work keep it up thanks for sharing this video
Omg it's so easy. Thanks for introducing this to me.
Thanks for sharing the easiest way
Very useful to me. Thankyou.
Glad it was helpful!
@@ObsidianSoftEducation It worked for me.
good to hear! Best wishes!
So so informative to watch 🙂 you always bring informative videos which i love watching because they are a learning process for me.🙃
Outstanding work u make everything so easy to understand ❤
Thank you so much 😀
👍🙆 you Always explain in a very easy way ❤
Thank you so much your video was so helpful ❤
You're welcome! I'm glad it was helpful!
Good work This looks quite easy
Thank you 😊
thank you very much sir...I try to add the block with web viewer component to show the google doc response, and its work :-)
Glad it helped
You're doing an amazing job
Really it's so easy😮
Thanks for tutorial...Question...you went through the Form.. can we input the data directly into the cells ?
For that, we need to go through a web app. I am working on a CRUD tutorial for the Google sheet for adding, updating, and deleting rows from the Google sheet . Hopefully, the tutorial will be published on Tuesday.
Thanks for making this video! I have one question. Is it possible to save some data files (e.g. CSV) in the phone and then share it with others by other means such as email or google drive? Thanks! :)
Most welcome :)
I believe this tutorial series might help you. There are two parts. I am teaching in themm how to upload photos, sound files and text files to Google Drive. This is part 1: ua-cam.com/video/U-tlpOdMGUs/v-deo.html
Hi this tutorial os working fine. Thanks for this. I have one doubt. I have made an app where user enters scores for several attributes during a fashion show. Following the tutorial the values are being added to the spreadsheet. But if i delete all entries in the apreadsheet and start again, the entries are then starting from the row where it was left writing last time. How can this be fixed.
Unfortunately, it cannot be fixed. This is how Google Form submission works. Giving you the official explanation from Google here:
"By design, Google Form submission does not overwrite any rows. At all times the new rows are inserted."
The easiest way of writing to Google sheets from MIT App inventor is by using the method explained in this video i.e. by using Google form submission. However, it has limitations which you have discovered. If you want more control, try exploring web apps. This tutorial is helpful: ai2.metricrat.co.uk/guides/post-data-to-a-google-sheet
I will try to make a video tutorial soon.
Thank you for your reply. Also can you please tell how I can make a total score option wherein all the scores entered by the user are added up and total is stored.
Is it possible to make a tabular form wherein scores for each contestant can be entered parallel to his name and total score can be made available at the end
I am assuming that you have a list of scores. Just use the for each item block from control and use the plus block from math and keep on adding each item to your score variable. Don't forget to initialize the score as 0.
Can this method still be used with checkboxes and dropdown menus? thank you
Your front end of the app in mit app inventor can have any way of providing data such as checkboxes and dropdown menus as long as you are sending data to the google sheet similar to this: docs.google.com/forms/d/e/1FAGycfw/viewform?usp=pp_url&entry.1932012884=obsidian&entry.1402638227=100 Here obsidian and 100 are the data being sent to the google sheet.
Thanks for sharing this tutorial 👍
Thank you for sharing this amazing video
My pleasure
I tried two times the example, following exactly the instructionw, but at the end i did not arrived to write in the google sheet.
Please check that you are looking at the correct sheet named form responses 1. You can also verify your code by looking at the written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Once download the app we need some changes are there that data Will come on download app it is possible
I am sorry but I wasn't able to understand your question. Are you talking about aia project file or apk file?
Mam, in this app I was download my mobile or some one. now app owner changed Google sheets name or age that impact they already downloaded app reflected or not.
You are only sending data to Google sheet in this tutorial and not reading it. If someone changes data that you sent to Google sheet , you will only learn about it if you are also reading data from sheet. and yes, if you use my other tutorial to read data from sheet, you will be able to see any changes in data too if sheet is manually changed by someone.
Okay I have understood thanks for your support.
Most welcome 😊
Hai, Can we upload the picture taken by camera like this?
Did it work out for you using email as discussed on Instagram?
@@ObsidianSoftEducation It's not practical to write email id always. However I have completed project by uploading Google drive as you advised
@muhammadev3424 good to hear this 😊
That’s an awesome sharing
Thanks for watching
Can you explain why we need to change the "&" to "?" only for the first line?
That is the starting of the terms. So, we separate from the rest of url using ?.
How come when i click submit that's nothing happen?
Verify that you are looking at the correct sheet,
Now Google brought some changes. We have to click publish button and change settings to 'Any One with Link'.@@ObsidianSoftEducation
How to create update and delete Google sheet in this method ,?
You will have to use Web app and scripting for such kind of editing.
@@ObsidianSoftEducation ok thanks
Can we do it for MS forms ?
I haven't tried it.
Where cn i find text software?
Go to the User interface palette on the left and choose TextBox.
can i sent data from different screens to the same google sheet? I tried to do it this way but it only works if I sumbit data from one screen. Thanks in advance!
Theoretically it should work but remember that you will be putting entries in the same google form. So, if the google form has name and age questions, the corresponding google sheet will have name and age columns and you can only add rows to this data. If you have more than one screen writing to the same sheet, it will also be adding to the same sheet with name and age.
Where to find that textEdit?
Go to the User interface palette on the left and choose TextBox.
In web url section, there is no link??
You mean in the browser? Click on the 3 dots next to send button on your Google form and choose prefilled link.
can send the data also to a ROW inplace of a collum
It already adds data to rows, but yes, you can't send data to a specific row or column with this method.
thx @@ObsidianSoftEducation
@@tenij000 most welcome
Thank you so much.
You're welcome!
Thankyou so much mam❤❤
Most welcome 😊
press submit button the how to clear automatic
After pressing submit button, set both text boxes to empty Text blocks.
Thank so much for this video. This is My first application 🙂. But I have problem, when I send data in google sheet in that row I lost same formula in next columns. How I can send data just in one column, example "B" , don't to cleared C,D.. in that row?
The method I have shown in this video is the easiest way of writing to Google Sheets using Google Forms. So, it has limitations. You can't write to a specific cell using this way. You will have to write JavaScript for your purpose. I will try to make a tutorial but it will take time as I have other topics planned for the following months.
Thank you so much for the reply. If you can make tutorial that would be great. For now I found a solution with arrayformula in another sheet.
Glad to hear that you found a solution :)
When I click on Submit it does nothing
Please make sure that you have written the form response in app inventor project as shown in the video. For more help, you can have a look at the written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
I have checked everything, unfortunately it does nothing
I hope you are looking at the right sheet. It is not the first sheet, but the second one labelled something like form responses.
I'm going to go over it again, making it from scratch. The AIA file isn't there for me to dig into, so I'm going to start over
I didn't share the aia file as it would have pointed to my Google sheet. Best wishes with your project. This method definitely works as I used it recently for another project that I was working on.
Much easier to create & send through this advancement.
Thanks
Most welcome 😊
Submit botton is not working
Please set up the url the same way as i have shown in the video otherwise the submit button will not work. You can also compare your code with my written tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Dont work for me 😢
Make sure that you have copied the link correctly and that you have given the rights of editing to anyone. This process has been explained in the tutorial.
Ok i will ckeck all the process@@ObsidianSoftEducation
It's OK now, i forget to change & by ? sorry . Good tutorials, thank you.
Good to know this 😊…all is well that ends well 😊
This does not work! You may want to update. Thanks
Yes, it does. Just made a project with a new Google sheet and the data is being added successfully to the sheet. Make sure that you are connected to the internet and that you are looking for the data in the correct sheet. The data is added to a sheet called "form responses 1" inside your main spreadsheet.
You can also have a look at the written tutorial to compare your code.
obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html
Hi, thanks for the video. Just have 1 question to ask, how to reset(delete) all data so that the new data will be at on top back? Because i just try to manual delete at line 100, but the new data still appear at the 101 line. If possible i want the new data back to line number 1.
right click and delete the rows instead of removing the data. I have observed this that clearing the data sometimes works and sometimes doesn't. The best way to make sure is to delete the rows from the spreadsheet.
@ObsidianSoftEducation it works. Thank you very much!
@@danialmohamad1834 most welcome!
Gud luck
Thank you :)
Writing data is never been so easy
Yes...this way is super easy