How to send data to a google sheet with MIT app inventor [ Google Sheet Database ]

[@mahdisaleh.learning]

Dear, It is worked, and for those who asked about the updated in the code, I did something and it works correctly, if you want to add another var or change the variables that mentioned in the original code, you must do these steps: 1- delete the app script. 2- create new one. 3- edit the code in a note file or in word file with your var. 4- copy the new code and complete it as shown in the video.

[@TheCodingBus]

Thanks...

[@RajeevKumar-yr5yi]

i have tried, it was working for more variable

[@xperimentsqf3823]

not working on me.. can u share your code?

[@poojap2604]

Bro it's not working for me ....

[@Maham899]

Thanks a lot . Following these instructions I executed the code successfully.

[@TheCodingBus]

Most welcome 🙏

[@Human-bx7od]

And congratulations for 5k Subscribers 😁👌👌👍👍🍬🍫🍭🍰🎂

[@Human-bx7od]

Make a special video for that

[@TheCodingBus]

Thank you so much 😀

[@TheCodingBus]

sure... soon

[@naman25sharma]

Hi, How to do so if i want to add one more row i.e. name, location and age?

[@realitydotsplus3917]

I tried it. It is working. I am happy. Thanks a lot for sharing such a useful tutorial .

[@TheCodingBus]

Welcome 😊

[@keans3386]

How did you do I am Curios, cause i spend almos 8 hrs but still is not working, like the link of my google spreedsheet is undifined :(

[@poojap2604]

@@keans3386 same prob I face .... Is there any library we have to install for Google scripts

[@shrutjain6032]

Thanks a lot your explaination is very good and its a very easy way. Thanks a lot again.

[@TheCodingBus]

You are most welcome

[@shaikaruna6967]

hlo i work with same steps that you are mentioned but the data is not updated in the google sheet

[@GuttHacker]

em vez de texto queria salvar fotos, como faz?

[@Promonkey01]

Nice videos , how to add more collum?

[@housemd4752]

You're clever man bro. Thanks

[@TheCodingBus]

Glad to help

[@dominiccox6948]

Thanks for this. It didn't work to begin with, then I realised that because I had changed the column headings I had to change the app script. It worked fine then.

[@TheCodingBus]

Most Welcome 😊

[@VarunKumar-fu2jq]

i am not getting this one

[@niceman567]

Thanks for the video! Love your channel, simple code that can lead to outcome and easy to digest, most importantly it works!

[@TheCodingBus]

Glad you enjoy it!

[@tmaxil]

how i can make it support other lang? I write in Hebrew and its not get the Heb text

[@nievesjoshua1238]

Thanks for the video... Do you have Image List picker to Google Sheet

[@dimitrispanagiotou7262]

HI GREAT JOB!How can i take data from from app inventor multiple screens and have them in the same row? Thank you!

[@kaubrutv9864]

Plz make video on creating dictionary app using spreadsheet

[@TheCodingBus]

sure i'll

[@Human-bx7od]

After the data gets saved can we use it again. ... ..... For example I will do an app for sign in and sign up after singing in, the data will be saved in the sheet. using the same data will it read and sign us in ??

[@TheCodingBus]

Here is the blog about that community.appinventor.mit.edu/t/google-sheets-read-add-sort-delete-select/2001

[@Human-bx7od]

@@TheCodingBus thanks

[@ferhattasci4650]

Hello. I am writing in Turkey. I need help. I can't send Turkish characters. Text like "warm" or "triangle" instead of example sangram. Text like "ılık" or "üçgen" instead of example sangram

[@SoulCast7]

I press submit and nothing happens. No data appears in my spreadsheet. I have two-step authentication on my gmail, could that interfere?

[@TheCodingBus]

no... try again.. may be some code problem.. make sure paste link as it is...

[@ChakaHamilton]

Were you able to figure it out, I too have two-step authentication active.

[@rakeshbond009]

How can i send entry date also with this data to google sheet. i tried call clock but not working

[@protoback]

hi, do you know why the code is not working if I'm doing exactly the same steps.. says error in add user(e)

[@Asifiqbal138]

how can i add time stamp, when data is send first colum should be time to add data on google sheet.?

[@TheCodingBus]

yes

[@Asifiqbal138]

Can you help me how to do that?

[@moayadsalih3563]

Hi, I followed this procedure but when I click "submit" button I get this error msg (Cannot parse text argument to "list from csv table" as a CSV-formatted table). Whta does it mean please?

[@TheCodingBus]

read this community.appybuilder.com/t/list-from-csv-table-text/1483

[@moayadsalih3563]

@@TheCodingBus Thank you very much. That's solved now. However, if I enter text in non-latin letters it doesn't appear in my google sheet. Anyway I can get around that? Thanks

[@wierengajan]

thanks for the clear instruction

[@TheCodingBus]

You're welcome!

[@ritikgoplani6215]

When I am running script it shows error in line number 20 Please help me Showing error message "Cannot read property'parameter' of underlined (line20,file"code")

[@karanpatel8267]

make sure first do as it is that shown in video, then change your variable name or add other fields, u will not get error, recheck your code

[@TheCodingBus]

Yes

[@BeastGamer6969]

Awesome!

[@TheCodingBus]

Thanks!

[@sachinkumar8277]

@@TheCodingBus I try it but some reason it's not working help me!

[@michaelfranks2040]

How do I change the script if I want to send the data to start at a different column/row, say column 'D', row '4'?

[@siege26]

Is it possible to read the data from google sheets and display it on mit app?

[@aabhatathed5437]

if we want to add date column in sheet then what changes are required in apps script?

[@TheCodingBus]

select any component then ctrl+c then ctrl+v

[@krizz5825]

Helpful,but i want to add an additional column whose value depends on formula,how to do that

[@TheCodingBus]

thanks. try to send formula with data.

[@poojap2604]

Ma'am is there any library to be installed for Google scripts

[@nuraqilahazman5286]

Good and easy to follow . May I know how to retrieve timestamp as well? Because Im using IR sensors and need to modify a bit of your programming in mit app .

[@noutouyduangta4240]

Cool! Thanks for your sharing

[@TheCodingBus]

Welcome 😊

[@sandeepa4116]

Hi Sourabh, really well explained. Keep it up:)

