onEdit search function help

[Music Man]

Hello!

I would GREATLY appreciate anyone's help, and happy to provide more information if needed.  I am new to this community AND new to writing scripts, so struggling to figure out the following:

I have created a google sheet that contains a form, an in order to automate said form I have been following a guide on YouTube to setup the background script.  One function that he put in his form was a search function, which I have copied word for word as I have the rest of his script which all worked.  Below is what I have written in the onEdit(e) script that he says to create:

function onEdit(e) {

  if(e.range.getA1Notation() !== "H3") return

  if(e.source.getSheetName() !== "Form") return

  search()  

}

H3 refers to the merged cells where you type your items you're searching for

and here is the error I receive:

1:55:23 PM

Error

TypeError: Cannot read properties of undefined (reading 'range')

onEdit

@ onEdit.gs:2 Any ideas? ... MANY thanks in advance!

[Keith Andersen]

Try:

function onEdit(e) {

let range = e.range;

let spreadSheet = e.source;

  if(e.range.getA1Notation() !== "H3") return

  if(e.spreadSheet.getSheetName() !== "Form") return

  search()  

}

Paying particular attention to exact spelling.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/78ba70df-b701-48fe-907f-3a1e2d1f59afn%40googlegroups.com.

[Emerson Maia]

O erro em seu código do Google Apps Script, o problema está relacionado ao objeto e que é passado para a função onEdit. Quando uma célula é editada, o Google Apps Script automaticamente passa um objeto de evento (e) para a função onEdit. Este objeto contém informações sobre a edição, incluindo o intervalo que foi editado (e.range) e a planilha onde ocorreu a edição (e.source).

O erro TypeError: Cannot read properties of undefined (reading 'range') indica que o objeto e não tem uma propriedade range. Isso geralmente acontece quando a função onEdit é executada manualmente no editor de scripts, pois nesse caso, nenhum objeto de evento é passado automaticamente.

--

[Keith Andersen]

As our Spanish speaking friend pointed out - if you are calling this function from the editor it will give you that error also.

Do you get an error when you run it in the actual spreadsheet?  When you actually edit the cell in the spreadsheet, do you get any type of error?.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CADH-QrD_96RC_agT4Zd5Qc1%2Burdx%2B2w%2BinqDNnm7bXaA5h2UuA%40mail.gmail.com.

[Music Man]

Emerson & Keith ... I cannot THANK you enough ... your suggestions worked!  Thank you for taking the time to help me with this!

Blessings!

[Keith Andersen]

👍👍

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/acba756b-d116-4153-8b18-3232626e6e33n%40googlegroups.com.