SCRIPT DIFFERENT when run from BUTTON or SCRIPTEDITOR

Question

So I made a simple script that duplicates two columns basically. When I run it from the scripteditor I get the correct result, but when I apply this script to a button suddenly it's broken...

Running script

this is the code:

function DuplicateSelectedRows() {
  var spreadsheet = SpreadsheetApp.getActive();

  //Insert rows 
  spreadsheet.getActiveSheet().insertColumns("4");
  spreadsheet.getActiveSheet().insertColumns("4");
  
  // merge cells top
  spreadsheet.getRange('D2:E2').activate()
  .mergeAcross();
  spreadsheet.getRange('D3:E3').activate()
  .mergeAcross();
  
  //paste values in newly created rows
  spreadsheet.getRange('B4:C20').copyTo(spreadsheet.getRange("D4:E20"));
  spreadsheet.getRange('B3:C3').copyTo(spreadsheet.getRange("D3:E3"));
  spreadsheet.getRange('B2:C2').copyTo(spreadsheet.getRange("D2:E2"));
  
  // clear data new training
  spreadsheet.getRange('B5:C20').clearContent();
};

James D · Accepted Answer · 2019-12-14 19:01:37Z

3

In your script editor, you are running the script 'DuplicateSelectedRows' but on your button, you are running the script 'NewTraining'

answered Dec 14, 2019 at 19:01

James D

3,1501 gold badge14 silver badges22 bronze badges

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

Comments

Andres Duarte · Accepted Answer · 2019-12-16 09:38:00Z

0

Although it says "Assign script" what you actually need to put is the name of the Apps Script function you want to link to the image [1], in this case you have to put 'DuplicateSelectedRows'.

[1] https://developers.google.com/apps-script/guides/menus#clickable_images_and_drawings_in_google_sheets

answered Dec 16, 2019 at 9:38

Andres Duarte

3,3601 gold badge9 silver badges14 bronze badges

Collectives™ on Stack Overflow

SCRIPT DIFFERENT when run from BUTTON or SCRIPTEDITOR

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related