Part 4: How do I edit the script? - Important information about Google Forms

Tell Me

When you make a Google form, Google automatically creates a Google sheet (defaultly titled Form Responses 1) to house data given by the form (questions asked and responses given).
- This Google sheet is connected to the sheet you used to create the Google form.
- To access it, open the sheet used to create the Google form and select Form Responses 1 from the tabs at the bottom of the screen.
- Each question automatically gets its own column. The question itself appears in the first row of each column and answers given in the form for that question populate the rest of the rows. Timestamp is by default column A, and each question populates the rest of the columns (Question 1 = column B, and so on). Each row across the sheet indicates one person’s answers for every question.

- The Form Response Sheet is where data populating the generated Google doc is pulled from.
- If you add a question to the Google form, the Form Response Sheet automatically adds that question’s column to the end of the other columns. You can manually move the column to reflect the order of the questions appearing on the form. Doing this is beneficial as the script relies on the ordering of the columns to pull data, and as such helps to keep things organized properly.
- - To move a column, click the gray bar above the column (where the columns are lettered) to select the whole column, then drag it where you would like it to be.
- Deleting a question in the Google form doesn't delete it’s corresponding column in the form response sheet. You can manually delete the column to keep the Form Response Sheet updated with the form. Again, doing this is beneficial as the script relies on the Form Response Sheet to pull data so it is best to keep it updated.
- - To delete a column, click the gray bar above the column (where the columns are lettered) to select the whole column, then right click and select Delete column.