1

How To Edit a Form After Submit in Google Forms

Posted by Anna Middleton on July 12, 2019
Edit After Submit 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.

One thought on “How To Edit a Form After Submit in Google Forms”

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?

Reply

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.