0

I have the same function which is called by several events (response to forms in the same sheet following a new entry on one of the forms), and I would like to know which sheet (the form) triggered the event.

I arrive well in the function, but I cannot find the argument which gives me the info of the source (sheet) of triggering

Rubén
  • 34,714
  • 9
  • 70
  • 166
Cyril ACHARD
  • 1

1 Answers1

0

Let say you have an installed trigger on form submit.

function onFormSubmit(e) {
  let sheet = e.range.getSheet();
}

sheet will be the sheet object of the sheet that triggered the event.

Refercence

TheWizEd
  • 7,517
  • 2
  • 11
  • 19