How To Edit a Form After Submit in Google Forms

Google Forms are an excellent tool for creating all kinds of forms, surveys, and job submission forms. It’s a free tool with many pre-designed forms you can edit to your liking and post online for others to fill out.

How To Edit a Form After Submit in Google Forms

Sometimes, however, you will need to change the original template to better suit your needs. Instead of creating a new form from scratch, you can edit an already submitted form at any point. This article will explain how you can do that.

Change Submitted forms

Google Forms templates are pre-designed, but you can make your own changes before posting. You can also make changes after posting. Here is what you have to do:

Method 1 – Set Up an Editing Link

The first method allows you to create an editing link you can use later to change the information in the Form. The edit response link has to be set up before submitting the Form for the first time so that it can allow you to make changes in the future.

  1. Open the Google Form you need.
  2. Click on the “Settings” in the upper portion of the document.
  3. When the new window pops up, select “Responses” and toggle “Allow response editing” to on.
  4. Click on the little eye icon to enter the information you want and click “Submit.”
  5. You’ll see a link that says “Edit your response.” Click the link to edit the information you submitted earlier.
  6. Copy the link and save it to your PC so you can edit the form at any time.

The method works well when you want to edit a single Google form response, but things get a little more complicated if you’re dealing with multiple responses. Here is what you have to do to set up unique editing links.

Method 2 – Create Your Script

  1. First, you have to create a spreadsheet with the responses you already have. Click on the “Responses” tab and then click on the little green spreadsheet icon.
  2. Open the form response spreadsheet. Click on “Extensions” and select “Apps Script.”
  3. Delete the text that appears when you open the script.
  4. Copy the following script into the script editor:


    function assignEditUrls(){
    var form = FormApp.openById('Your form key goes here');
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Your responses Google Sheet name goes here – The tab name, not the file name');
    var urlCol = Enter column number where, the one where URLs are entered;
    var responses = form.getResponses();
    var timestamps = [], urls = [], resultUrls = [];
    for (var i = 0; i < responses.length; i++) {
    timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
    urls.push(responses[i].getEditResponseUrl());
    }
    for (var j = 1; j < data.length; j++) {
    resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]);
    sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
    }
    }
  5. Change the command (‘Your form key goes here’) with the right form key for each report.
  6. The form key is the lettering found in the address bar. Copy and paste to the required row in the script editor.
  7. Next, copy the name of the sheet and paste it to replace ‘Your responses Google Sheet name goes here.’ – You need the tab name, not the file name.’
  8. When that’s done, you will have to edit the var urlCol line in the script editor. Enter the number of the first empty column in your spreadsheet. In our case, it’s 8.
  9. Enter a name for it and save the script.
  10. When you’ve set up everything, select “assignEditUrls” and Run the function for your script.
  11. Review permissions and allow your account to use the script.
  12. Go back to the spreadsheet, and you will see that every entry has a unique link.
  13. Click on a link, and you can edit each link at any time.
  14. Run the script whenever you want to add more results to your form to get the unique links.

Frequently Asked Questions

Google Forms are a great way to find out more information about people, their opinions, and have fun while doing it. If you still have questions, keep reading this section.

Can I change the questions or description on a Form after sending it?

Absolutely! If you notice an error, need to add more questions, or realize an existing question is too confusing, you can easily make edits to a Form after sending it. Here’s what to do:

1. Open Google Forms and sign in using the same login information you used to create the Form.

2. Click on the Form in question. Now, you can edit the Description by clicking on the Description box at the top and typing what you need to. Then, hit Tab on your keyboard until the text box isn’t highlighted.

3. If you need to replace a question or get rid of one, hover your cursor over the selection. Then, press the X icon to the right.

4. To add a new question, click Add option. Type the question and click somewhere else on the screen.

Unfortunately, you can’t edit a question but you can delete one and add a new one. After making edits ask your respondents to refresh their screens. The updates will appear automatically.

Save Time by Using This Simple Method

The second method does require you to create a script, but that script gets most of the work done automatically. Creating the script might look complicated, but it’s not. It takes only a few minutes to set up, and once you do, you can re-use the same script as many times as you want. You will then get direct links to each form, so you can change all results whenever you need to.

Did you ever use Google Forms? Do you know some other method for changing already submitted forms? Share your wisdom with the community in the comment section below.

17 thoughts on “How To Edit a Form After Submit in Google Forms”

