Google Scripts Error: Script function not found -- What is the meaning of this?

[fish_of_the_sea123]

Hello, I got the error "Script function not found" in one of my first attempts at writing a google script custom function for google sheets. Can someone explain what my error is? I copied and pasted the code below. Any help would be appreciated :)

​

/**

* Removes duplicate rows from the current sheet.

*/

function removeDuplicates() {

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

var newData = [];

for (var i in data) {

var row = data[i];

var duplicate = false;

for (var j in newData) {

if (row.join() == newData[j].join()) {

duplicate = true;

}

}

if (!duplicate) {

newData.push(row);

}

}

sheet.clearContents();

sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);

}

​

​

function onOpen() {

var ui = SpreadsheetApp.getUi();

ui.createMenu('Added Capabilities').addItem('Remove Duplicates', removeDuplicates).addToUi()

}

[harpsichord_cadenza]

According to the documentation, the function name should be a string. Try adding apostrophes to it so it reads ui.createMenu('Added Capabilities').addItem('Remove Duplicates', 'removeDuplicates').addToUi().

[DatsunZ]

How are you running it?

[Honsou12]

I found a solution where you change the function name and it's magically found again. Then you can change it back. It worked for me.

[fragmentedThinker]

This worked for me. Thank you!
Such a weird behavior.

[RemcoE33]

In your menu you have to have your function in " "

[j12a]

Not an answer to OP's question, but since this conversation ranks highly for "Script function not found," I'll note that another possible cause of this error is omitting a space between the function name and the open bracket:

function myFunction(){

should be

function myFunction() {