Send data to Google Sheet in MIT App Inventor (SUPER EASY) | Send App Inventor data to Google Sheet

[@ObsidianSoftEducation]

Written Tutorial: obsidiansofteducation.blogspot.com/p/send-data-to-google-sheet-from-mit-app.html

[@uzmashahzad9061]

Thanks for sharing easiest way to work on Google sheets & link that to MIT App converter. Simple to apply

[@ObsidianSoftEducation]

Most welcome 😊

[@ayedanasim5713]

Wow that's awesome. Really easy way to connect the Google sheets with MIT app inventor

[@novinayaz9347]

You're doing an amazing job, thanks for this video 👍

[@zahrakhan1846]

I love watching your videos with full of authentic knowledge. It is always a learning process for me..

[@ObsidianSoftEducation]

Wonderful

[@alenofficial3097]

syntax error quote in unquoted cell, cannot parse text argument to list from csv table as formattable table error in my application please help

[@alenofficial3097]

i am trying both send data and read data on same screen

[@ObsidianSoftEducation]

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.

[@rubinakhq643]

Thanks for sharing informative video in very easy manner..keep sharing more

[@ObsidianSoftEducation]

So nice of you

[@maryamnaeem4973]

So so informative to watch 🙂 you always bring informative videos which i love watching because they are a learning process for me.🙃

[@ayyanadam3889]

Great outstanding work keep it up thanks for sharing this video

[@humairasiddiqui8476]

wow, amazing job, really it's so much easy

[@rajarani00182]

Thank you for sharing this easy way of working

[@sammislearning]

Omg it's so easy. Thanks for introducing this to me.

[@adyamys5110]

Outstanding work u make everything so easy to understand ❤

[@ObsidianSoftEducation]

Thank you so much 😀

[@binteidrees8277]

Thanks for sharing the easiest way

[@yuhani123]

thank you very much sir...I try to add the block with web viewer component to show the google doc response, and its work :-)

[@ObsidianSoftEducation]

Glad it helped

[@UjalaaliOfficial]

👍🙆 you Always explain in a very easy way ❤

[@UncleJeff166]

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

[@ObsidianSoftEducation]

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: kzbin.info/www/bejne/i17XnaOFmbJ6i9U

[@nubainzafar1578]

Thanks for sharing this tutorial 👍

[@vishnusudheer6049]

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.

[@ObsidianSoftEducation]

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.

[@vishnusudheer6049]

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

[@ObsidianSoftEducation]

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.

[@janjua245]

Good work This looks quite easy

[@ObsidianSoftEducation]

Thank you 😊

[@firdouszahir5411]

Thank you for sharing this amazing video

[@ObsidianSoftEducation]

My pleasure

[@sammislearning]

You're doing an amazing job

[@adyamy4052]

Really it's so easy😮

[@NowridHasninvlogzz]

That’s an awesome sharing

[@ObsidianSoftEducation]

Thanks for watching

[@lifeisthrillingyt7991]

Much easier to create & send through this advancement.

[@Jayadeep-tu5zp]

Thankyou so much mam❤❤

[@ObsidianSoftEducation]

Most welcome 😊

[@albertogiacomuzzi]

I tried two times the example, following exactly the instructionw, but at the end i did not arrived to write in the google sheet.

[@ObsidianSoftEducation]

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

[@trendzmedia4234]

press submit button the how to clear automatic

[@ObsidianSoftEducation]

After pressing submit button, set both text boxes to empty Text blocks.

[@Sam1988155]

Once download the app we need some changes are there that data Will come on download app it is possible

[@ObsidianSoftEducation]

I am sorry but I wasn't able to understand your question. Are you talking about aia project file or apk file?

[@Sam1988155]

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.

[@ObsidianSoftEducation]

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.

[@Sam1988155]

Okay I have understood thanks for your support.

[@ObsidianSoftEducation]

Most welcome 😊

[@user-tc2np2rd7l]

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?

[@ObsidianSoftEducation]

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.

[@user-tc2np2rd7l]

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.

[@ObsidianSoftEducation]

Glad to hear that you found a solution :)

[@Nikolkats]

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!

[@ObsidianSoftEducation]

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.

[@renaldybagussaputra1140]

Can you explain why we need to change the "&" to "?" only for the first line?

[@ObsidianSoftEducation]

That is the starting of the terms. So, we separate from the rest of url using ?.

[@amaltp4893]

Can we do it for MS forms ?

[@ObsidianSoftEducation]

I haven't tried it.

[@muhammadev3424]

Hai, Can we upload the picture taken by camera like this?

[@ObsidianSoftEducation]

Did it work out for you using email as discussed on Instagram?

[@muhammadev3424]

@@ObsidianSoftEducation It's not practical to write email id always. However I have completed project by uploading Google drive as you advised

[@ObsidianSoftEducation]

@muhammadev3424 good to hear this 😊

[@tenij000]

can send the data also to a ROW inplace of a collum

[@ObsidianSoftEducation]

It already adds data to rows, but yes, you can't send data to a specific row or column with this method.

[@tenij000]

thx @@ObsidianSoftEducation

[@ObsidianSoftEducation]

@@tenij000 most welcome

[@AnuSriReddy-me2hb]

Submit botton is not working

[@ObsidianSoftEducation]

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

[@Idontcheatlolaa]

Gud luck

[@ObsidianSoftEducation]

Thank you :)

[@evanrizo]

When I click on Submit it does nothing

[@ObsidianSoftEducation]

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

[@evanrizo]

I have checked everything, unfortunately it does nothing

[@ObsidianSoftEducation]

I hope you are looking at the right sheet. It is not the first sheet, but the second one labelled something like form responses.

[@evanrizo]

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

[@ObsidianSoftEducation]

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.

[@user-kx7ou1me6u]

This does not work! You may want to update. Thanks

[@ObsidianSoftEducation]

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

[@argyriosyannakakis]

Dont work for me 😢

[@ObsidianSoftEducation]

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.

[@videofamille3A]

Ok i will ckeck all the process@@ObsidianSoftEducation

[@argyriosyannakakis]

It's OK now, i forget to change & by ? sorry . Good tutorials, thank you.

[@ObsidianSoftEducation]

Good to know this 😊…all is well that ends well 😊

[@tiffanyjohnson7427]

Writing data is never been so easy

[@ObsidianSoftEducation]

Yes...this way is super easy

[@huyenizzi]

Thank you so much.

[@ObsidianSoftEducation]

You're welcome!