Тёмный

Google Sheets | How To Send HTML Form Data To Google Sheets 

Learning Axis
Подписаться 180 тыс.
Просмотров 75 тыс.
50% 1

#html #css #javascript #tutorials #trending #new #google #googlesheets #integration
Source code (HTML Form): shorturl.at/frDFY
App Scripts: shorturl.at/cklT2
Sound effects from Pixabay.

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

 

23 июн 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 181   
@prof.alexsouza20
@prof.alexsouza20 Год назад
Amazing! Congratulations! Thanks
@incrediblelearned4981
@incrediblelearned4981 3 месяца назад
good video, funny part was 'html dada'
@yalebass
@yalebass 26 дней назад
this actually worked great! was a bit sus of the permissions shenanigans, but it's probably fine. thanks so much!
@crinceebelempou6611
@crinceebelempou6611 Год назад
Amazing
@BinNguyenVlog
@BinNguyenVlog 7 месяцев назад
Nice video
@hiroyukinumaguchi1984
@hiroyukinumaguchi1984 8 месяцев назад
Great!
@cashflowai506
@cashflowai506 7 месяцев назад
good job brother
@ganesht7148
@ganesht7148 Месяц назад
Thankyou very much! i was struggling with the CORS error. This helped a lot.
@duhabejo8370
@duhabejo8370 Месяц назад
Amazing! Thanks,sir..
@phuclahoang9266
@phuclahoang9266 Год назад
amazing
@dev.antunes
@dev.antunes Месяц назад
Thanks a bunch! It worked well!
@Loselegidosdecristo1
@Loselegidosdecristo1 6 месяцев назад
Este vídeo vale oro, estuve buscando vídeo pero esta es la mejor,
@CanaldoGui
@CanaldoGui 9 месяцев назад
Thank you so much for everything! God bless you and give back double for your contribution and sharing this solution with us! Grateful 🤝🏼
@learning-axis
@learning-axis 4 месяца назад
thank you
@BinNguyenVlog
@BinNguyenVlog 7 месяцев назад
Amazing! Thanks
@ahmadchohan1012
@ahmadchohan1012 11 месяцев назад
This video is so useful.
@FikirCompany
@FikirCompany Год назад
Thank you very much 👍❤
@szyman4666
@szyman4666 4 месяца назад
Good video thanks a lot
@PakistanZindabad-vi6xd
@PakistanZindabad-vi6xd Год назад
🫡🫡🫡🫡 This channel is so amazing. God bless all of U. M just started learning HTML as my first language to learn. And these easy tutorials are blessings for me. Boss don't know how to express my gratitude.... Thanks very much!! 🥲🥲🥲 Love and respect from Multan Pakistan 🇵🇰
@learning-axis
@learning-axis Год назад
Thank you bro.
@kaleenislive1452
@kaleenislive1452 5 месяцев назад
INDIA jindabaaadd
@ruddykielo82
@ruddykielo82 11 месяцев назад
top!
@owallace190
@owallace190 Месяц назад
I don't know how it works, but it's what I was looking for so much
@edppdammks
@edppdammks 2 месяца назад
greaaattt
@Sloppynuts
@Sloppynuts 7 месяцев назад
Thank you, bro. Your tutorial is very useful. keep it up!
@learning-axis
@learning-axis 7 месяцев назад
thank you
@user-jxnc
@user-jxnc 6 месяцев назад
Thank you so much! with the source code, it's so easy and that works!
@learning-axis
@learning-axis 6 месяцев назад
thank you
@jorgeflores762
@jorgeflores762 8 месяцев назад
Gracias, nos salvaste la vida a mi grupo y a mi, eres el mejor.
@learning-axis
@learning-axis 8 месяцев назад
Thank you
@alexandremartins6130
@alexandremartins6130 10 месяцев назад
Thanks bro!
@TestVideo2share
@TestVideo2share 3 месяца назад
That's great, thank You very much!!👍
@learning-axis
@learning-axis 3 месяца назад
thank you
@alexapfatalimachi9224
@alexapfatalimachi9224 7 месяцев назад
thank you very much :)
@user-il9lc4wm4c
@user-il9lc4wm4c 3 месяца назад
thank you so much!!
@studysangam0.194
@studysangam0.194 15 дней назад
Sir ka video bahut achha hai mai bahut paresan tha javascript code ke lekar magar aapki sahayta aur chatgpt ke maddt se clear ho gya Thanks sir❤❤
@learning-axis
@learning-axis 14 дней назад
Thank you
@abhijithjinnu603
@abhijithjinnu603 2 месяца назад
Thank You! This works.
@learning-axis
@learning-axis 2 месяца назад
thank yoy
@ak_yt86
@ak_yt86 10 месяцев назад
I really find this video bro, you made my day 😍, thanks a lot for you make this video for me 🙂
@learning-axis
@learning-axis 10 месяцев назад
thank you
@Pratham008
@Pratham008 11 дней назад
Thank you so much
@user-se4pf6vu5r
@user-se4pf6vu5r 8 месяцев назад
how would be the app script if i add another sheet within the same google sheet
@oscar_mine
@oscar_mine 2 месяца назад
thanks man
@echoesandnoise
@echoesandnoise Месяц назад
Thank you!
@MirkoTorrisi92
@MirkoTorrisi92 4 месяца назад
Am I the only one who found IMPOSSIBLE to debug this stuff?? Really crazy.
@harithdevinda
@harithdevinda 4 месяца назад
thank you ... !!!
@abraham_o
@abraham_o 25 дней назад
If I have 3 wishes from a genie, one of them will be to be able to write code like this without writing bugs or the need to press backspace... 🤤 I mean this is amazing.
@jamal.salouni
@jamal.salouni 6 месяцев назад
thank you so much you give me exactly what i want you are amazing
@learning-axis
@learning-axis 6 месяцев назад
thank you
@3PFTChannel
@3PFTChannel 8 месяцев назад
Thank you, It's awesome
@learning-axis
@learning-axis 8 месяцев назад
thank you
@Instopedia_
@Instopedia_ 7 месяцев назад
Sir same method aan njn cheythr, but enik submit akumbo something error enna aa msg varunnu Enthaa cheyya
@khoatran1535
@khoatran1535 5 месяцев назад
Hi, i have a list input (checkbox) and i want to multi choice values. How to do it
@BasilIkpe
@BasilIkpe 3 месяца назад
Thank yoooooooooou
@EternalUltimate
@EternalUltimate 3 месяца назад
you are the best
@capurim
@capurim 11 месяцев назад
Thank you, it's a very nice tutorial but I have got an error in console : Access to fetch at 'my script URL' from origin 'my local URL' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled. Do you have a tip to resolve this bug? Thanks !!
@beinfomaniac7182
@beinfomaniac7182 9 месяцев назад
Same problem
@tinashesigauke1149
@tinashesigauke1149 11 месяцев назад
i have 3 diffrent form on my html code how do i go about it
@KoartePlays
@KoartePlays 4 месяца назад
thanks
@CT_Crock
@CT_Crock 2 месяца назад
I have question why i do the same step with yours but i my contact data won't add into google sheet but it show sucess in row 2
@yourdailyaffirmations9100
@yourdailyaffirmations9100 5 месяцев назад
How can we make the process faster.. it takes 5 secs.. Can we reduce it
@mundogamer4607
@mundogamer4607 5 месяцев назад
y como envio archivos se puede hacer eso?
@kaleenislive1452
@kaleenislive1452 5 месяцев назад
html dada >>> XD
@DipayanBrrandom
@DipayanBrrandom 4 месяца назад
How I store attachment file as well?
@danieladestefano3880
@danieladestefano3880 9 дней назад
Great video, and very well explained. Is there a way after having written the data to display only a correct sending message without displaying the address of the reference page in the pop up? Thank you for your response and your help.
@learning-axis
@learning-axis 9 дней назад
Thank you for your feedback! Yes, you can modify the pop-up to display only a success message without showing the reference page address. You can achieve this by setting the pop-up content to your desired message. Here’s a quick example: alert('Data sent successfully!');
@user-wx4rm8bt2c
@user-wx4rm8bt2c 2 месяца назад
Un descubrimiento, gracias. Intento modificarlo para poder subir una imagen pero no logro hacerlo. Me sale el formulario bien, no me da errores pero ni me sube la imagen ni me registra la URL
@vincentsominski9124
@vincentsominski9124 4 месяца назад
Hey. Really nice guide. I was wondering if it is possible to set each sheet to be for a single form and has like for ex. 3 forms and for each one will be one sheet. Do you have any idea if it is accessible?
@learning-axis
@learning-axis 4 месяца назад
you can do these things using node js
@frankbonan7273
@frankbonan7273 11 дней назад
Thanks beautiful project, how can I do to add a column with date and time added automatically to each submit?
@learning-axis
@learning-axis 11 дней назад
You can fetch time in JavaScript, forward it into the new input tag's value, and then to google sheets.
@Asd_Marriage_Beauro
@Asd_Marriage_Beauro 10 месяцев назад
sir ham na form ma photo be lagai ha photo ko google sheet ma kase save kare ga ya bata da thank you!
@muzamilzaman7463
@muzamilzaman7463 11 месяцев назад
Can we get copy of this code ???
@anhleuc1365
@anhleuc1365 6 месяцев назад
Great guide. I have 2 words but want to dump data into the same sheet. from 1 dump data page1 . from 2 dump data page2 . I have tried but it's failed . help me
@Sriraam_2k3
@Sriraam_2k3 4 месяца назад
Anybody can explain why he code in that another page of Excel site program 7:14
@user-ul8ro6po4c
@user-ul8ro6po4c 3 месяца назад
i want it to send it in exel app is it possible?
@Gamernick1404
@Gamernick1404 Год назад
Bhai kisme coding kar rhe ho
@tony4512
@tony4512 7 месяцев назад
Great video and thank you for sharing. First time playing with Google sites and I have everything up and running as in your video, I just can't figure out where I build and save the "Google Sheet.js" file and how it links to everything. Would you be able to elaborate a little more on this part (video marker 11:09)?
@learning-axis
@learning-axis 7 месяцев назад
just create a file named as sheet.js in any folder
@user-cz7gz1cy1n
@user-cz7gz1cy1n 7 месяцев назад
how do you add a 'upload file', add an image from files and then receive and open it on google sheets?
@learning-axis
@learning-axis 7 месяцев назад
we can't receive image file in google sheets
@v2al389
@v2al389 6 месяцев назад
So where can I send the file to open it?
@CamiloR1997
@CamiloR1997 5 месяцев назад
11:30 I have a problem with this part of the code, I'll explain. I completely created the code and the js file, and also the html linked that file, copied the link from Google Sheet and also pasted it into the js code. but when I refresh the page and enter their information and hit send, nothing happens. Neither the data is added to the sheet nor does the message appear.
@learning-axis
@learning-axis 5 месяцев назад
did you create account on smtpjs.
@learning-axis
@learning-axis 5 месяцев назад
and also add two step verification to your gmail
@CamiloR1997
@CamiloR1997 5 месяцев назад
@@learning-axis The code works for me, the form data is complete, everything is excellent, but when I enter the code for the thank you message and click send, nothing happens, the data does not arrive and the message does not appear either.
@CamiloR1997
@CamiloR1997 5 месяцев назад
@@learning-axis I already have my Hosting and I am doing it directly and my Gmail also has two-step verification. Do you have an email address where I can send you a short video so that you can help me?
@learning-axis
@learning-axis 5 месяцев назад
@@CamiloR1997 yeah "contact@learning-axis.com"
@shahjahanali5189
@shahjahanali5189 8 месяцев назад
How to add pictures in your form and upload my google drive
@skillzorskillsson8228
@skillzorskillsson8228 Год назад
You do know that font-family and font-size is inherited properties right? So why use it on the universal selector?
@learning-axis
@learning-axis Год назад
Some properties like font-size, and font-family are inherited from the parent when the element has no value specified in itself
@mk.bigboss122
@mk.bigboss122 Год назад
​@@learning-axis Hlo bro, I need a website, I will give money when the website complete. How to contact you 🤔 plz replay me
@learning-axis
@learning-axis Год назад
contact me on: blakdeer31@gmail.com
@learning-axis
@learning-axis Год назад
@@mk.bigboss122 sure
@clevermissfox
@clevermissfox 6 месяцев назад
They aren’t inherited by default on inputs. You have to set input {font: inherit}
@harsharavi2683
@harsharavi2683 9 месяцев назад
Hi, everything works perfectly. I want to know how do I redirect to another link once the form is submitted? Thanks in advance
@learning-axis
@learning-axis 9 месяцев назад
Replace (window. location.reload.) with (window. location.href="link";)
@antoniosh8130
@antoniosh8130 6 месяцев назад
@@learning-axis Hi! When I'm trying to fetch it shows an error saying I'm missing some headers? And keeps saying failed to fetch
@learning-axis
@learning-axis 6 месяцев назад
@@antoniosh8130 add twostep verification to you Gmail and create account on smtpjs
@Karmaevents
@Karmaevents 6 месяцев назад
hey good job, can we do it for a multiple step form ?
@learning-axis
@learning-axis 6 месяцев назад
yes you can do it
@Mickiewicz114
@Mickiewicz114 9 месяцев назад
I did everything listed in this video but it didn't work. Why does it keep showing me error with empty {}
@learning-axis
@learning-axis 9 месяцев назад
I also provided the code link in description please use that code
@khoatran1535
@khoatran1535 6 месяцев назад
If I click submit multiple times, many records with the same content will be created in the Google sheet. How to prevent that. Thank you
@learning-axis
@learning-axis 6 месяцев назад
you should also add "reload page function" on submit button
@khoatran1535
@khoatran1535 6 месяцев назад
thank you so much.i have resolved@@learning-axis
@jademarkfernandez1890
@jademarkfernandez1890 3 месяца назад
What app did you use to code? Im not very familiar sorry
@learning-axis
@learning-axis 3 месяца назад
sublime text
@jademarkfernandez1890
@jademarkfernandez1890 3 месяца назад
How about adding new column in google sheet,?
@jademarkfernandez1890
@jademarkfernandez1890 3 месяца назад
What is the code?
@beinfomaniac7182
@beinfomaniac7182 9 месяцев назад
I am having cors error Does anyone know how to fix it
@DougsTea
@DougsTea 2 месяца назад
You can just copypaste the code directly from his file. Mine isn't submitting any data to the google sheet (there is no error though).
@NicholasWidmer
@NicholasWidmer 2 месяца назад
what is in the java script file. Everytime i submit my page it bring me to a "pretty print" app script page. How do i stop this?
@learning-axis
@learning-axis 2 месяца назад
are you using local server?
@rysh62
@rysh62 7 месяцев назад
It gives me the "Result": "Success" "row 2" message but doesn't actually add onto the google sheets. What's the problem?
@learning-axis
@learning-axis 7 месяцев назад
check the names of inputs. check the name of the sheet you put in the app script.
@rysh62
@rysh62 7 месяцев назад
@@learning-axis cool i got it working! Thanks
@azharahmed7928
@azharahmed7928 6 месяцев назад
facing same issue what was the issue?
@learning-axis
@learning-axis 6 месяцев назад
@@azharahmed7928 check the names of inputs. check the name of the sheet you put in the app script.
@payunghujan1758
@payunghujan1758 Месяц назад
HOW to With Upload file/image?
@user-ws6uw9rs9l
@user-ws6uw9rs9l 3 месяца назад
I've copied your codes and done everything in your video. I get this error: "Script function not found: doGet"
@learning-axis
@learning-axis 3 месяца назад
do you add script in google sheets?
@gabrielkaqinari8299
@gabrielkaqinari8299 5 месяцев назад
Why submit button is not working to send data materials to google sheets ? @Learning Axis
@learning-axis
@learning-axis 5 месяцев назад
see code link in description, that may help you
@k.harsha8792
@k.harsha8792 5 месяцев назад
{"result":"error","error":{}} Iam getting this error after submitting the form can you please tell me where to correct
@learning-axis
@learning-axis 5 месяцев назад
create account on smtpjs and add two step verification to you Gmail account
@MumbaiKaCoder
@MumbaiKaCoder 5 месяцев назад
ASMR Coding - Creating Real Switch Button Animation using HTML and CSS ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e5q3hzFJmgU.html
@adityasrivastava6701
@adityasrivastava6701 8 месяцев назад
how to take file as input
@learning-axis
@learning-axis 8 месяцев назад
you can do it by using
@user-ls7zg7kg1b
@user-ls7zg7kg1b 9 месяцев назад
please do same in google site
@user-rw4xm6qn5w
@user-rw4xm6qn5w 7 месяцев назад
{"result":"success","row":5} - this error i can see after submit with js, and with js, form is not coming after refresh
@learning-axis
@learning-axis 7 месяцев назад
add 2 factor authentication in you Gmail
@user-go5wv9mg5j
@user-go5wv9mg5j 5 месяцев назад
sir please share the script for delete record from google sheet.
@polliosantrophilloes
@polliosantrophilloes Месяц назад
how to upload this?
@SIDDHARTHKALBURGI
@SIDDHARTHKALBURGI Месяц назад
Can we embed this on my landing page
@learning-axis
@learning-axis Месяц назад
yes you can
@user-lb4rx2tg1y
@user-lb4rx2tg1y 9 месяцев назад
Bro why the php file is downloading when i click on submit
@learning-axis
@learning-axis 9 месяцев назад
I provided the code link in description copy the it may resolve your issue
@hirenprajapati1
@hirenprajapati1 6 месяцев назад
cors error occur in console log
@learning-axis
@learning-axis 6 месяцев назад
can you explain more?
@hirenprajapati1
@hirenprajapati1 6 месяцев назад
@@learning-axis cross origin restriction policy error . proxy server needed
@learning-axis
@learning-axis 6 месяцев назад
@@hirenprajapati1 you need to add two step verification to your email
@user-hm8mt3yf4u
@user-hm8mt3yf4u Месяц назад
sir I am getting this : {"result":"error","error":{"name":"Exception"}} help me!!
@Lumina__
@Lumina__ 3 месяца назад
Hi sir can you help me because im having a problem where it shows this error: Thank you in advance {"result":"error","error":{}}
@ferigalung
@ferigalung 5 месяцев назад
I follow along your video and facing an error 302 while sending my formData to app script, with response like this: {"result":"error","error":{}} could you help me? i'll send you more detail if you wish (maybe trough discord or something) thank you
@ferigalung
@ferigalung 5 месяцев назад
nvm i figured it out
@TipsportRalphLauren
@TipsportRalphLauren 5 месяцев назад
how did you fixed it? @@ferigalung
@zeyadbelal9901
@zeyadbelal9901 Месяц назад
@@ferigalung e in dopost is undfiened so i get that error {"result":"error","error":{}} can u help plz ?
@user-lr6gt2vs6c
@user-lr6gt2vs6c 4 месяца назад
11:10 html main kese karna hai
@rishamdeiv8252
@rishamdeiv8252 3 месяца назад
not working, after i submitted the form its appears {"result":"error","error":{}}
@akarshgururaju5073
@akarshgururaju5073 3 месяца назад
Yes i am facing the same problem
@akarshgururaju5073
@akarshgururaju5073 3 месяца назад
Is there any soln to it
@muzamilzaman7463
@muzamilzaman7463 11 месяцев назад
Code isn't flexible
@AndraDeveloper
@AndraDeveloper 11 месяцев назад
how to update data
@learning-axis
@learning-axis 10 месяцев назад
it will auto update
@smokeCup
@smokeCup 9 месяцев назад
How to make image upload from
@learning-axis
@learning-axis 9 месяцев назад
I will create video on that
@user-cl6om1qf9h
@user-cl6om1qf9h 11 месяцев назад
bro you lrean me coading
@nagasatishdoolla
@nagasatishdoolla 11 месяцев назад
Data not coming to data sheet
@learning-axis
@learning-axis 11 месяцев назад
see description I also provided code link
@vansh6759
@vansh6759 10 месяцев назад
bro in js, it is showing an error in 6th line, kindly help me
@learning-axis
@learning-axis 10 месяцев назад
see source code link in description
@vansh6759
@vansh6759 10 месяцев назад
​​@@learning-axisI have tried that many times but it still showing an error
@learning-axis
@learning-axis 10 месяцев назад
@@vansh6759Try it using another gmail ID
@zanport
@zanport 3 месяца назад
It don't work! Don't waste your time!!!
Далее
How to Send HTML Form Data to Gmail Using JavaScript
10:49
Animated Rings | HTML CSS
1:00
Просмотров 4,9 тыс.
Rotating Boxes | HTML CSS
1:00
Просмотров 218
Text Effect | HTML CSS
0:59
Просмотров 10 тыс.
Single Digit Input | HTML CSS
1:00
Просмотров 10 тыс.
Gradial Cursor | HTML CSS JavaScript
0:59
Просмотров 6 тыс.
Center Ball | HTML CSS
0:59
Просмотров 6 тыс.
Background Animation | HTML CSS
1:00
Просмотров 11 тыс.