[@TheCodingBus]

Thank You 😊

[@vijaydevakonda1935]

how to clear input field after submit

[@Asifiqbal138]

Great effort dear

[@TheCodingBus]

Thanks a lot 😊

[@muhammadusmanhanif222]

hi, thanks for helpful video. Can you please guide me how many users can use such app at a time OR how many users can send data from by using single app???

[@crbcreation_pkd]

I want to add more data like more column and row data what to do (any more codes required) ?

[@TheCodingBus]

Yes.. you have change into script file

[@anmolwadali9227]

Really simple and nice project

[@TheCodingBus]

Thank you! Cheers!

[@sergiomejia8837]

Excelente

[@TheCodingBus]

Thank You

[@kuaytenghei9986]

Hi, thanks for this great video. Can you help me further on how to combine data inserts by users from multiple screen into the same google sheet? For example, data insert by the same user will appears in the same row in the sheet but actually those data of different column comes from different screen of the app.

[@TheCodingBus]

Hi, Nice question, But you don't need to do nothing for that... google automatically detect the who came first or who put the value first.

[@ChakaHamilton]

The code works, however. How do I get it to go into a specific cell I have a cell CaregiverName & CaregiverPhoneNumber in the app and in the sheet. However when I submit the data, it goes into the first 2 rows which are before the two i mentioned, not those with the cell names above. is there a way to set it to go to a cell with specific header titles?

[@TheCodingBus]

yes... you have to mention cell in the app script code

[@ChakaHamilton]

@@TheCodingBus can you provide an example of its usage then from there can figure it out. update: I figured out what you were saying. Tx!

[@HA_HA1990]

Thank you for your demo. I really appriciated that good and well done lesson. Allah bless you. Please make the same about MSSQL or MYSQL database instead of Google sheet.

[@joindevelopers_nationformo8702]

Hey Haidar, It is easy to do it using MYSQL. I can help you out for free if you want

[@TheCodingBus]

I will try my best

[@saikatbasak2617]

Can you pls help me on .........i am making one app wherein i want to enter my ckecklist data in the app and automatically it will reflect in my digital checklist

[@TheCodingBus]

Yes.. you just need to code on checked box when checkbox will checked then save this data

[@TN-kd8ju]

Thank you. It worked great :)

[@TheCodingBus]

You're welcome!

[@ddtdilireba]

Hi, when copy the sheet url to the google apps script, do i need to open the "write" permission for my google spreadsheet?

[@TheCodingBus]

Yes

[@waqarghafoor6071]

Keep it up bro

[@TheCodingBus]

Thank You 😊..sure...

[@findthetruth3021]

1- How to download the App to mobile? 2- How to add drop down list 3- How to add chain or cascade drop down? Many thanks for this amazing video. Please answer us. Keep it up.

[@TheCodingBus]

1) In the top menu click on the Build option and download it in your laptop and transfer this app to your phone. OR generate the QR for apk 2) you can use list component for this 3) for that you have to use third party extension Thank You

