Link Google Script Editor to Google Sheet

Question

I have created a script in 'script editor' called

Clear1

to clear a selected range of cells in a sheet. When the script is run from the 'script editor' it executes and clears the chosen cells.

I have created a google drawing and allowed permissions for the script to affect the sheet, but when I click the drawing I get>

Script function Clear1 could not be found

I cannot link a google drawing to the script.

Script is

function clearRange() 
{
  var Detailed = SpreadsheetApp.getActive().getSheetByName('Detailed');
  Detailed.getRange('G40:G53').clearContent()
}

Any thoughts? What am I missing?

but your script function is clearRange not Clear1 (?)

kaza
– kaza

2017-10-13 16:19:30 +00:00
Commented Oct 13, 2017 at 16:19 — kaza
– kaza, Commented Oct 13, 2017 at 16:19

Wicket · Accepted Answer · 2017-10-13 16:22:11Z

1

Looks that you are using the file name (Clear1) rather than the function name, in other words, instead of Clear1 use clearRange to call the script when you click the drawing.

Reference

Clickable images and drawings in Google Sheets

answered Oct 13, 2017 at 16:22

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Link Google Script Editor to Google Sheet

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related