How to edit a google form after submission

2. A Google Form is a tool that allows users to create online forms and collect responses. In order to edit a Google Form after submission, open the form in Google Forms editor and select the “Edit” button. After clicking on the “Edit” button, you will see a new window that contains all of your responses. This is where you can edit your responses before sending out your form again. Google Forms is a great tool to create all types of forms, surveys, or job submission forms. You can use it for free and edit the Google Forms templates pre-designed forms to make your own. You also can make changes after posting

3. Set Up an Editing Link When designing the form, go to Settings (gear icon), check Edit after submitting. If the Collect email addresses and Responses receipts are checked the respondent will get a link emailed to them in the response. Otherwise, the confirmation screen will have a link they can copy for later editing. 1. Open the google forms that you want to provide access to edit. Click Settings. You can find in as one of the option just about the form Turn on Allow response editing in the settings’ responses section. 2. 3. After people submit their answers, a confirmation page appears with two link. As users are able to make changes to their responses by clicking “Edit your response”. They can easily return to the form and continue elaborating on their answers.

4. Create Your Script What if people submitted there response and then changed their mind? How can allow them get the link to edit it? Is easy that you can edit it yourself or you can delete the response and as them to submit again. But what if your are running an anynomous survey? You can’t track and also people might not reach out to you survey is about some sensitive topic. Scripts can help in such cases. Although this method does require you to create a program, it automates the majority of the work that is needed. Developing a script may seem complex, but it is not. The script is easy to create and can be reused as many times as you wish.

5. You will then get direct links to each form, so you can change all results whenever you need to. Here is the steps for how to edit google form after submission. First, you need to create a spreadsheet with the responses that you already have. To access the list of responses in the sheet, click on the “Responses” tab and then click on the icon that looks like a green spreadsheet. ● You can create a new spreadsheet or selecte and existing file if you have already created a google sheet for responses before for the same form. The Google form is linked to the Google Sheet where the new responses are updated

6. You need Apps Script Editor Extension as Google changed its IDE. You can lear more here ● Open the form response spreadsheet. Click on “Extension” and select “ App Script.”

7. Delete the text that appears when you open the script. And paste the following script into the script editor ●

8. Change the command (‘Your form key goes here’) with the right form key for each report. The form key is the lettering found in the address bar. Copy and paste to the required row in the script editor. 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.’ 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. Save the script and enter a name for it. When you’ve set up everything, Run the function for your script, and select “assignEditUrls.” Review permissions and allow your account to use the script. ● ● ● ● ● ●

9. Go back to the spreadsheet, and you will see that every entry has a unique link. Click on a link, and you will be able to edit each link at any time. Run the script every time you want to add more results to your form to get the unique links. ● ● ●