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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-U-tlpOdMGUs.html
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.
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.
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.
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.
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
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
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.