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
@alenofficial30978 ай бұрын
syntax error quote in unquoted cell, cannot parse text argument to list from csv table as formattable table error in my application please help
@alenofficial30978 ай бұрын
i am trying both send data and read data on same screen
@ObsidianSoftEducation8 ай бұрын
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 ❤
@UncleJeff1665 ай бұрын
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! :)
@ObsidianSoftEducation5 ай бұрын
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 👍
@vishnusudheer60494 ай бұрын
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.
@ObsidianSoftEducation4 ай бұрын
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.
@vishnusudheer60494 ай бұрын
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
@ObsidianSoftEducation4 ай бұрын
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-tu5zp4 ай бұрын
Thankyou so much mam❤❤
@ObsidianSoftEducation4 ай бұрын
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
@trendzmedia423410 ай бұрын
press submit button the how to clear automatic
@ObsidianSoftEducation10 ай бұрын
After pressing submit button, set both text boxes to empty Text blocks.
@Sam19881558 ай бұрын
Once download the app we need some changes are there that data Will come on download app it is possible
@ObsidianSoftEducation8 ай бұрын
I am sorry but I wasn't able to understand your question. Are you talking about aia project file or apk file?
@Sam19881558 ай бұрын
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.
@ObsidianSoftEducation8 ай бұрын
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.
@Sam19881558 ай бұрын
Okay I have understood thanks for your support.
@ObsidianSoftEducation8 ай бұрын
Most welcome 😊
@user-tc2np2rd7l9 ай бұрын
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?
@ObsidianSoftEducation9 ай бұрын
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-tc2np2rd7l9 ай бұрын
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.
@ObsidianSoftEducation9 ай бұрын
Glad to hear that you found a solution :)
@Nikolkats10 ай бұрын
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!
@ObsidianSoftEducation10 ай бұрын
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 ?.
@amaltp48933 күн бұрын
Can we do it for MS forms ?
@ObsidianSoftEducation3 күн бұрын
I haven't tried it.
@muhammadev342411 ай бұрын
Hai, Can we upload the picture taken by camera like this?
@ObsidianSoftEducation10 ай бұрын
Did it work out for you using email as discussed on Instagram?
@muhammadev342410 ай бұрын
@@ObsidianSoftEducation It's not practical to write email id always. However I have completed project by uploading Google drive as you advised
@ObsidianSoftEducation10 ай бұрын
@muhammadev3424 good to hear this 😊
@tenij0008 ай бұрын
can send the data also to a ROW inplace of a collum
@ObsidianSoftEducation8 ай бұрын
It already adds data to rows, but yes, you can't send data to a specific row or column with this method.
@tenij0008 ай бұрын
thx @@ObsidianSoftEducation
@ObsidianSoftEducation8 ай бұрын
@@tenij000 most welcome
@AnuSriReddy-me2hb3 ай бұрын
Submit botton is not working
@ObsidianSoftEducation3 ай бұрын
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 :)
@evanrizo6 ай бұрын
When I click on Submit it does nothing
@ObsidianSoftEducation6 ай бұрын
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
@evanrizo6 ай бұрын
I have checked everything, unfortunately it does nothing
@ObsidianSoftEducation6 ай бұрын
I hope you are looking at the right sheet. It is not the first sheet, but the second one labelled something like form responses.
@evanrizo6 ай бұрын
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
@ObsidianSoftEducation6 ай бұрын
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-kx7ou1me6u6 ай бұрын
This does not work! You may want to update. Thanks
@ObsidianSoftEducation6 ай бұрын
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
@argyriosyannakakis10 ай бұрын
Dont work for me 😢
@ObsidianSoftEducation10 ай бұрын
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.
@videofamille3A10 ай бұрын
Ok i will ckeck all the process@@ObsidianSoftEducation
@argyriosyannakakis10 ай бұрын
It's OK now, i forget to change & by ? sorry . Good tutorials, thank you.