[@olawale11954]

Good work i love it. How can i reset the form from the app after the user has click on send or submiy button and display successfully message, thank you

[@TheCodingBus]

yes possible. just hide the current layout and display the thank you test in another layout

[@nuruldesita8477]

sorry to ask, I sent the data to the Google sheet. But after sending, one column was missed. I tried to use Postman to check .. it said the script was complete but it didn't return anything. Please help. I have checked many times, everything is the same either in blocks or scripts. And there's no warning error showed up.

[@TheCodingBus]

First of all make sure you are using two column to send data.. and first make two column app

[@John-qe3ky]

Can you explain how to read a few rows and columns of numbers in google worksheet and display the information. Then push a button to refresh (reload) the display to reflect new changes to google worksheet data.

[@TheCodingBus]

I'll publish the video soon on how to read data from google sheet

[@armul07]

thanks man.. that's worked

[@TheCodingBus]

Welcome 👍

[@MuhdAkmal18]

Is there a way to insert photo/image into the excel?

[@TheCodingBus]

use base64 to convert image to text and then store it

[@piowar96]

Hi, I tried to repeat your example. Sorry but it is not working. The script is exactly the same. I have deployed it with success. I have checked the saveResponse property after calling the posttext , it is false but should be true. I do not know why. Please help.

[@TheCodingBus]

make sure work with same fields. if it's work then change the fields name

[@rtrmohamedshinazi1232]

bhaiya i pasted the sheet url in the app script then the app script url in the mit appinventor block section then i tested the app -----the data is not saving in the sheet--pls kuch solution hoga to bataiye--

[@TheCodingBus]

make sure deploy the app... use code as it is.. like variable name.. make sure paste the corrent link... overall recheck this will work... if not let me know...

[@dass8193]

Hello! does this method still work? i've followed each step perfectly and it doesn't seem to do anything to the spreadsheet.

[@TheCodingBus]

Yes it does.. recheck ur code... may be u missed something

[@parthbetai4452]

@@TheCodingBus bro same thing happened with me its not working

[@virajm5247]

@@TheCodingBus yes same

[@xperimentsqf3823]

not working on me too.. is it still working..?

[@dass8193]

@@xperimentsqf3823 Hi, i found a solution elsewhere, you have to enable the google sheet API in googlescripts, you can research more about that online.

[@sokunlyna]

it does not work, i followed all of the steps but my data does not go to the sheet. is there anything I can do to fix this?

[@FunZone01]

Sir please tell how to add more box ?

[@TheCodingBus]

u have to add variables in your app script

[@ryanron2022]

How can I add more colums to it, like phone number, email id, address, postal code, i tried adding it and did make some changed in the app script, able to create the web url successful, however data not coming to the sheet, i even tried vertical scrooling , and make some more changed still no go, can you please help. Thanks

[@TheCodingBus]

you have to change app script code for that... just create and pass more variable

[@ryanron2022]

@@TheCodingBus can you help me with your email id I will send the scrip.

[@RajeevKumar-yr5yi]

I am also facing same problem, can you send the modified scripts in my mail to [e-mail]

[@MohamedSaadAfify]

Waiting for solution too @The Coding Bus

[@MohamedSaadAfify]

@@ryanron2022 edit the last part like this: function addUser(e,sheet) { var Signature = e.parameter.Signature ; var Date = e.parameter.Date ; var Shift = e.parameter.Shift ; var Product = e.parameter.Product ; var Batch = e.parameter.Batch ; var Machine = e.parameter.Machine ; var IPC = e.parameter.IPC ; var Setup = e.parameter.Setup ; var LC = e.parameter.LC ; var DC = e.parameter.DC ; var AQL = e.parameter.AQL ; var pH = e.parameter.pH ; var SG = e.parameter.SG ; var UV = e.parameter.UV ; var MO = e.parameter.MO ; sheet.appendRow([Signature,Date,Shift,Product,Batch,Machine,IPC,Setup,LC,DC,AQL,pH,SG,UV,MO]); }

[@dasunmadushanka1298]

nice video

[@TheCodingBus]

Thanks

[@dasunmadushanka1298]

How we can get the feed back or notification after click the submit button?

[@xperimentsqf3823]

is it still work? coz i try this but not work .. i rechecked the code, but no differents.. any solutions?

[@dr.arvindgiram8460]

Hi Thanks for a nice video I tried to built an app for my surgical workdone but after clicking send data it is not getting uploded to spread sheet. I copied ur code and made some additions in variables only. Can send u to cheak it.

[@TheCodingBus]

Thank You.. Okay... make sure you have to update variable in 2 place

[@dr.arvindgiram8460]

