Тёмный

How to send data to a google sheet with MIT app inventor [ Easy Way ] 

Подписаться
Просмотров 44 тыс.
% 568

To Send App Inventor data to Google Sheets we will use the here google form with the help of the Google Forms we will create the link with endpoints to pass our app inventor values.
Google Sheet Link for Form -: "
docs.google.com/forms/d/e/1FAIpQLSfxoz5dqXC-_LoGJWZCP93ww6woHcOl0s48PYcCj-72uUJoBQ/viewform?usp=pp_url&entry.1651815625=Radha&entry.952362665=Krishna"
To Convert this link to this way
"
docs.google.com/forms/d/e/1FAIpQLSfxoz5dqXC-_LoGJWZCP93ww6woHcOl0s48PYcCj-72uUJoBQ/formResponse?&submit=Submit?usp=pp_url&entry.1651815625=Radha&entry.952362665=Krishna"
Instead of "viewform" you have to write "formResponse?&submit=Submit"
Join this channel to get access to perks:
ru-vid.com/show-UCyNJURC5bvqIQ9vO9PBrYrAjoin
The Coding Bus #unitedstates #us

Опубликовано:

 

7 июн 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 97   
@gaellemoulec5134
@gaellemoulec5134 Год назад
Thanks a lot , I have succed to save in google sheets all gps coordinates when I drive to indicate all the bridge in the road
@Jeevaji14
@Jeevaji14 Месяц назад
It's Very smart way to achieve this, I like it
@TheCodingBus
@TheCodingBus Месяц назад
thanks
@sadikyildiz6582
@sadikyildiz6582 Год назад
Thank you. It is very nice. What I want to ask is, we are uploading data, what should we do if we want to withdraw data?
@TheCodingBus
@TheCodingBus 4 месяца назад
Glad you liked it!
@tevers6812
@tevers6812 Год назад
Thank you so much. It works great! I have a little question: after sending the data, is it possible to automate 'closing the screen', give the user a 'thank you' message and then forward to another screen? I've tried, but it didn't work out. Thanks in advance. Kind regards, Mathijs
@allenchesterramones3466
@allenchesterramones3466 2 месяца назад
This channel is very helpful thank you so much codingbus
@TheCodingBus
@TheCodingBus 2 месяца назад
most welcome
@VenkatachalamRavindran
@VenkatachalamRavindran 11 месяцев назад
Wonderful video. It works very well
@TheCodingBus
@TheCodingBus 10 месяцев назад
That's fantastic news! I'm thrilled to hear that the video was helpful and that the instructions worked well for you. If you have any more questions or if there's anything else you'd like assistance with, feel free to reach out. Your success and positive feedback are greatly appreciated!
@jimijimbow2830
@jimijimbow2830 Год назад
Why dont i see any publish menu in my apps script? And the script debug says that the parameter "e" is undefined.
@adib3010
@adib3010 11 месяцев назад
May i ask, what if the data to be submit at Google Form is in form of image. Is there a way to add image to google form through MIT APP INVENTOR?
@TheCodingBus
@TheCodingBus 11 месяцев назад
Yes possible. For that u need to use base64 extension
@maizzzzzy_
@maizzzzzy_ Год назад
it didn't work even though i tried many times😭😭😭
@jichellepardillo1626
@jichellepardillo1626 Год назад
Hi so I was just gonna asked I have like 2 users a client and a technician, how can i fetch my data from my excel to the technicians dashboard. Thanks
@geboosnowsimba1258
@geboosnowsimba1258 2 года назад
haii. i want to add text box for reasons. i just copy paste the block and copy the link "&until=" but didnt show up after click the submit button. how must i do then? please help
@TheCodingBus
@TheCodingBus 2 года назад
Have u changed the view form text Please check the description let me know working or not
@LauraNas-xc8iw
@LauraNas-xc8iw Год назад
What if I want to use multichoice?
@bhanunagpure231
@bhanunagpure231 2 года назад
thank you madam, keep up the great work
@TheCodingBus
@TheCodingBus 2 года назад
Most welcome 😊
@rahulchandwadkar8503
@rahulchandwadkar8503 Год назад
When i try to enter data it says url is not valid
@TheCodingBus
@TheCodingBus Год назад
Check the url
@amrehab7894
@amrehab7894 Год назад
Can I make an app that its output is different excel sheet I mean that I enter the data on the app and each submit I make store the data in new google sheet
@TheCodingBus
@TheCodingBus Год назад
Yes u can. for that you can to call different different google sheet
@HenryYooRich
@HenryYooRich 5 месяцев назад
Thank you very much! Great help!
@TheCodingBus
@TheCodingBus 5 месяцев назад
Glad it helped!
@techloker8584
@techloker8584 2 года назад
Bro i want to make it a login page but I had a problem this login page is oping always i want to open Frist time
@TheCodingBus
@TheCodingBus 2 года назад
you have to use condition like whenever someone open the app then you have to set one flat like create one variable and set that value to 1 or something it means this form is already opened. now whenever someone open this app in same phone then u can check that condition or flag value is 0 or 1 to display ur login page. make sure store this value in tinydb not in globale db
@janakachathuranga6039
@janakachathuranga6039 Год назад
how to send more data with more coloums to google sheet
@tomschuh6301
@tomschuh6301 2 года назад
I wanted to use this as a data logger, so I set up a timer to send the form data every 60000ms. This works fine with the screen on and the app active, but if the screen turns off or if the app is running in the background it will only send the form data for a few minutes then stop. Any idea how to keep it active while running in the background?
@TheCodingBus
@TheCodingBus 2 года назад
Yes.. to do this u have to use background running extension for app inventor that extension keep running ur app in background
@nursyaffianadirah4997
@nursyaffianadirah4997 2 года назад
hai. can you make a new video MIT app that can go to whatsapp because in your old video, the extension logcall whatsapp didnt exist anymore. where can i find another extension? :(
@TheCodingBus
@TheCodingBus 2 года назад
sure i'll
@ouiouinonnon3186
@ouiouinonnon3186 2 года назад
Hi! I've watched this tutorial over and over but after doing the changes in the link it always asks to login before filling the form. What am I doing wrong?
@TheCodingBus
@TheCodingBus 2 года назад
Hello Press the new blank form button: This opens the Forms settings box. Make sure that the “Require Sign in” option is unchecked: In Google forms, click the “Send” button and copy the short link to the form. ... Then see that the form works without Google sign in:
@FernandoFlores-rp4yl
@FernandoFlores-rp4yl 2 года назад
@@TheCodingBus Could you elaborate on this? I can't see the Required Sign-in option. Thanks.
@aaliri
@aaliri 8 месяцев назад
I did this but Google blocked my form... do you know why?
@TheCodingBus
@TheCodingBus Месяц назад
really make sure don't collect policy against data
@-o-hiho
@-o-hiho 5 месяцев назад
Thank you so much!
@TheCodingBus
@TheCodingBus 5 месяцев назад
Most Welcome 🙏
@alirezasharifi90
@alirezasharifi90 Год назад
Great tutorial, that was so easy🙂but I have a qusetion, how can I read data from google sheet? for example, i want to use google sheets as a database for a login and register app I want to send username and password on signup screen, and recive that username and password Plz help me, thanks🙂
@HendrikBez
@HendrikBez Год назад
Great video. But how does it work if I have to add a formula with my data to the google sheet
@TheCodingBus
@TheCodingBus 4 месяца назад
Glad you liked it! Stay tuned for more 😊
@MJRoBot_MarceloRovai
@MJRoBot_MarceloRovai Год назад
Great tutorial! Thanks a lot!
@TheCodingBus
@TheCodingBus Год назад
Glad it was helpful!
@tonuch1310
@tonuch1310 2 года назад
How to implement unity ads in mit app inventor
@TheCodingBus
@TheCodingBus 2 года назад
i'll make a tutorial on that
@mayank2473
@mayank2473 2 года назад
Hoq to get data from spreadsheet to app
@TheCodingBus
@TheCodingBus 2 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nLKZR1L5JaA.html
@EveraldodasilvaMATH
@EveraldodasilvaMATH Год назад
Sensacional! Obrigado!
@TheCodingBus
@TheCodingBus Год назад
Bem-vindo!
@doblejote
@doblejote Год назад
Que buen tutorial!!!! Gracias
@robertregalado4669
@robertregalado4669 Год назад
Hi, the element CALL "WEB1" .GoToUrl (url) is not listed here in my end, what will I do?
@arceditor333
@arceditor333 9 месяцев назад
Did u got the solution
@DianaTan
@DianaTan Год назад
Thank you.
@TheCodingBus
@TheCodingBus Год назад
You're welcome!
@__Vizion-_-
@__Vizion-_- Год назад
it worked😃hope i'll get a good grade
@TheCodingBus
@TheCodingBus Год назад
Glad to hear that. Stay tuned!
@anisamohdyusoffktn4198
@anisamohdyusoffktn4198 Год назад
i tried so many times it doesnt work. where did i go wrong
@anisamohdyusoffktn4198
@anisamohdyusoffktn4198 Год назад
DONE😀
@TheCodingBus
@TheCodingBus Год назад
good
@TheCodingBus
@TheCodingBus 8 месяцев назад
good
@deepusingla6882
@deepusingla6882 6 месяцев назад
me getting CORS error don't know why
@TheCodingBus
@TheCodingBus 6 месяцев назад
u need to allow the file
@benitosclub
@benitosclub 10 месяцев назад
muchas gracias
@TheCodingBus
@TheCodingBus 10 месяцев назад
Most Welcome 🤗
@michaelfernandez3049
@michaelfernandez3049 2 года назад
nice video. thanks
@TheCodingBus
@TheCodingBus 2 года назад
Most Welcome 🤗
@DonzDelongeJr
@DonzDelongeJr 5 месяцев назад
Why it didnt works ?
@DonzDelongeJr
@DonzDelongeJr 5 месяцев назад
when i use a app companioon on phone
@TheCodingBus
@TheCodingBus Месяц назад
some time app companion have issue try this new video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PE2Py0mqIfM.html&pp=ygUmZ2V0IGdvb2dsZSBzaGVldCBkYXRhIG1pdCBhcHAgaW52ZW50b3I%3D
@PrasadNiroshan-r7t
@PrasadNiroshan-r7t Год назад
Great
@TheCodingBus
@TheCodingBus Год назад
thankyou
@mauriciomenezes9962
@mauriciomenezes9962 2 года назад
E o delete?
@czargiffordvismanos1337
@czargiffordvismanos1337 Год назад
it does not work
@STARGAMERMJ
@STARGAMERMJ 2 года назад
Nice
@TheCodingBus
@TheCodingBus 2 года назад
Thanks
@adhirapratama5248
@adhirapratama5248 2 года назад
bro can you make a tutorial to make with 10 textbox?
@TheCodingBus
@TheCodingBus 2 года назад
okay... BTW it's simple just copy paste the textbox and repeat the code
@adhirapratama5248
@adhirapratama5248 2 года назад
@@TheCodingBus thats not working 😓
@gera_cl4219
@gera_cl4219 2 года назад
fine
@TheCodingBus
@TheCodingBus 2 года назад
Thanks
@kmhooibg7577
@kmhooibg7577 Год назад
Can you send me your project link
@TheCodingBus
@TheCodingBus Год назад
use timer or reset button
@kmhooibg7577
@kmhooibg7577 Год назад
I fail to do that :(
@TheCodingBus
@TheCodingBus Год назад
oh... i'll share the aia file
@ahmedmoslem5842
@ahmedmoslem5842 Год назад
thanks
@TheCodingBus
@TheCodingBus Год назад
Welcome
@ara7878
@ara7878 2 года назад
спасибо хорошее решение
@TheCodingBus
@TheCodingBus 2 года назад
добро пожаловать
@bobsonssauro
@bobsonssauro 8 месяцев назад
Problema de CORS.
@TheCodingBus
@TheCodingBus 20 дней назад
try this ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vO3QYKMX6Mo.html&pp=ygUoc2VuZCBtaXQgYXBwIGludmVudG8gZHRhIHRvIGdvb2dsZSBzaGVldA%3D%3D
@Behappyalways309
@Behappyalways309 3 месяца назад
THis is not working
@TheCodingBus
@TheCodingBus 3 месяца назад
Getting error ? Please share ur code
@TheCodingBus
@TheCodingBus 3 месяца назад
Recheck the url may be something missing
@Behappyalways309
@Behappyalways309 3 месяца назад
It didn't work. I did exactly like how you said
@Behappyalways309
@Behappyalways309 3 месяца назад
​@@TheCodingBussend your email address. I will send the code