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.

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 icon to the left of the large “Send” button in the upper right corner of the document.
    questions
  3. When the new window pops up, check the “Edit after submit” box to create the edit link. Hit “Save.”
    edit after submit
  4. Click on the little eye icon to enter the information you want and you’ll see a link saying “Edit your response.”
    edit your response
  5. Click the link to edit the information you have 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.
    responses
  2. Open the form response spreadsheet. Click on “Tools” and select “Script editor.”
    script editor
  3. Delete the text that appears when you open the script.
  4. Copy the following script into the script editor:
    script demofunction 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 data = sheet.getDataRange().getValues();

    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.
    form key
  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.’
    sheetname
  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.
    column numb
  9. Save the script and enter a name for it.
    save script
  10. When you’ve set up everything, Run the function for your script, and select “assignEditUrls.”
    run function
  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 will be able to edit each link at any time.
  14. Run the script every time you want to add more results to your form to get the unique links.

Save Time by Using This Simple Method

The second method does require you to create a script, but that script gets the 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.

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

Avatar 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.
Avatar 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.
Avatar Frank says:
receiving following error message:

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

Avatar 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?
Avatar 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?

Avatar Donna Boecker says:
I’m getting the same thing. Did anyone else respond?
Avatar 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.