Hi , Thanks for sharing this excellent one. I have a quick question, In this example we are getting data from A1 Cell, suppose if we do get from A1, and B1 Cells. In that case Can we use this data with single successhandler statement or do we have to create the two seperate function in gs code, and need multiple google.run.xxx statement. Please help me out
Hi there, i am newbie to Google app script. Quick question, what is the difference between the functionality of doPost and withSucessHandler? I mean they both can pass data from front-end to back-end. is there any nuance between these two?
withSucessHandler is asynchronous request with java-script while your browser stays on the same page that was rendered by doGet function. Essentially these requests happen on the same server. doPost is needed when you need to pass data from a different server. A good example would be a webhook from a different application that requires a URL to send the post request. As a rule of thumb you should use doPost when you have some sort of integration going on with another third party service sending data to your application.
Sir please help me I have made google spreadsheet with two sheets in it, one is unprotected and anther is protected as data is entered in that sheet after running a script but when I share it with another user I can't be able to protect it for editor tooo
Does google.script.run.withSuccessHandler not work with showModelessDialog? I've tried your script down to the character, but can't get withSuccessHandler() to return any data from the gs function.
@@getitdonetube I'll give that a try. I tried to connect for hours over and over and over with a modelessdialog. I wondered it it's only doable from a dedicated html file.
@@getitdonetube I tried it with just my google account, and I made a single html resource (instead of programming it in gs in line), and I still can't get (iii => {callback("string")}) to return any data. It won't send data back from the gs code.
Weeeeee very nice.
Can't wait your next Video on that topic.
Thank you and happy new Year 🥂🍀
Quite awesome, I was searching about this during the day. Thank you so much.
I wait with impatience for a new video )))
Buen dia Saludos desde Chile, gracias por tu aporte !!!
Excellent!! You've always helped me!!
Perfect!
Hi ,
Thanks for sharing this excellent one.
I have a quick question, In this example we are getting data from A1 Cell, suppose if we do get from A1, and B1 Cells. In that case Can we use this data with single successhandler statement or do we have to create the two seperate function in gs code, and need multiple google.run.xxx statement.
Please help me out
Happy new year teacher, thanks for all the knowledge you share with us...
When to share new video???
Hi there, i am newbie to Google app script. Quick question, what is the difference between the functionality of doPost and withSucessHandler? I mean they both can pass data from front-end to back-end. is there any nuance between these two?
withSucessHandler is asynchronous request with java-script while your browser stays on the same page that was rendered by doGet function. Essentially these requests happen on the same server.
doPost is needed when you need to pass data from a different server. A good example would be a webhook from a different application that requires a URL to send the post request. As a rule of thumb you should use doPost when you have some sort of integration going on with another third party service sending data to your application.
@@getitdonetube Got it ! Millions thanks for the explaination
Sir please help me
I have made google spreadsheet with two sheets in it, one is unprotected and anther is protected as data is entered in that sheet after running a script but when I share it with another user I can't be able to protect it for editor tooo
Excellent.
helps a lot, thanks!
👍
from a bound file is it possible to invoke a function living in a standalone file?
developers.google.com/apps-script/api/how-tos/execute
"This application was created by another user, not by Google".
Is there an way to remove this message?
Paid account or embed as .
this msg shown when someone is not logged in via google account
Does google.script.run.withSuccessHandler not work with showModelessDialog? I've tried your script down to the character, but can't get withSuccessHandler() to return any data from the gs function.
It should work just fine.
If you have multiple accounts I suggest logging out of all of them and try again after logging in to the right account.
@@getitdonetube I'll give that a try. I tried to connect for hours over and over and over with a modelessdialog. I wondered it it's only doable from a dedicated html file.
@@getitdonetube I tried it with just my google account, and I made a single html resource (instead of programming it in gs in line), and I still can't get (iii => {callback("string")}) to return any data. It won't send data back from the gs code.
I mean (iii => {callback(iii)})
What error do you get in console.logs?