@@TheCodingBus thanks for replying so quickly. Plz guide, as ur help is going to help me built an app for covid worriers & I'm one of them.

[@TheCodingBus]

I'll make a video on that...how we can add the more field's or how to modify app script...

[@dr.arvindgiram8460]

@@TheCodingBus thanks a lot. Plz share ur mail id so that it will be easy for me to share coding done by me if possible. This app is just a testing for a large data to be constructed with a lot of variables. Once again thank you !

[@TheCodingBus]

[e-mail]

[@pentagonikonic946]

Thank you so so much

[@TheCodingBus]

Welcome 😊

[@Stuckathomemom]

Brilliant!!

[@TheCodingBus]

Thanks

[@dietergasser5778]

Hi Sourabh Thanks a lot for this video, it helps me a lot. May i ask you a question? If i want to write only into one cell and i want to overwrite this cell each time, how would i adjust the code? Probably i only need to change the last line of your code (appendRow), but how? Thanks a lot...D. Gasser

[@TheCodingBus]

Yes, definitely

[@jiopydesign3055]

I have the same question. Is it only that one line of code that needs changed?

[@abhinav4638]

In the video you showed only how to send data but how can we read data from Google Api sheet in mit app inventor

[@TheCodingBus]

i'll make another video for that

[@paragmathur6016]

@@TheCodingBus pls make it this week need this urgently Thanks

[@FunZone01]

What is the code for it ?

[@TheCodingBus]

for send data

[@kabirnehra]

Please. Make a video . How to make a Barcode Scaner. App. Video

[@TheCodingBus]

sure.... Soon

[@zayngrin4682]

how to put 3 items like name , id number and quantity at the same sheet ? just add the name of item?

[@TheCodingBus]

just add item and change on app script.. you have to make other varible for extra iteam..

[@CodingHats]

I tried it but the problem is whenever I click on the button after entering name and location and check the spreadsheet I don't get the added data there. Please help me out coding bus.

[@TheCodingBus]

make sure you have to put your own sheet link... recheck your code

[@CodingHats]

Thank you

[@nuruldesita8477]

Can I send data from LABEL ?? I wanna send the result from my calculator that shows up on label

[@TheCodingBus]

Yes you can...

[@nuruldesita8477]

@@TheCodingBus can I use the same coding as what you made? and replace the textbox with label? Or I need another code or script? Please help me.

[@sonu3027]

doGet function not found.. what to do?

[@TheCodingBus]

recheck your code.. u will get it

[@keshavmurthy6998]

Thank you Sir...

[@TheCodingBus]

Most Welcome

[@andytan5513]

Hi, is the & and = sign necessary?

[@TheCodingBus]

Yes

[@erikkpritchard]

location posts to Google Sheet but name does not. Where might the error be?

[@TheCodingBus]

error might be in your variable names

[@broplayers1567]

Can u please tell me how to add data in more than 2 column. Am not able to do so press please help me

[@TheCodingBus]

you have to change to code part.

[@broplayers1567]

@@TheCodingBus i tried adding the extra column names but the data isn't showing there

[@broplayers1567]

@@TheCodingBus can u please tell me how to change in a perfect way pls

[@jijeeshpadmanabhan350]

Can we connect MIT inventor with Air table?. please reply.

[@TheCodingBus]

no

[@jijeeshpadmanabhan350]

@@TheCodingBus ok

[@juliorodrigotorres1912]

Great app! It worked the first time, but when I tried to do it again, the app script says "TypeError: Cannot read property 'parameter' of undefined (line 16, file "Code"). How can I fix it? Thank you

[@TheCodingBus]

Thank You, have you changed column value in app script or in design or have u added another column if Yes then you have to change it properly u should have a basic knowledge of JS

[@sandip528]

How to get confirmation of every entry

[@TheCodingBus]

use notifier

[@-boomagency507]

i need your help please I use 4 buttons but I cannot modify the code

[@TheCodingBus]

you can add more variable in code

[@-boomagency507]

@@TheCodingBus how?

[@-boomagency507]

@@TheCodingBus did you can make for me please?

[@-boomagency507]

@@TheCodingBus contact whats App: [phone]

[@tedfun3681]

I tried this way.. But... The data isn't showing on google sheet

[@TheCodingBus]

recheck variable and code

[@teamsatyarthi4406]

can we also save images in google sheet?

[@TheCodingBus]

Yes

[@STaSMn135]

Thanks for the tutorial. It worked perfectly but when I type Russian characters in my form it doesn't show up on the sheet. Can you tell me what is the problem?

[@TheCodingBus]

Let me check

[@fh3rslax293]

