Clear a range by clicking a tick box

Question

I am looking to add a script to clear a range by clicking a tick box. I'm getting the error

TypeError: Cannot read property 'source' of undefined

I added a script found on this website and think I made the necessary adjustments but something is wrong.

Although I'm not sure about your current script and your current Spreadsheet, from your showing error message of `TypeError: Cannot read property 'source' of undefined`, I'm worried that if you want to use the simple trigger of `onEdit` trigger, you might have directly run the function `onEdit(e)` with the script editor. If my understanding is correct, how about checking the checkbox on Spreadsheet? But, if my guess was not correct, I apologize. And, can you show your current script in your question? — Tanaike, Nov 09 '22 at 02:39
Welcome to [so]. It's very likely that you are runing a function that requires a parameter. Please checkout the links shown in the box below the question title. If you need further help, please [edit] the question to all all the relevant details direclty into the question body (code from your script, an a brief description of your spreasheet structure, among other relevant details). — Rubén, Nov 09 '22 at 02:50

0 Answers0