i am having problem running doPost function when i blank data in spreadsheet, in this case "id" is equal to zero. the problem is in the variable "get last id" which is in "getLastRow()-1", after I remove "-1" which means only "getLastRow()", this function runs successfully. whatever it is, this tutorial really enriches my skills with self-taught background knowledge of JSON API. many thanks
It would be the best tutorial of it’s type if you could add search functionality to this. I hope you consider this and extend this tutorial to do so. Thank you 🙏
Hello great videos! My code was working, but now I get this error... "has been blocked by CORS policy: 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." any help??? I dowloaded the cors plugin but then get another error that relates to running html not json script
You are doing great will be waiting for your coming videos. The code shows an error (Paused in debugger, in Line (.then (res => res.json()) ). Will highly appreciate it if you reply.
How could we incorporate something like a PUT or a DELETE request with this. Usually I would make an endpoint that takes an Id but I don't think you can specific endpoints in app scripts, maybe I'm wrong. Could you pass parameters through the doPost and do it this way?
in afterSubmit you were using 'e' for the event variable, but the code from Bootstrap was using 'event' to preventDefault/stopPropagation. might have been causing the validation issue.
you can call it whatever you want in parents afterSubmit(event) . I think if you just add the class "was-validated" to the "form" itself it will validate all fields, but it will also add that annoying green formatting for valid fields, which I don't really like.
Great videos! I've learned a lot from both your channels. One thing I'm confused on, if I wanted to check if the required values were already present on the Google Sheet, how would I do that? With doGet?
Thanks bro I have used loop sending 2d array but it doesn't post all values. example of values, var info = [ {name:"Ahraf",age:40},{name:"sumon",age:36},{name:"Jhone",age:30} ];
Hi, your videos have been very helpful for me. I have really learned a lot in a very short time frame. At 9:30min of this video, you are talking about no-cors in fetch url. When i remove this, my program stops with an error saying i have to put no-cors in the mode. But when i put no-cors, the response received from the app script is blank and therefore i am getting http status as 0. I am using VS code and Live Server on client side to test. When i tested my app script response in Postman, i am getting the correct result. Hope you can help here on how to proceed. Thanks in advance.
Sorry for this confusion.. I just restarted my VS code session and suddenly everything is fine after i remove no-cors in the mode. This is very baffeling.
Hi! Thanks for the videos. The code works nicely on localhost but when I deply it to a web I get: Uncaught (in promise) TypeError: NetworkError when attempting to fetch resource. anyone managed to solve this?
It would be the best tutorial of it’s type if you could add search functionality to this. I hope you consider this and extend this tutorial to do so. Thank you 🙏
i am having problem running doPost function when i blank data in spreadsheet, in this case "id" is equal to zero. the problem is in the variable "get last id" which is in "getLastRow()-1", after I remove "-1" which means only "getLastRow()", this function runs successfully. whatever it is, this tutorial really enriches my skills with self-taught background knowledge of JSON API. many thanks
Excellent! Thanks!
Happy New Year!
It would be the best tutorial of it’s type if you could add search functionality to this. I hope you consider this and extend this tutorial to do so. Thank you 🙏
Excellent! Thanks!
So you have more than one channel interesting.
I love and like it
Please make Cascade drop down by using visual studio, I really need it. Many thanks for all of your amazing videos.????? Still waiting for it.
Hello great videos! My code was working, but now I get this error... "has been blocked by CORS policy: 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." any help??? I dowloaded the cors plugin but then get another error that relates to running html not json script
Please make Cascade drop down by using visual studio, I really need it. Many thanks for all of your amazing videos.
You are doing great will be waiting for your coming videos.
The code shows an error (Paused in debugger, in Line (.then (res => res.json()) ). Will highly appreciate it if you reply.
If anyone wants this combined with a working signature pad, comment here :)
Loved it
Please Provide some tutorial about How to Fetch MySQL Data on Google Sheet
in scriptgoogle I can't load the appsscript.json file when I run "claps push"
How could we incorporate something like a PUT or a DELETE request with this. Usually I would make an endpoint that takes an Id but I don't think you can specific endpoints in app scripts, maybe I'm wrong. Could you pass parameters through the doPost and do it this way?
Yes, you can pass parameters. It's covered in these series ruclips.net/p/PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk
in afterSubmit you were using 'e' for the event variable, but the code from Bootstrap was using 'event' to preventDefault/stopPropagation. might have been causing the validation issue.
you can call it whatever you want in parents afterSubmit(event) .
I think if you just add the class "was-validated" to the "form" itself it will validate all fields, but it will also add that annoying green formatting for valid fields, which I don't really like.
Can I use it in Google sites ?
Great videos! I've learned a lot from both your channels. One thing I'm confused on, if I wanted to check if the required values were already present on the Google Sheet, how would I do that? With doGet?
I was also able to display a similar alert for existing records on the HTML page, check my comments on the answer for the details.
@@russellstanberry8122 Hi Russell! did u figured out how to do that? thanks!
Thanks for all your effort... Im getting this error, what would be the reason "main.js:31 Uncaught (in promise) SyntaxError: Unexpected end of input"
Thanks bro
I have used loop sending 2d array but it doesn't post all values. example of values,
var info = [
{name:"Ahraf",age:40},{name:"sumon",age:36},{name:"Jhone",age:30}
];
Great.
Do you have any series related to VueJS or ReactJS?
I'll be creating ReactJS series soon.
@@getitdonetube
What a Great man!
I am waiting for your series.
Thanks a lot.
Upload the on Github as well.
Hi, your videos have been very helpful for me. I have really learned a lot in a very short time frame. At 9:30min of this video, you are talking about no-cors in fetch url. When i remove this, my program stops with an error saying i have to put no-cors in the mode. But when i put no-cors, the response received from the app script is blank and therefore i am getting http status as 0. I am using VS code and Live Server on client side to test. When i tested my app script response in Postman, i am getting the correct result. Hope you can help here on how to proceed. Thanks in advance.
Sorry for this confusion.. I just restarted my VS code session and suddenly everything is fine after i remove no-cors in the mode. This is very baffeling.
@@AmitabhSaran I am getting the same thing... was working fine, then screwed with it abunch and now I get this error....
Try to give the link of code in description
Hi! Thanks for the videos. The code works nicely on localhost but when I deply it to a web I get: Uncaught (in promise) TypeError: NetworkError when attempting to fetch resource.
anyone managed to solve this?
Make sure you deploy the web app publicly available to everyone.
Hi
source code pls :)
It would be the best tutorial of it’s type if you could add search functionality to this. I hope you consider this and extend this tutorial to do so. Thank you 🙏