Google Sheets Button to Run Script: How to Create

Google Sheets Button to Run Script: How to Create

Code With Curt

4 года назад

161,631 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Alysha McPeak
Alysha McPeak - 28.10.2023 01:42

could you assist with a code that is not reading my getRange?

Ответить
Brendon_a1
Brendon_a1 - 26.10.2023 20:32

in tools why dont i have a script editor option?

Ответить
Khaziva Noora Vlog
Khaziva Noora Vlog - 23.10.2023 09:33

I'm Just learning how to use script on my google sheet but why my script function could not be found? after I made the script.. thanks in advances for you kind help

Ответить
Jairo Martínez Pérez
Jairo Martínez Pérez - 12.09.2023 01:07

How can I create the rectangle with code?

Ответить
rbfreitas
rbfreitas - 31.08.2023 20:15

Thanks for the video

Ответить
Monday
Monday - 06.08.2023 22:16

if I share my spreadsheet as a url with other people do they see the button on the web site too? or do they have to be logged into there Google spreadsheet app to see it?

Ответить
Bruce Thomson
Bruce Thomson - 03.07.2023 06:15

How about other controls - e.g. a slider bar? A drop-down box of option? Possible?

Ответить
Robenson Cesar
Robenson Cesar - 20.04.2023 21:47

Why aren’t buttons clickable on phone.

Ответить
Super Sausage
Super Sausage - 16.04.2023 08:54

Ey bruv, how can i do this with a random number generator?

Ответить
Loryders
Loryders - 14.04.2023 10:31

ahh no one says how to get "script editor" to appear under the tools menu

Ответить
Panji Wicaksono
Panji Wicaksono - 19.02.2023 14:07

Why can I not find the Script Editor option under tools?

Ответить
DrGenocide
DrGenocide - 19.02.2023 00:45

how to make this button clear specific cells?

Ответить
Angel X
Angel X - 04.02.2023 10:17

I keep getting the error "Message details Exception: The number of columns in the data does not match the number of columns in the range. The data has 4 but the range has 3."

Ответить
Ivan Urbina
Ivan Urbina - 15.12.2022 19:31

Thanks for the tutorial

Ответить
Feroze Hakeem
Feroze Hakeem - 13.12.2022 12:45

Hi brother🖐🏼

Pls do get me a script to minus one (-1) from the value of the cell🙌🏼💯

Ответить
Felman Joy Ledesma
Felman Joy Ledesma - 13.11.2022 17:00

Can we assign script that shows signature (image) in assigned row?, Thank you sir! Im new

Ответить
Carlo Matig-a
Carlo Matig-a - 21.09.2022 08:57

Thanks for this! Very helpful

Ответить
Colleen Vanderboom
Colleen Vanderboom - 20.09.2022 17:40

Hi Kurt! I always love your tutorials. Right now what I am trying to do is cover up a sheet with a drawing and Only unhide the drawing if the user has the correct password as the drawing is covering up confidential information. I'm wondering if there is a way that I could do an IF function to hide the drawing if the user puts the correct password in the only cell that is visible above the image showing. Does that make any sense?

Ответить
Sound Peaks
Sound Peaks - 16.09.2022 18:56

For fucking god sake THANK YOU, google you are fucking piece of shit

Ответить
Ana Rosalin Teleg
Ana Rosalin Teleg - 06.09.2022 15:40

Hi I can't see any Script editor under the tool button on my Gsheet, what should I do to activate it?

Ответить
Channelku
Channelku - 02.09.2022 10:55

im always show script not found, any sugestion?

Ответить
K N
K N - 23.08.2022 22:35

This is great, is there a program to duplicate sheets with same format?

Ответить
Crystal Graham
Crystal Graham - 22.08.2022 18:58

Hi there! This was very helpful for a newbie like me. Would you mind providing a real world example of how this can be used? What can I do with this knowledge? :)

Ответить
fancylad2006
fancylad2006 - 04.08.2022 05:53

Great Video! Thank you! 😀

Ответить
EVANDERS MULTIMEDIA
EVANDERS MULTIMEDIA - 10.07.2022 21:20

I watched this video to create a button however is not working on phone and that’s what I need most… can you help me ?

Ответить
Bull Merchant
Bull Merchant - 24.05.2022 06:20

for stop scrip what to do

Ответить
Zillyaa
Zillyaa - 07.04.2022 13:13

Hi Curt,
is it possible to make multiple bottons that attach hyperlinks generated by vlookup?

Ответить
Pavel Hodosevich(פבל חודוסביץ')
Pavel Hodosevich(פבל חודוסביץ') - 31.03.2022 12:06

thank you very very much!!!!

Ответить
Bombay Bloke
Bombay Bloke - 22.02.2022 12:18

i need to allow users to write to my sheet through a script but users should not be able to view/open the sheet manually.
the script needs to capture current user email.
is this possible ?

Ответить
Nate Dogg
Nate Dogg - 17.02.2022 23:48

Thank you so much! It works

Ответить
Bombay Bloke
Bombay Bloke - 03.02.2022 19:58

there is no 'Script Editor' in my 'Tools'

Ответить
Hector Antonio Tafoya Garcia
Hector Antonio Tafoya Garcia - 05.01.2022 22:43

Thanks, apparently in new Google Sheets version you need to open Macros to see the scripts.

Ответить
Ido Jacoby
Ido Jacoby - 28.12.2021 15:04

Hi Curt.
Nice!
Can you show how do to add a new line with a button?
Can you show how to add an auto "last modifide date" to a cell next to a cell I just modifide?

Ответить
Akier Skan
Akier Skan - 28.12.2021 11:19

Hi, does anyone know how to save this excel and upload it again with the script working? It seems that everytime I download the sheet, the script automation disappears and I have to redo it again?

Ответить
Germain Charlie
Germain Charlie - 07.12.2021 09:36

Your video is not the best, concise and easy to understand

Ответить
Alejandro Rios
Alejandro Rios - 02.12.2021 06:23

Thank you so much for sharing!!!! Best regards from Panama 🇵🇦

Ответить
Lenile Pupa
Lenile Pupa - 22.11.2021 04:21

BEST VIDEO OF THE YEAR You just change my life ! THANK YOU SO MUCH

Ответить
Comet Polyplast
Comet Polyplast - 18.11.2021 16:03

I AM ADD A BUTTON IN GOOGLE SHEET BUT I AM OPRET BY MOBAIL PHONE, BUTTON DOES NOT ACCEPT COMMAND PLCE HALP ME

Ответить
Giorgio
Giorgio - 24.08.2021 21:15

I'm at an impasse here. No matter what I try I get the same error "Script function sortClient could not be found" No matter what I name my function and reassign the button, it doesn't resolve. Refreshing doesn't work. I'm making sure to name it verbatim after the function and not the project (even tried renaming the project after the button). Here's my first line of code (without the quotations) "function sortClient(){"

Any insights you have would be appreciated, thanks for the vid!

Ответить
Hickory Sonoco
Hickory Sonoco - 10.08.2021 22:31

Does anyone know how to get this working on an Ipad? Does a stylus work? A mouse? Using finger to touch does not work.

Ответить