1

I am a newbie and my Google App Script stopped working and getting this error. Here is the line:

function onEditCustom(e) {

if (['TRUE', 'FALSE'].indexOf(e.value) === -1 || e.range.getColumn() !== 9 || e.range.getSheet().getName() !== SHEET_NAME) {
    return;
}
Rubén
  • 34,714
  • 9
  • 70
  • 166
  • It appears this is an installed on edit trigger, not the simple trigger onEdit(e). How are you capturing the error message? Logger.log? – TheWizEd Dec 18 '18 at 18:10
  • App script is sending me a type error. Here is the full code. – user10807478 Dec 18 '18 at 18:17
  • You can edit your original post to show the full code. – TheWizEd Dec 18 '18 at 18:28
  • If you mean your are running from script editor that won't work because e is undefined. e is the event object containing information about which cell the user edited. – TheWizEd Dec 18 '18 at 18:49
  • The error means that one of your values, with a property key of `value` is undefined and is returning no element. Make sure that all elements exist in your index. Check this [link](https://github.com/algolia/autocomplete.js/issues/233) for reference. – abielita Dec 19 '18 at 16:09

0 Answers0