Based on an google sheet containing 3 columns :

I am a complete beginner and that is why I used an almost ready solution. However, the subsequent changes were beyond me

When I try and get a form response from onFormSubmit(e), it returns {"authMode":"FULL","response":{},"source":{},"triggerUid":"604XXXXX"}, which does not include the values property. It seems like I am missing a scope but I dont know which one.

I have a script that runs on Google Forms. It is to look for multiple choice grids and transform them to multiple choice questions if rows or columns are > 3.

I’m currently making an order form for some apparel for my church group.
I decided to use Google Forms for this.
You can order a shirt (20€) and/or a hoodie (50€). Then there will be a 20€ discount.
I would like to display the total at the end of the form, but I can’t figure out how.

First post for me.

The script I am using iterates through the form questions, gets the item type, and builds a response based on the expected item response type. But the Email question presented to the end user in the form when it’s set to Responder Input does not appear in the returned list of items when I call form.getItems(). So I don’t know how to include the responder’s email in the form response I send to the API.

I have a form that starts with one multiple choice item that, based on each answer chosen, will go to a specific page for them to fill out a griditem.

It’s been a while since I’ve posted anything, so bear with me please! I’ve successfully loaded dropdown options from google sheets into google forms. I’m using a trigger to update the form anytime the data in the sheet is changed (i.e. a new name is added to the list). The problem is that the “Go to section based on answer” choice is erased every time the update occurs. How can I implement this into my code? I’ve initialized the variable “goTo” to represent the section I’ll assign to each choice in the dropdown (this will be achieved with a select statement).

I am needing to send emails via Appscript to different people based on different conditions that were selected from one particular question on a google form. E.G. All EBO selections sent to email addy 1, all non-EBO selections sent to email addy 2, and then all selections sent to email addy 3. Below is what I have, but no matter what option is selected on the form, it only sends the email per the first if statement.