1

How to Fix your problem Manually install the onFormSubmit trigger. When installing the Trigger, under "Choose which function to run", choose the function onFormSubmit (the trigger event argument () isn't shown when creating the trigger. There should only be one onformSubmit trigger, and only function executed by the trigger. If you find that the function ...


1

It's very likely that you are running the onformsubmit function from the script editor which don't send an event object (e). In order to run osformsubmit from the Google Apps Editor for debugging purposes, you have to create a an auxiliary function to create the event object and assign the required properties. For a broader explanation see the answer from ...


1

You have declared variables for Sheet Names however all your output is directed to one sheet ("Paper Change") and not to both sheets as one might expect. The cause of this is that the variable ss has been declared twice (once as SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Refills"); and again as SpreadsheetApp.getActiveSpreadsheet().getSheetByName(...


Only top voted, non community-wiki answers of a minimum length are eligible