Can I define a simple trigger from a standalone script?

Question

Specifically, I want to use the onSelectionChange(e) event to show a sidebar depending on what's in the selected cell. The problem is: the project I am working on is a standalone script. So I want to know if there is a way to use the onOpen event (for example) and check if the script is being run from a spreadsheet and somehow 'inject' the trigger.

Do you want to use one editor in particular? (Spreadsheets, Slides, Forms, etc..) — Aerials, Jun 09 '20 at 09:07
I didn't mess with code that much, because I couldn't get the trigger to fire, I thought the problem had more to do with some configuration. Anyway, I posted it in the answer. Thanks a lot for your time and help. — Omar Saucedo, Jun 10 '20 at 16:27

score 1 · Answer 1 · answered Jun 10 '20 at 16:05

I was trying something pretty much like in the documentation, but I never got it to fire, I guess because it was a standalone script.

const onSelectionChange = (e) => {
  Logger.log(`onSelectionChange triggered: ${e.toString()}`);
  const { range } = e;
  if (range.getNumRows() === 1 && range.getNumColumns() === 1) {
    range.setBackground('green');
  }
};

So the actual solution for me was to create a new document with clasp. Using the command:

npx clasp create --type sheets --title "foo" --rootDir ./dist

and then uploading the script to this new project.

Can I define a simple trigger from a standalone script?

1 Answers1