Great video,it is very helpful.Please could you help me with the script to remove and/or update a row by selecting it from the app using listview

[@TheCodingBus]

Thanks.. sure

[@anupludra]

I am unable to do a google script for UPDATE RECORD. Can u help?? I have a google sheet where 4 - 5 users are uploading data from mobile app. The app is working fine. My requirement is that when any user upload data, his previous data should get updated with the new data. So for every user, there should be only 1 record available on the google sheet (LAST SENT RECORD).

[@TheCodingBus]

Hi, this will work fine if you are uploading the data from different device. because we are using the same script

[@anupludra]

@@TheCodingBus I this it would be the other way around. If I am the user and I am uploading My data, Then My Data will get over written. I cannot OVERWRITE anyone else's data !!

[@anupludra]

@@TheCodingBus Tx for your response anyways .. I got it to work.

[@anupludra]

The data being uploaded is tagged with a unique identifier for the user. So to update a record, the unique identifier is compared. That way only I can update My record.

[@UnpluggedGuru]

Ma'am, Is this method also works for xlsm file ?

[@TheCodingBus]

sorry.. no idea.. you should try.. and let me know i

[@UnpluggedGuru]

@@TheCodingBus No ma'am its not working. It will be a big help from you if its works.

[@FASOYLAS]

excellent job, I try to send data with greek characters but it doesn't recognize them, with Uk characters works just fine . Is there any way to fix that, the problem is with the MIT app, or is it about the script function? Keep up the good work.

[@TheCodingBus]

Let me check

[@FASOYLAS]

@@TheCodingBus Hello again, did you find any solution?

[@Targajens]

hy and reverse ? How to reciever data from a google sheet in MIT app inventor [ Google Sheet Database ]

[@TheCodingBus]

i'll create it soon

[@Stuckathomemom]

You wouldn't happen to have a video that explains how to put in all the data types - like check boxes?

[@TheCodingBus]

i'll make a video on that

[@lukmannet]

Very good, how to add more cell?

[@TheCodingBus]

Thanks Will upload soon

[@poojandholakia3288]

Hello Saurabh Sir, Can you please guide on how to update the record in the google sheet using MIT App Inventor ? I have referred to your video for sending data and receiving data but now I want to update 1 record from this data? Can you please guide?

[@TheCodingBus]

you have to just remove that 1 parameter ... in the video we are storing the 2 values

[@poojandholakia3288]

@@TheCodingBus Thank you for the response, but I am not that great in the coding part. Can you please elaborate or post that line of code here ? Thanks

[@poojandholakia3288]

Hey, I basically want to edit the value on one of the row and column. Update from what value we have. Say some age is mentioned in the cell "25" and now want to replace with "34". How do we do m

[@DTITSTUDIO]

How to user data store in WhatsApp aur telegram please. Tell me one video please sir

[@TheCodingBus]

okay i'll make a video for that

[@DTITSTUDIO]

Bro plz Google sheet data store system video please bro

[@matthewgalve137]

hello how can I reset spreadsheet? I want it to start in number 2 again.

[@TheCodingBus]

sorry i have to check this option

[@tamilselvansubramanian6544]

Hi Sir, i want to overwrite specified cell each time ( input from textbox). I have tried manually through script "sheet.getRange('B1').setValue(205);" It works.but how to pass textbox value to spreadsheet...

[@TheCodingBus]

for that you have to use some loop to insert values in specific cell

[@chandreshkatharotia1104]

Sir, I can't solve this error please guide "TypeError: Cannot read property 'parameter' of undefined (line 21, file "Code")"

[@TheCodingBus]

How many fields in your google sheet..? have you define the variable

[@chandreshkatharotia1104]

Thank you sir, I made app for using more variable and also providing extra button for clearing fill data in list after send in google sheet.

[@rajdeepjaiswal7370]

Can you make app like 2 phone will be connected through Bluetooth and if I play any music then in both mobile music will run AT same time Please try 🤗

[@TheCodingBus]

i'll try..

[@kabirnehra]

Yes

[@Manhans2731]

Hi I am trying but data not reaching to Google sheet please help me

[@TheCodingBus]

may i know the error please?

[@s.a.srinivasan9256]

Madam, I am an assistant professor. I want to know that,how to get all students details from all students mobile to my Google sheet

[@TheCodingBus]

Hello Tamil Tech, I'm Sourabh you can create an app where you have to put some fields like students name , number etc and then save send all details to google sheet...

[@iqbalrana6049]

the code isnt working

[@TheCodingBus]

make sure put ur own sheet link

[@gsvend2272]

It works! But how to add a third column?

[@TheCodingBus]

you have to add the variable