How To Edit Google Form After Submission

Your Quick Answer:

To edit a form after submitting, go to the “Settings” option then “General” and check the box beside “Edit after submit”. Then save the changes and preview the form to make sure the changes have been implemented.

To edit a form that the person has exited out of after submitting, you have to go to the form responses spreadsheet and tap on “Tools” and then on “Script editor”. Erase the existing script and type in a script to add an individual form URL for every response to the spreadsheet. Add a title and save it. Tap on the “Run” option at the top and allow Google access to your spreadsheets and forms. Now go to the form, and you will see URLs for every form. If you tap on the URL, you will be able to edit.

To create a script, first, you have to go to the “Responses” tab and tap on the spreadsheet icon. Now tap on ” Extensions” and then on “Apps Script”.Add your script and tap on the save icon. Add a proper name and then tap on the “Run” option in the menu bar. This will implement the script to the form.

When you run a script for the first time, you will be asked permission to authorize it. Since you have typed the script, there is no risk in allowing Google access to this.

A script, once created, can be used multiple times for every type of form. All you have to do is copy and paste it where necessary and make related changes.

Always tap on “Run” after adding the script; otherwise, the changes you made in the script will not be implemented.

Contents

How To Edit Google Form After Submission:

There are mainly two methods that you can look for to fix this:

1. For people who have Submitted but have to Edit

Follow the steps below:

Step 1: Go to Settings & Allow response editing

The first step you have to follow is to go to the “Settings” option, which is seen in the top right area of the screen beside the “SEND” option. Then you have to go to the “Responses” part of the settings section.

The lower part of the visible options will say “Responses can:” there will be four options below. Tap on the box beside “Allow response editing“. Ticking this option will allow the user of the form to edit the form even after it is submitted. Then automatically save the changes you have made.

Step 2: Preview your edited form

Now you have to tap on the Preview icon at the top right of the screen to see how the form looks and if it lets you edit your response.

You will notice that once you submit the form, there is an option that says, “Edit your response”. If you click on the option, the form with all the details you’ve filled in will appear on the screen, and you can make the necessary changes.

2. For people who Filled Form and Closed it

Follow the below:

Step 1: Go to Script editor

The first step you have to follow is to go to the form response spreadsheet. Under the name of the sheet, you will see a menu bar with various options like “File”, “Edit”, etc. Tap on the option that says “Tools”. Under the options that will appear below it, tap on the option “Script editor”. You will see some default text on the screen; delete it.

Step 2: Type the script for creating Edit URLs

Now type in a code. Go to the form and look at the form URL. You will notice a combination of alphabets in the middle of the URL. You have to copy this part of the URL and paste it into the script in the form key section.

Now go to the spreadsheet again and copy the name of the sheet. Directly paste it into the designated area in the script. Then we need to add to the script a column number that will help determine which column you want the edit URL saved in.

Step 3: Save and tap on “OK”

Now tap on the “Save” icon at the top left part of the screen below the menu bar. A prompt will appear asking you to enter the name of the project. Enter a title and tap on “OK”.

Step 4: Tap on “Run” & “Review permissions”

Tap on the “Run” option in the menu bar. In the options under it, tap on “Run function”.

And then on the option with the name of the function you want to run. You will get a prompt saying, “Authorization required”. Tap on the option that says “Review permissions”.

You will have to choose an account you want to proceed with and allow Google to manage and view your spreadsheets and forms.

Step 5: Go to spreadsheet and see if the URLs appeared

Now you have to come back to the spreadsheet. You will notice that all the URLs have been made for the existing responses in the assigned column. These links store the exact details that the particular respondent typed. If they have access to this link, they can change the details. If you decide to make changes in the script later, tap on “Run”.

How to Create Your Script:

Follow the steps:

Step 1: Go to “Responses” > Spreadsheet icon

First, you have to go to the “Responses” tab. Here you will see the list of responses, and you will have to create a spreadsheet regarding the same. You have to tap on the spreadsheet icon on the top right side of the screen.

Step 2: Go to “Extensions”>”Apps Script”

Now the spreadsheet will open in front of you, and you have to tap on the option that says “Extensions”. A list of options will appear below it, and you will have to tap on the option that says “Apps Script”.

You will notice a few lines of default text will appear once you tap on the option. But you will have to delete all of it. Now you can type in your code with proper functions. Save the file with an appropriate name.

Step 3: Tap on “Run” and provide related permissions

Once you have saved it, tap on the “Run” option. When you tap on the “Run” option, the script you wrote gets implemented. The first time you do this, you will be asked to provide authorization to Google so that it can view and manage your spreadsheets and forms. Thus your script will be created.

The Bottom Lines:

You have here two methods in which you can let your Google forms be edited. The second method might be time-consuming, but once you create the script, you can use it for other forms after adding minute changes. However, if you are short on time, you may use the first method.

Also Read: