No, that's not possible. For running a script in Google Docs I suggest adding a custom menu. Check the documentation on how to do so: developers.google.com/apps-script/guides/menus
Hi. Having the toughest time coming up with a button that will ONLY pull data from a row that is completely filled. I have 7 columns but only want the data if column G is filled. But im stuck!
You would have to add a conditional check to your script that checks if the row in questions has a specific length. So something like if (row.length === 7) and then your code to execute.
I have personally never done so but I know others have. Have a look at this tutorial I found: whatsmate.github.io/2017-04-17-send-whatsapp-group-message-google-apps-script/
I don't think that's possible. I can't find any method in the App Script documentation that would allow you to do something like that. developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app
Yes, that works exactly the same for Google Slides. Check the official guide to find out more about this subject: developers.google.com/apps-script/guides/menus
Hi, just wanted to thank you for this tutorial very useful. Well in my case I already had a button created with an assigned button. It works just fine except on Google sheets Mobile app I have been looking for quite some time a few articles about how to make this button clickable on the google sheets mobile app I figured one way to do it but by using a dropdown list on a cell which is not useful in my case. Do you know perhaps a way to make a button clickable on google sheets mobile app version just by touching the button? (the use of a dropdown make the button itself selected so I am not able to switch on the button to proceed an action on a "selected active range")
I've never created a Google Apps Script to use on the mobile Google Sheets app so I can't speak from experience. I've done some research though and can confirm: you can't get a button to run your code in any of the Google mobile apps. I've also seen some mentioning of that the code won't run at all on mobile apps.
@@saperis Hi! Thanks for the answer, but this tutorial uses onOpen instead of drawings like thiso one. When I try to use an function with an input parameter, it doesn't work.
and how to make it visually clickable?
Hello, is there also a way to assign a script to an equivalent drawing in google docs (not google sheet)
No, that's not possible. For running a script in Google Docs I suggest adding a custom menu. Check the documentation on how to do so: developers.google.com/apps-script/guides/menus
Script not found....
Not found where?
Hi. Having the toughest time coming up with a button that will ONLY pull data from a row that is completely filled. I have 7 columns but only want the data if column G is filled. But im stuck!
You would have to add a conditional check to your script that checks if the row in questions has a specific length. So something like if (row.length === 7) and then your code to execute.
can you mack script for Send messages to many people at once on WhatsApp.
I have personally never done so but I know others have.
Have a look at this tutorial I found: whatsmate.github.io/2017-04-17-send-whatsapp-group-message-google-apps-script/
@saperis How do you disable a text button after one click and then re-enabling through the click of another text button?
I don't think that's possible. I can't find any method in the App Script documentation that would allow you to do something like that.
developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app
Is there a way to do the same in google slides? I mean inserting a button and then assigning a script to it.
Yes, that works exactly the same for Google Slides. Check the official guide to find out more about this subject: developers.google.com/apps-script/guides/menus
I created the script but if Im trying to assign to the button its just doesnt find the function...
You have to manually write in the function name when assigning it to the button.
Hi, just wanted to thank you for this tutorial very useful.
Well in my case I already had a button created with an assigned button. It works just fine except on Google sheets Mobile app
I have been looking for quite some time a few articles about how to make this button clickable on the google sheets mobile app
I figured one way to do it but by using a dropdown list on a cell which is not useful in my case.
Do you know perhaps a way to make a button clickable on google sheets mobile app version just by touching the button?
(the use of a dropdown make the button itself selected so I am not able to switch on the button to proceed an action on a "selected active range")
I've never created a Google Apps Script to use on the mobile Google Sheets app so I can't speak from experience.
I've done some research though and can confirm: you can't get a button to run your code in any of the Google mobile apps.
I've also seen some mentioning of that the code won't run at all on mobile apps.
@@saperis Thank you so much for this time you took to investigate and reply me I appreciate
The title 'How to Create a Button with Google Apps Script' is misleading
What title would be better or clearer?
@@saperis 'How to create a button in Google Sheets trigger a Google App Script'
Thanks for your feedback! 👍
nice friend
Hi, is there a way to assign a script with an input paramenter?
Yes, there is. Check this video to find out more about that: th-cam.com/video/wxLNPrff_II/w-d-xo.html
@@saperis Hi! Thanks for the answer, but this tutorial uses onOpen instead of drawings like thiso one. When I try to use an function with an input parameter, it doesn't work.
Thank you for sharing it was useful
Glad it was helpful! 😀
Hello, Can you make a video on how to send WhatsApp Message from Google Sheets!
Thanks for your request. I'll consider it.
@@saperis i hope i will get that video very soon! :)
Even if I make it, I won't be able to publish it before March 2021.
@@saperis I am glad to hear that you will make a video on it... but whenever you will publish it i will wait!
what about the script
What's with the script?
Thanks for sharing your knowledge!
I learning about script. I couldn't make $(name) be printed with a name on it.
Hi Eduardo. Make sure to use back-ticks (``) and not the normal ticks ('').
So you'll have to write `Nice to meet you {name}`
@@saperis It didn't work with either (‵⸌︑). Well, that's ok. I must get it later on. I appreciate your concern Thanks.