Help Please - Google App Script Trigger isn't working

[DoverSeed Google Workspace Admin]

Hello!  

I am new to using Google App Script and have spent the better part of the day trying to get what I thought would be a simple script working. :(

Scenario: I have a Squarespace form configured to store submissions in a Google Sheet on the submit button.  I went into the Google Sheet, went to Extensions and added a Google script to send an acknowledgement email upon submission of the Squarespace form.  Additionally, I setup a Trigger for 'onformsubmit'.  Below are screenshots of the error that I'm receiving and the trigger setup.

Problem:  Google Sheet is getting updated as expected (see screenshot below) but I am not receiving the acknowledgement email as expected.  I'm receiving the following error:

TypeError: Cannot read properties of undefined (reading 'namedValues')

onFormSubmit

@ Code.gs:3

If anyone has experienced this issue and can help me I would greatly appreciate it!

Thanks in advance for your help!

Denise

[Ed Sambuco]

You need to trigger the email from the spreadsheet, not the formsubmit.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/619e932f-d95c-4cde-a749-611d85301c56n%40googlegroups.com.

[DoverSeed Google Workspace Admin]

Good morning, Ed,

Thank you for your response.  Are you saying the script itself is ok and that I just need to change the Trigger setup?  When I attempt to change the trigger setup for which function to run, the only option is OnFormSubmit.  When I try to change "select event type" my options include the following:

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/8yjMlb8P8MU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAANZsGNDdkto%2Bt8JYMLFE%2BsNkcai-C8%3DSpfk%2BGO%3Dd1ijD3nJ3g%40mail.gmail.com.

[Ed Sambuco]

No. The email should come from a second trigger script bound to the spreadsheet.  Use values from the new spreadsheet to populate the email.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJSLcAOQPmukAfzdtr%3DufZnd%2B_GPQkWiC5BmfSAgmVKuDapRsg%40mail.gmail.com.

[Ed Sambuco]

Sorry for delayI am dealing with sick relatives and have been distracted.

Not sure if I gave the best answer, but you have to be careful about the event object.  Nanedvalues is not an event object field from a spreadsheet.  You are specifying the spreadsheet as the starting event to kick off the email. 

My lapto is currently in bad shape so I can’ check this out.  Try changing starting event in the onformsubmit trigger.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJSLcAOQPmukAfzdtr%3DufZnd%2B_GPQkWiC5BmfSAgmVKuDapRsg%40mail.gmail.com.

[DoverSeed Google Workspace Admin]

Thanks Ed.  I'm sorry to hear about your relatives.  I hope they get better soon!  

I have decided to change my approach and use a time driven function which I did get to work, so I'm all set for now.

Take care, 

Denise

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAANZsGPiRX9dAEPV06n0iEWWBSD%2B0GTdDROEYiFpuPOwQtPCBg%40mail.gmail.com.