🫡🫡🫡🫡 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.
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?
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!');
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?
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 !!
Hi, Thank you so much for your efforts. I am follwing same but getting CORS error. Could you please guide me how to resolve this error. from origin 'null' 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.
@@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
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?
wow!!!! THANK YOU SO MUCH! I have been dabbling with HTML by editing a template from HTML5UP, the template has a form section, but I couldn't figure out for the longest time how to actually make it functional. I wasn;t sure if this would actually help, since I'm not building from scratch like in the video, but wow!! it worked right away :) incredible
You're very welcome! I'm thrilled it worked for you and helped make your form functional-great job customizing the template! Keep experimenting and building!
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.
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.
@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.
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
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)?
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!"
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
Thank You! This works.
thank yoy
Code not working wrote in googke sheet ... doPost error
visit this link to get source code : learning-axis.com/projects/google-sheets/
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
That's great, thank You very much!!👍
thank you
Amazing! Congratulations! Thanks
Thank you so much! with the source code, it's so easy and that works!
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.
Elegante y muy intuitivo el video felicidades... 🎊🎉
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"
Awsome. Thanks!
you welcome
this actually worked great! was a bit sus of the permissions shenanigans, but it's probably fine. thanks so much!
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 👍❤
Amazing tutorial!
Thank you very much!
I don't know how it works, but it's what I was looking for so much
Thank you,
Great JOB♥
🥰
good job brother
Funciona correctamente.. Muy Bueno. Works Fine!
Glad to hear that! Happy coding!
thank you :)
you welcome
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! Thanks
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?
how would be the app script if i add another sheet within the same google sheet
I really find this video bro, you made my day 😍, thanks a lot for you make this video for me 🙂
thank you
Gracias, nos salvaste la vida a mi grupo y a mi, eres el mejor.
Thank you
Sir same method aan njn cheythr, but enik submit akumbo something error enna aa msg varunnu
Enthaa cheyya
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!');
Amazing! Thanks,sir..
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-
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
No music
yes
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
This video is so useful.
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
Hi, Thank you so much for your efforts. I am follwing same but getting CORS error. Could you please guide me how to resolve this error.
from origin 'null' 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.
Visit this link to see guide and get source code, this may help you. Thank you!
learning-axis.com/projects/google-sheets/
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.
Good video thanks a lot
Thank you it worked
you welcome
Thanks a bunch! It worked well!
Shukriya bhai❤
you welcome
you are the best
thank you so much you give me exactly what i want you are amazing
thank you
Thank you, It's awesome
thank you
Good 🙂
thsnk you
It don't work! Don't waste your time!!!
is there anyone to help
visit this link to get source code : learning-axis.com/projects/google-sheets/
How can we make the process faster.. it takes 5 secs.. Can we reduce it
Great!
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?
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.
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
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
Bhai kisme coding kar rhe ho
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
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?
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.
Amazing
Nice video
amazing
greaaattt
wow!!!! THANK YOU SO MUCH! I have been dabbling with HTML by editing a template from HTML5UP, the template has a form section, but I couldn't figure out for the longest time how to actually make it functional. I wasn;t sure if this would actually help, since I'm not building from scratch like in the video, but wow!! it worked right away :) incredible
You're very welcome! I'm thrilled it worked for you and helped make your form functional-great job customizing the template! Keep experimenting and building!
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
{"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
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
thanks man
You Welcome
Thank you!
Thank you so much
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.
hey good job, can we do it for a multiple step form ?
yes you can do it
i have 3 diffrent form on my html code how do i go about it
thank you very much :)
Can we get copy of this 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).
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
Hi, i have a list input (checkbox) and i want to multi choice values. How to do it
Bro it does not conduct user input after hosting how can i get user input after host public pls give me answer
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}
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
Can we embed this on my landing page
yes you can
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
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
❤❤❤❤❤
thank you so much!!
Anybody can explain why he code in that another page of Excel site program
7:14
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?
html dada >>>
XD
@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.
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
It only works on copy path website only but it doesn't work after hosting how can i solve it
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
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
Why submit button is not working to send data materials to google sheets ? @Learning Axis
see code link in description, that may help you
didn't worked
create account on smtpjs, and run the code on local server
top!
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?
Thanks bro!