Event Object For Form Submit On Google Apps Script Not Working

I am trying to learn Google App Scripts. I have a form with one question. Then I created a new spreadsheet for the responses. Then from the form I went to the script editor. I inst

Solution 1:

In fact, Bayani, I think the trigger works from both. The thing is when the trigger is in the form, the triggered function tries to read the spreadsheet too soon, before Google Forms service update it with the submitted data of the form. (Sorry for adding a new answer, but my reputation score doesn't allow me to add comments yet - And very sorry because when I was writing this answer I accidentally clicked in your answer for editing and changed an "from" to an "in": please, just reject my edit).

Solution 2:

I figured it out. When you create scripts for the form and the associated spreadsheet, you can do it from both. But if you create it in the form, the event object won't work with the spreadsheet. But if you create it from the spreadsheet, you can still use the form submit trigger. But this time the event object will work.