Return to Answer

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 onformsubmit 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 Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell
• TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

It's very likely that you are running the onformsubmit function from the script editor which don't send an event object (e).

Note: The same happens with any function that use an object as parameter that use an object property, no matter of the property name.

In order to run onformsubmit or any other function that requires an object as parameter from the Google Apps Editor for debugging purposes, you have to create a an auxiliary function to mock the event object and assign the required properties. For a broader explanation see the answer from Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell
• TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

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 Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell

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 onformsubmit 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 Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell
• TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

It's very likely that you are running the onformsubmit function from the script editor which don't send and event object (e).

In order to run onEdit from the Google Apps Editor for debbuging 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 Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell

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 Mogsdad to How can I test a trigger function in GAS?

Related

• How can I get my set values and formulas to populate to a row of values received from a Google Form?
• Running a script from inside a sheet cell