Google Sheets | How To Send HTML Form Data To Google Sheets
Vložit
- čas přidán 23. 06. 2023
- #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.
good video, funny part was 'html dada'
Amazing! Congratulations! Thanks
this actually worked great! was a bit sus of the permissions shenanigans, but it's probably fine. thanks so much!
Thank you so much for everything! God bless you and give back double for your contribution and sharing this solution with us! Grateful 🤝🏼
thank you
🫡🫡🫡🫡
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 🇵🇰
Thank you bro.
INDIA jindabaaadd
Thankyou very much! i was struggling with the CORS error. This helped a lot.
Este vídeo vale oro, estuve buscando vídeo pero esta es la mejor,
Amazing
Thank you, bro. Your tutorial is very useful. keep it up!
thank you
Amazing! Thanks,sir..
Nice video
Thanks a bunch! It worked well!
good job brother
Great!
amazing
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❤❤
Thank you
Amazing! Thanks
I really find this video bro, you made my day 😍, thanks a lot for you make this video for me 🙂
thank you
Thank you very much 👍❤
This video is so useful.
Thank you so much! with the source code, it's so easy and that works!
thank you
Am I the only one who found IMPOSSIBLE to debug this stuff?? Really crazy.
Good video thanks a lot
Gracias, nos salvaste la vida a mi grupo y a mi, eres el mejor.
Thank you
how would be the app script if i add another sheet within the same google sheet
I don't know how it works, but it's what I was looking for so much
That's great, thank You very much!!👍
thank you
greaaattt
Sir same method aan njn cheythr, but enik submit akumbo something error enna aa msg varunnu
Enthaa cheyya
top!
thank you very much :)
Thank you so much
Hi, i have a list input (checkbox) and i want to multi choice values. How to do it
thank you so much you give me exactly what i want you are amazing
thank you
Thank You! This works.
thank yoy
thank you so much!!
Thanks bro!
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 !!
Same problem
Thank you!
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.
Thank you, It's awesome
thank you
thanks man
thank you ... !!!
i have 3 diffrent form on my html code how do i go about it
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.
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!');
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?
you can do these things using node js
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
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
y como envio archivos se puede hacer eso?
thanks
Thank yoooooooooou
How I store attachment file as well?
Anybody can explain why he code in that another page of Excel site program
7:14
Thanks beautiful project, how can I do to add a column with date and time added automatically to each submit?
You can fetch time in JavaScript, forward it into the new input tag's value, and then to google sheets.
How can we make the process faster.. it takes 5 secs.. Can we reduce it
html dada >>>
XD
how do you add a 'upload file', add an image from files and then receive and open it on google sheets?
we can't receive image file in google sheets
So where can I send the file to open it?
Bhai kisme coding kar rhe ho
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)?
just create a file named as sheet.js in any folder
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
Can we get copy of this code ???
i want it to send it in exel app is it possible?
you are the best
sir ham na form ma photo be lagai ha photo ko google sheet ma kase save kare ga ya bata da thank you!
Hi, everything works perfectly. I want to know how do I redirect to another link once the form is submitted? Thanks in advance
Replace (window. location.reload.) with (window. location.href="link";)
@@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
@@antoniosh8130 add twostep verification to you Gmail and create account on smtpjs
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.
did you create account on smtpjs.
and also add two step verification to your gmail
@@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.
@@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?
@@CamiloR1997 yeah "contact@learning-axis.com"
I did everything listed in this video but it didn't work. Why does it keep showing me error with empty {}
I also provided the code link in description please use that code
You do know that font-family and font-size is inherited properties right? So why use it on the universal selector?
Some properties like font-size, and font-family are inherited from the parent when the element has no value specified in itself
@@learning-axis Hlo bro, I need a website, I will give money when the website complete. How to contact you 🤔 plz replay me
contact me on: blakdeer31@gmail.com
@@mk.bigboss122 sure
They aren’t inherited by default on inputs. You have to set input {font: inherit}
hey good job, can we do it for a multiple step form ?
yes you can do it
How to add pictures in your form and upload my google drive
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?
are you using local server?
HOW to With Upload file/image?
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
you should also add "reload page function" on submit button
thank you so much.i have resolved@@learning-axis
Why submit button is not working to send data materials to google sheets ? @Learning Axis
see code link in description, that may help you
sir please share the script for delete record from google sheet.
please do same in google site
I am having cors error
Does anyone know how to fix it
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).
ASMR Coding - Creating Real Switch Button Animation using HTML and CSS czcams.com/video/e5q3hzFJmgU/video.html
{"result":"success","row":5} - this error i can see after submit with js, and with js, form is not coming after refresh
add 2 factor authentication in you Gmail
I've copied your codes and done everything in your video. I get this error: "Script function not found: doGet"
do you add script in google sheets?
It gives me the "Result": "Success" "row 2" message but doesn't actually add onto the google sheets. What's the problem?
check the names of inputs.
check the name of the sheet you put in the app script.
@@learning-axis cool i got it working! Thanks
facing same issue what was the issue?
@@azharahmed7928 check the names of inputs.
check the name of the sheet you put in the app script.
What app did you use to code? Im not very familiar sorry
sublime text
How about adding new column in google sheet,?
What is the code?
how to upload this?
Bro why the php file is downloading when i click on submit
I provided the code link in description copy the it may resolve your issue
sir I am getting this : {"result":"error","error":{"name":"Exception"}}
help me!!
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
nvm i figured it out
how did you fixed it?
@@ferigalung
@@ferigalung e in dopost is undfiened so i get that error {"result":"error","error":{}} can u help plz ?
how to take file as input
you can do it by using
{"result":"error","error":{}}
Iam getting this error after submitting the form can you please tell me where to correct
create account on smtpjs and add two step verification to you Gmail account
Can we embed this on my landing page
yes you can
Hi sir can you help me because im having a problem where it shows this error:
Thank you in advance
{"result":"error","error":{}}
sir mere me to submit btn pr click kar ke redirect ho raha hai muje vo disable karna kese karu
redirection wala function hata doo
cors error occur in console log
can you explain more?
@@learning-axis cross origin restriction policy error . proxy server needed
@@hirenprajapati1 you need to add two step verification to your email
not working, after i submitted the form its appears {"result":"error","error":{}}
Yes i am facing the same problem
Is there any soln to it
11:10 html main kese karna hai
how to update data
it will auto update
Code isn't flexible
Data not coming to data sheet
see description I also provided code link
bro you lrean me coading
How to make image upload from
I will create video on that
bro in js, it is showing an error in 6th line, kindly help me
see source code link in description
@@learning-axisI have tried that many times but it still showing an error
@@vansh6759Try it using another gmail ID