PLEASE NOTE – I realize that in the video I’m copying the FormKey from the form’s preview. You now have the edit URLs to give out to the people who filled out you form if they need to edit them. If you open one, it will take you directly to the form for that response and allow you to edit it.Īfter you’ve set this up, all you need to do is run the script any time you want to populate the URLs. When you go back to the spreadsheet you will see that the URLs have been populated in the column that you designated.
You made the script, so you know it’s safe. You may get one more warning about safety. Click on “Review Permissions”, choose your account and click on “Allow”. The first time you run the script, it will tell you that Authorization is required. Var timestamps =, urls =, resultUrls = įor (var i = 0 i Run Function > assignEditURLs Var urlCol = Column number where URLs get entered goes here Var data = sheet.getDataRange().getValues() Var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(' Your responses Google Sheet name goes here - The tab name, not the file name') Var form = FormApp.openById(' Your form key goes here') Set up the scriptĭelete the text that’s already there and replace it with this script: This will open a new tab with the Google Script Editor. Once that is done, open the spreadsheet and click on the Tools menu item then Script Editor.
This is done by clinking on the “Responses” tab, then clicking on the green spreadsheet icon.
Method 02 – Retrieving the Form Edit Linksįor this method, you’ll set up a script in the response spreadsheet that will insert the edit form links for each response.īegin by linking your form to a response spreadsheet. Now what about the people who have already filled out a form and closed it, but need to go back and edit their response? This is a bit more complex to set up, but once it’s done you can use it over and over. If you have a need for people to come back to the form and edit it later, you can tell them to copy this edit form link and save it somewhere. Once you submit the form, you will see that there is a link to edit your response.Ĭlicking on that link will bring the form back up to edit. Now you can preview the form and fill it out. Then check the “Edit after submit” box, and save it. To do this, click on the settings icon in the upper right. Method 01 – Including the Edit Response Linkįor the first method, we’ll simply set the form to include an ‘edit response’ link after the form is submitted.
#ZMODELER 3 COL CANNOT BE EDITED HOW TO#
In this article we’ll take a look at how to set up a form that can immediately be edited, as well as how we can get the link for editing a form that has already been closed. I recently had a student ask me how he could have people come back to his form and edit their responses. Do you need to have someone edit form responses AFTER they’ve already submitted them? What if they closed the form and need to edit later? If this is something you’re dealing with, then this article is where you need to be! Edit Form Responses After They’ve Been Submitted