Johnny says:
Thank you For this code really appreciate your work
Suthananth says:
Updated code. for those facing the same issue
“SyntaxError: Invalid or unexpected token (line 1, file “Code.gs”)”

function assignEditUrls(){
var form = FormApp.openById(“FormID”);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Form Responses 1”);
var urlCol = 12;
var responses = form.getResponses();
var timestamps = [], urls = [], resultUrls = [];

for (var i = 0; i < responses.length; i++) {
timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
urls.push(responses[i].getEditResponseUrl());
}

var data = sheet.getDataRange().getValues(); // Add this line

for (var j = 1; j < data.length; j++) {
resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]);
}

sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
}

J says:
It says this error: ReferenceError: data is not defined
assignEditUrls @ Code.gs:11

What do I do?

Nat says:
thanks – that is working now. thanks for sharing
ath piseth says:
This help me a lot. Thank you for sharing.
Nick Nikkhah says:
I want a form that customers can fill out Section 1 and section 4 of the form as it will skip over the sections 2 and 3 and then they submit.
I want to be able to go into the form myself and entries for sections 2 and 3 once the form is summited. How is this possible?

For clarity, I want to have one form that is used by both my clients and myself to add data.

The client fills out the first section and then I have their info and what they want, then they come in for the service and I want to open the same form and add my own data for the service I am performing with notes and so on.

Is this possible?

Shubham Sonawane says:
Use this updated script with single inverted commas changes to double inverted commas and it does worked for me:
——————————————————————————————————————————
function assignEditUrls() {var form = FormApp.openById(“1tsFZqANR_LQGW5nHzii7acEJmpOIfb3uHmLJ3KODdHM”);

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Form responses 1”);

var data = sheet.getDataRange().getValues();

var urlCol = 28;

var responses = form.getResponses();

var timestamps = [], urls = [], resultUrls = [];

for (var i = 0; i < responses.length; i++) {

timestamps.push(responses[i].getTimestamp().setMilliseconds(0));

urls.push(responses[i].getEditResponseUrl());

}

for (var j = 1; j < data.length; j++) {

resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]);

}

sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);

}
——————————————————————————————————————————

scott says:
How can I have Edit url created when I don’t require every column have a value or each form question not required? URL is only built if every column has some data.
Raj says:
Hi, I was able to get this script running on my form after a couple of corrections
i tried running the scrip today & ended with an
Error
TypeError: data[j][0].setMilliseconds is not a function
assignEditUrls @ Code.gs:17
Please advice how do i fix this soonest.
Wilson Lim says:
Are you using the response sheet as generated by forms? Or did you add columns? I added a column and got the same error message as you. Google forms normally create timestamps as the first column of your response sheet. If your timestamp is not the first column, you may also get that error. Just a guess.
Brett Curtis says:
Can I set up my google forms so that my customers can return to complete or edit what has been posted?
Lou Brawley says:
Looks like the quotes/apostrophes that the poster uses throws errors. If you type the single quotes around your form key and form responses tab name, that’ll fix it. Also, the resultUrls.push line of code will need TWO single quotes instead of a double quote. Making those changes, it throws an permissions error about FormApp.openById. After doing research, you’d need to “create a custom menu that runs an Apps Script function instead of writing a custom function” to make it work.
Lisa says:
Is there a way to edit a submission once the maximum submissions are reached? For instance, I am asking a group to go back and edit their addresses that are incomplete, but they are saying they are unable to, since it is saying that the event is full. They have the link to go back and edit in the confirmation email sent after submitting.
Frank says:
receiving following error message:

SyntaxError: Invalid or unexpected token (line 1, file “Code.gs”)Dismiss

Philip Kogan says:
I am getting No item with given ID could be found… what exactly do you use for the from key and is from where you create the form or the link to complete it?
Stacie Finnelly says:
Hi. I’m getting an error on Line 2

var form = FormApp.openById(‘1Wrz1qblTgL5ggZx6v1DAdZV2Vk2m8BYJZXVrM2b5yF8’);

It says “Illegal character, line 2.

Any thoughts?

Donna Boecker says:
I’m getting the same thing. Did anyone else respond?
Philip Kogan says:
after trial and error I finally got the right portion to use, copy from the form page where you edit it and remove characters at beginning “…google.com/forms/d/e/” and end “edit”, you will get something like this
1pFz7ZSG………….MBrwYRyr2c

Leave a Reply

Your email address will not be published. Required fields are marked *


Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.

Todays Highlights
How to See Google Search History
how to download photos from google photos