🫡🫡🫡🫡 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 🇵🇰
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.
if you want it to work, you should have better understanding of javascript. it'll require something like this: const data = document.querySelector('span #id'); unless you have learn JS it will be more difficult
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!');
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 !!
This is genius work, thank you for sharing! Question, is there a way to make it send an email notification every time a new row is added to the spreadsheet?
what is the best method to secure the sheet and the webapp against attacks? For example, someone simply takes the endpoint and spams it with a script or someone simply takes the sheet ID and edits or looks at the file
Use authentication and authorization to protect endpoints, implement rate limiting to prevent spamming, and secure your API keys and sensitive data. For sheets, restrict access permissions and use tokens for API interactions.
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 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?
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?
I implemented this in nextjs and in a separate project only from html and js and for some reason that I don't know it did not recognize the spreadsheet at any time, it does not allow me to record data. I'm sure I created the script on the same sheet and compared each line. I don't know what it was due to.
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
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
@Learning Axis. Thank you, I followed everything and when I run it, it doesn't bring it over into my spreadsheet. I did use MY spreadsheet link and not yours. I'm not getting any errors, just not getting any results either.
Thanks for your sharing but I have a bug : TypeError: Cannot read properties of null (reading 'getId') when I run the source code Code.gs on Google Apps script. Every one know this bug, please tell me the solution. Thanks you so much.
"It sounds like the code is trying to access an element that doesn’t exist. Make sure that the function `getId` is called on an object that is not `null`. Check if all necessary elements or objects are correctly defined before calling `getId`. If you’re fetching something from a Google service (e.g., Drive or Sheets), confirm that the file or sheet exists and the ID is correct. Let me know if this helps!"
@@learning-axis I've tested it on my website added the scripts to Google script put in the header the name of my sheet Music Requests still not working please help
good video, funny part was 'html dada'
🫡🫡🫡🫡
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
How is it going 😊?
Am I the only one who found IMPOSSIBLE to debug this stuff?? Really crazy.
Same
Amazing! Congratulations! Thanks
I don't know how it works, but it's what I was looking for so much
Good 🙂
thsnk you
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
good job brother
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.
Elegante y muy intuitivo el video felicidades... 🎊🎉
Thank you so much! with the source code, it's so easy and that works!
thank you
Nice video
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
Funciona correctamente.. Muy Bueno. Works Fine!
Glad to hear that! Happy coding!
Thankyou very much! i was struggling with the CORS error. This helped a lot.
Amazing
Thank You! This works.
thank yoy
amazing
This video is so helpful.
How to make it works with instead of ?
it will not work with
if you want it to work, you should have better understanding of javascript. it'll require something like this:
const data = document.querySelector('span #id');
unless you have learn JS it will be more difficult
Thank you very much 👍❤
Gracias, nos salvaste la vida a mi grupo y a mi, eres el mejor.
Thank you
Este vídeo vale oro, estuve buscando vídeo pero esta es la mejor,
Amazing! Thanks,sir..
Amazing tutorial!
Thank you very much!
Great!
Amazing! Thanks
This video is so useful.
I really find this video bro, you made my day 😍, thanks a lot for you make this video for me 🙂
thank you
Good video thanks a lot
Thank you,
Great JOB♥
🥰
That's great, thank You very much!!👍
thank you
Shukriya bhai❤
you welcome
greaaattt
Sir same method aan njn cheythr, but enik submit akumbo something error enna aa msg varunnu
Enthaa cheyya
ASMR Coding - Creating Real Switch Button Animation using HTML and CSS ua-cam.com/video/e5q3hzFJmgU/v-deo.html
thank you so much you give me exactly what i want you are amazing
thank you
Thank you, It's awesome
thank you
Thank you so much
❤❤❤❤❤
Thanks a bunch! It worked well!
Thank you it worked
you welcome
html dada >>>
XD
is your code { in google sheet } work with more input feild or just with 4 input feilds?? i used ur code but >> {"result":"error","error":{}}
yes, It can work just create new field in google sheet and follow the same steps as given in video
you can run this code on local server, and also create account on smtpjs
top!
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!');
how would be the app script if i add another sheet within the same google sheet
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
This is genius work, thank you for sharing! Question, is there a way to make it send an email notification every time a new row is added to the spreadsheet?
You can integrate email by using smtpjs;
I have created video on that,
Video link: ua-cam.com/video/8JBl2Ug7P_E/v-deo.htmlsi=gkVXSV5JJ11ANUn-
Thanks.. I could make small application of change of address for a small NGO without domain and storage.. thank you so much.. god bless you...👃👃
thank you
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?
thank you very much :)
you are the best
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.
didn't worked
create account on smtpjs, and run the code on local server
Thanks bro!
thanks man
{"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
it didn't work for me, says error instead of success
there main be error,
do you run it on local server?
@@learning-axis yes
@@GeniusFranklyn ok, you also need to create account on smtpjs
thank you so much!!
Thank you!
what is the best method to secure the sheet and the webapp against attacks? For example, someone simply takes the endpoint and spams it with a script or someone simply takes the sheet ID and edits or looks at the file
Use authentication and authorization to protect endpoints, implement rate limiting to prevent spamming, and secure your API keys and sensitive data. For sheets, restrict access permissions and use tokens for API interactions.
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"
hello my javascript code seems to not be working, but everything else is okay
It sounds like there might be a small issue in your JavaScript code.
what to do if we want to upload a file as well ? firstly i want to upload the file in drive and than save the file link in sheet
It don't work! Don't waste your time!!!
My data is not working I don't know what happen
there may be error in your code or script,
follow all steps as described in the video
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
Hi, i have a list input (checkbox) and i want to multi choice values. How to do it
thank you ... !!!
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}
Bhai kisme coding kar rhe ho
How can we make the process faster.. it takes 5 secs.. Can we reduce it
i have 3 diffrent form on my html code how do i go about it
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
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?
thanks
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
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).
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
It only works on copy path website only but it doesn't work after hosting how can i solve it
y como envio archivos se puede hacer eso?
I implemented this in nextjs and in a separate project only from html and js and for some reason that I don't know it did not recognize the spreadsheet at any time, it does not allow me to record data. I'm sure I created the script on the same sheet and compared each line. I don't know what it was due to.
I hope you can help me
Bro it does not conduct user input after hosting how can i get user input after host public pls give me answer
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
Can we get copy of this code ???
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
Thank yoooooooooou
@Learning Axis. Thank you, I followed everything and when I run it, it doesn't bring it over into my spreadsheet. I did use MY spreadsheet link and not yours. I'm not getting any errors, just not getting any results either.
are you using local server for this?
@@learning-axis no, it's live on my web server hosted thru godaddy.
hey good job, can we do it for a multiple step form ?
yes you can do it
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?
How I store attachment file as well?
Thanks for your sharing but
I have a bug :
TypeError: Cannot read properties of null (reading 'getId')
when I run the source code Code.gs on Google Apps script. Every one know this bug, please tell me the solution. Thanks you so much.
"It sounds like the code is trying to access an element that doesn’t exist. Make sure that the function `getId` is called on an object that is not `null`. Check if all necessary elements or objects are correctly defined before calling `getId`. If you’re fetching something from a Google service (e.g., Drive or Sheets), confirm that the file or sheet exists and the ID is correct. Let me know if this helps!"
and run it on local server
@@learning-axis Thank you so much 😻
@@binhduong607 you welcome
HOW to With Upload file/image?
Code works and it gives {"Result": "Success" "row 2" }, but as soon Google Sheet.js is added in html "CORS" error is coming. Please help
> are you using local server ? (like xampp or any other).
> You need to create account on smtpjs.
> Add to step verification to you Gmail account.
Can we embed this on my landing page
yes you can
How to add pictures in your form and upload my google drive
Anybody can explain why he code in that another page of Excel site program
7:14
My form submissions aren't going through? Please help
did you run it on local server?
@@learning-axis oh do you have to have a server to run it
@@learning-axis I've tested it on my website added the scripts to Google script put in the header the name of my sheet Music Requests still not working please help
@@coolvibesreloaded7946 yes
@@coolvibesreloaded7946 ok, did you create account on SMTPjs?