How to Create a Button for Google Apps Script

Thank you for sharing it was useful

[@saperis]

Glad it was helpful! 😀

[@rubisonsfilm1813]

nice friend

[@EduardoBicelisGarcia]

Thanks for sharing your knowledge!

[@EduardoBicelisGarcia]

I learning about script. I couldn't make $(name) be printed with a name on it.

[@saperis]

Hi Eduardo. Make sure to use back-ticks (``) and not the normal ticks (''). So you'll have to write `Nice to meet you {name}`

[@EduardoBicelisGarcia]

@@saperis It didn't work with either (‵⸌︑). Well, that's ok. I must get it later on. I appreciate your concern Thanks.

[@seandennis4822]

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!

[@saperis]

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.

[@dmitrykresin]

and how to make it visually clickable?

[@KaitlynnHolland]

@saperis How do you disable a text button after one click and then re-enabling through the click of another text button?

[@saperis]

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

[@austrianflying]

Hello, is there also a way to assign a script to an equivalent drawing in google docs (not google sheet)

[@saperis]

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

[@mindvsyou9859]

Is there a way to do the same in google slides? I mean inserting a button and then assigning a script to it.

[@saperis]

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

[@tulioh.r.r.7768]

Hi, is there a way to assign a script with an input paramenter?

[@saperis]

Yes, there is. Check this video to find out more about that: kzbin.info/www/bejne/ramvf4Oom8uSf6s

[@tulioh.r.r.7768]

@@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.

[@TaiKHUN-zg8vl]

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")

[@saperis]

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.

[@TaiKHUN-zg8vl]

@@saperis Thank you so much for this time you took to investigate and reply me I appreciate

[@balazsalmos8684]

I created the script but if Im trying to assign to the button its just doesnt find the function...

[@saperis]

You have to manually write in the function name when assigning it to the button.

[@tootricks]

can you mack script for Send messages to many people at once on WhatsApp.

[@saperis]

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/

[@MK-jn9uu]

what about the script

[@saperis]

What's with the script?

[@arany5123]

Script not found....

[@saperis]

Not found where?

[@gulshanchand7260]

Hello, Can you make a video on how to send WhatsApp Message from Google Sheets!

[@saperis]

Thanks for your request. I'll consider it.

[@gulshanchand7260]

@@saperis i hope i will get that video very soon! :)

[@saperis]

Even if I make it, I won't be able to publish it before March 2021.

[@gulshanchand7260]

@@saperis I am glad to hear that you will make a video on it... but whenever you will publish it i will wait!

[@deFunkyMofo]

The title 'How to Create a Button with Google Apps Script' is misleading

[@saperis]

What title would be better or clearer?

[@deFunkyMofo]

@@saperis 'How to create a button in Google Sheets trigger a Google App Script'

[@saperis]

Thanks for your feedback! 👍