Google Forms Tips - Edit Forms After Submitting

[@veronicabozich2469]

THANK YOU!!!! I am a teacher and have started to use Google Forms to create my daily lesson plans. I became frustrated when I could not go back and edit them; which is a necessity, and so I began searching the internet for answers. Took hours, but I am glad I found YOUR VIDEO! It is a life saver! Thanks again.

[@tom_h_producer]

This is absolute gold dust! I've had to do a lot of remote teaching recently, which means I've been digitising my workbooks as I've gone along into Google Forms. I've referred back to this video a good few times, and have the script saved in a handy place. Thanks so much!

[@tesfutilahun]

We have got some duplicated data and the Google form report summary is not working properly. After watching your videos, it works perfectly. We are glad that we can easily edit our data with the help of your videos. Thank you, Sir.

[@flutekiran]

Thank you. google forms changed the menu location of tools > script edit to Extensions > app script. It's working fine (info for recent users)

[@rogerchaproniere7996]

This script worked perfectly. The warning about Google being a bit finicky about permissions was well placed but after satisfying that requirement my editing problem is sorted Thank you

[@jeremyhill7156]

This is the perfect script that I was looking for. now just to enter a filter and then my project is complete. Thank you so much

[@carolhumm2493]

This was so incredibly helpful. Thank you so much!

[@RodneyWashington]

Thank you, thank you, thank you! It was a little tricky getting google to accept the script and then it didn't popular the spreadsheet with the urls after I initially ran it. But I ran it a second time and it worked like a charm. So again, thank you! My only gripe, it would seem to me that Google could supply us with a far easier way to get a link to re-edit a form without all of the steps you generously laid out in this script.

[@DigitalEgghead]

I agree, Rodney. It would be incredibly valuable for Google to implement this. In the meantime, I'm glad my solution was able to help you :)

[@jeremyyong2165]

Rodney, I think I'm having the same problem as you did. After permissions allowed, and I run the script, google says: Invalid ID (line 2, file "Code"). The form key was simply copy and pasted. Any ideas as to what I did wrong?

[@jetsadventures]

@@jeremyyong2165 i am having the same problem

[@edkensalexandre7043]

@@jeremyyong2165 I'm having a similar issue.

[@gregtonetti2460]

Thanks very much. Answered the "I don't have the link, but want to edit again" requirement perfectly.

[@MsLipsh]

I`ve been searching everywhere for it. Thank you, you are genious!

[@sampharo76]

It worked brilliantly. I ran into an issue at first where after the URL's populated in the spreadsheet, when I clicked on any of them it gave me an empty error page which stated "Resource unavailable". Figured out afterwards though that I forgot to ensure that "Edit after Submit" option in Settings was clicked on. Did that and it worked perfectly. Thanks.

[@livio41]

SO USEFUL. And I added a trigger to run it automatically when a form is submitted. (Edit > Current Project's triggers)

[@livio41]

Hi @Melanie Atkinson To add a trigger, I give you 2 ways to reach the form's triggers from the Edit Form Script (at 5:10) 1. Click on Edit > Current Project's triggers. 2. Replace "/edit" by "/triggers" in the url of the edit form script link Then at the bottom-right you have a button "Add Trigger"

[@sib22grace]

Woo! It worked- that is amazing! People with "TypeError: Cannot find function setMilliseconds in object MSGS. (line 13, file "Code")" problems, I had the same issue. I had moved around my columns and had forgotten that the timestamp was the first column (that the form added). Once I moved that back to column 1 it worked beautifully!

[@goodfairymarin7897]

thank you for this information; you will run into the same issue if you add rows at the top of the spreadsheet for downstream data entry or manipulation. in that case, you need to adjust the first row of the form column labels (hard-coded in loop to start at 1) and the first row of the data being posted (hard-coded to start at 2)

[@FanfromVenezuela]

I wish I could give this a thousand likes. Thank you so much!

[@AhmedTheCoder]

I want to edit google form upload file after submitting, (for the user, not owner).

[@hayyumahabbah2157]

I need to know about this also

[@comair5634]

I too need an answer to this. I contacted the owner and they sent me their copy and for me to edit.. but it was just the same "Edit your response". Now I don't know what to do. I have to change the file.

[@boicom7]

I think that's what he did. Maybe he should have had two tabs for the owner and user for clarity.

[@nikatherubbergod]

Yes

[@prashantparashar9599]

Did u found the way to edit it as a user??

[@lizkagansky9024]

FANTASTIC! Quick, well explained and you give the script! Perfect video!! All the stars for you!

[@PhenomenalChezline]

You, sir, are awesome! Thanks so much for that. This is just what I needed. I tried it and it sure worked great. Now I can have people update the form themselves, if necessary, by providing them with their own unique link without me having to do it myself. Of course, for those who need me to do it for them, I can just fill in the missing or erroneous items myself. Genius! I've just subbed after noticing all the other helful tutorials you have on your channel? Why haven't I found you before? 🥰👍🏾

[@JoshNelsonHawaii]

I have seriously been trying to figure this out off and on for over a month. I can get access to the script in a few places, but no clear instructions on how to use it. THANK YOU for this walkthrough. I can now generate these links just fine and not ask my team to copy the link and resubmit the form. One issue I had is that I had to copy the form identifier from the form builder/creator and not from the actual form link I send out. It may have to do with my G-Suite account being my secondary sign in on my browser. Thankfully Google Scripts showed me the error was happening there.

[@ForeverYoungBD]

It worked for me after a few hiccups I had. Thanks buddy.

[@nzoutdoors1923]

Worked great for me thanks! We just set up our own email mail merge rather than using the Google Receipts one so we could add our own message and put in their edit link.

[@mehulbawa]

This worked in 2022! Saved my life

[@hayamahagne6265]

Wow... AMAZING VIDEO. This was so helpful , precise, clear and right. Thank you!!

[@katherinefoxhall3930]

This was brilliant, and saved me so many hours of work, many thanks.

[@imagerose]

Thank you. This method is exactly what I needed.

[@ashivaaulia1357]

You just saved my life. Thank you soooo much!

[@ardikusumo3234]

Thank you so much for your tips, so useful.. I have had difficulty in commenting on responses that have been sent, and solved now with your video.

[@pereirashawn]

Thank you SO MUCH! This is an absolute life saver. Checking the course link : )

[@micolhebron1769]

Brilliant! Worked perfectly. Thank you so much for giving us access to the script.

[@elizabethreyes3599]

Dude ! You are the best ! You saved my life ! Thank you :)

[@nohberi7768]

Thank you for the explanation brother, this really helped me and was extraordinary. always success, greetings from Indonesia. God bless. 🙏

[@martins_kreicis]

Thank you very much. Just what was needed. perfect!

[@cristianpinheiro9048]

Very good script! Thank you so much for sharing this! It helps me alot of time and brain storm!

[@sallystokes5991]

Thank you! I haven't tried it yet but it looks like just the solution I need. if it works I am going to be doing a little dance!

[@clairealvaradoESA]

This worked perfectly! Thanks for sharing!

[@TheNaturaltay]

This was very helpful and exactly what I needed to correct my Google form. I will definitely share with others, when this solution is needed. Thank you also for included the script for non-programmers or those who don't have time to code something quickly. Thank you Thank you Thank you!

[@TheNaturaltay]

Ok. So this video is great start. The problem is the first response to the form seem to be the only data recorded. Even when you choose to edit your submission before closing the form (at the end of the form). I am not sure how that is helpful. I turned off "edit after submit" setting for now.

[@enriquecordero9145]

Very Helpful, It will facilitate my life. I use google forms to write reports about my clients meetings and I need to go back and edit. thanks

[@UnniKrishnan2k]

Most needed one. Thanks mate

[@anne-mariebrouwer8609]

Great, this helped me a lot! Thank you!

[@MichaelDaniels]

Awesome! Amazingly helpful. I really appreciate your help

[@karakterbaik]

This worked perfectly! well explain! thank you for sharing ;)

[@chinchic4071]

thank you so much for this, really appreciate it!

[@michaelmcnamara7602]

Fantastic, so clearly explained and helpful.

[@Mark4Jesus]

Hi - @1:50 Under Tools, my Google Sheet doesn't have any Script Editor. I will have to refill out this person's entire form using their previous data except the one thing they later decided they wanted to change. Bummer. I will have to start telling people to SAVE that edit link!

[@milinddes]

Thanks a lot! This was useful. Very well explained.

[@ChrisVarga]

First it just didn't work, now I get this error "Exception: The number of rows in the range must be at least 1. (line 19, file "Code")" Thanks for taking the time to write detailed instructions and produce a video. Hopefully there is a fix.

[@ChrisVarga]

Ok.....so now it works, but only if I click run on the script editor everytime i submit, or if I submit a bunch, then click run it will fill in all the url's. I did nothing different to change the first outcomes I mentioned btw. How do I get it to automatically run every time a submission is done?

[@ChrisVarga]

Ok...Ok....I found a fix using triggers. From the script page, click the stop watch looking icon. If you hover over it, it will read "current project's triggers" . The triggers page will pop up. Select "add trigger" from bottom right corner of screen. On the 'Select event source" button, choose "Time-driven". On the "Select type of time based trigger" button, choose "minutes timer". On the "Select minute interval", choose "Every minute". You can choose other options, but the instructions I have listed will at least make your script run every minute. Let me know if you have a better way.

[@4funrc11]

👍 Five+ years later... Thanks! ♥️ Wish you'd come back and do some more forms videos with Apps Script. Seriously! 😍

[@dansperformcast6448]

Thank you so much!! This saved my life.

[@hinarajputt]

How?

[@vanesazanzif]

Thank you soo much. Really nicely made and easily explained video. I´m definitly subscribing to your channel.

[@VersatileBizServices]

Sir, other than amazing straight forward tutorial, I could not help to wonder how actually you managed to change the background of the form to image. Because as far as I'm concern, there's no option to do that except to change color which is also limited to the those being displayed in the customized theme pane. May I know how you did that, Sir? Thank you.

[@jayadevanv3322]

Great work, helped me a lot, thanks for sharing such valuable information

[@AnsighYT]

thank youuuuu sooo muchhh!!!!! i've been looking for this

[@marianneguillois1391]

Love it best video on the subject so many thanks for a very well-done tutorial which I was able to implement it in minutes. I wonder now what else can be done via that script function. You have opened new horizons

[@trioimam71]

I'am From indonesian - Thank You Very Much 4 This Video,.... Very Helpful

[@laboranilmubudaya697]

Thank you, sir. You are brilliant !

[@capstoneglobal7170]

I am getting this error and I am not able to get the link. I followed the instructions carefully. Any help? "No item with the given ID could be found, or you do not have permission to access it. (line 2, file "Code")"

[@Ignight]

You crushed it.. Simple explanation & breakdown. Totally worked on my project and saved a lot of people a lot of time! Thank you 🙏

[@favellefavco1894]

Very useful. I like this. Thanks for information sharing. I tied it. very useful

[@ictmx]

Hi, I came a cross the problem "TypeError: Cannot call method "getSheetByName" of null. (line 4, file "Code")Dismiss", then I went back to the video and noticed that I was creating the script on the form and not on the spreadsheet. Once I created the script on the spreadsheet it worked. Maybe that is your case as well. Hope it helps.

[@emeritaalcid5894]

Wow VERY Helpful! Thanks so much!

[@eddymaluco1314]

Thank you so much!!! It worked perfectly

[@sarahsorge9565]

Hi! I'm able to follow this to the letter, but I get the error Exception: The number of rows in the range must be at least 1. (line 19, file "Code") How do I fix this? Thank you in advance! :)

[@sumankukreja6098]

Thank you sooo much!! This helped me immensly and worked well for my form.

[@hunyaochong5112]

Hi there, I tried running the script but I got a TypeError which syas data[j][0].setMilliseconds is not a function. Can someone please help? @Digital Egghead

[@MrThirty30]

Thank you!!! Crazy how this is not easy to do in Google!

[@GinaTellThreadGraffiti]

I use my google form to collect info from customers, I recently added some new product choices to one of the questions, now I cant see what my previous customers answered for those updated questions. Can you tell me what to do so I can see their answers from before I updated it?

[@thaislefundes3928]

Can I edit a response using the script WITHOUT changing the date? for example, I would like to edit a response that was sent two days ago, but when editing and submit, I would like to keep the date from two days ago.

[@sendwhat]

Thanks for this! I have used it multiple times on various forms. But I have one that I have done not one thing differently. It runs sometimes and sometimes not. I have a trigger when form submitted. That part works, but on this one form where I have this tied to resposes to get the edit link, I keep getting a "execution time exceeded". Any help would be great. This works great on every other form and sheet except this one where sometimes i get that error and sometimes not. Thanks in advance for any suggestions.

[@TDJConsultancyGroup]

Excellent video thanks.

[@henrylu4171]

This is so awesome, was able to get the original script working, wondering whether it is feasible to tweak the script to do some more. 1. enhance the script to capture the creation date of response as current timestamp get reset by edit/submit, I tried something (as in reply) but failed, wondering whether you can help to take a look. 2. whether the url can be placed into 1st column so that when this url column won't get pushed out when I add more questions to my form 3. how to expose the run script as a single click button so that I don't have to bring up script editor each time to populate url for new response.

[@henrylu4171]

for #2, another reason why I prefer to put url as 1st column . is it would be easily accessible, and I was able to add a new column this way in other situation, and put in an calculated info there, the only issue is for new response row, the calculated expression will be wiped out. If feasible It also allows me not to change my reference from another sheet even if many more questions get added later. But when I specify column 1 in the script, that was not popualted with edit url, I could not quite tell from your script why it is not working. so any suggestion where to change and whether it is feasible at all.

[@henrylu4171]

For #1, I first tried to directly set your existing timestamps , getting number[] is not expected error. then I tried to create a string array, but I could not get format conversion working. Pretty new to googel form and never used google script before so not sure what api is availalbe, could you help? Here is my script function assignEditUrls() { var form = FormApp.openById('1XPuXJlqLqwDaF9Bki22H3xYkn-628TkYbCVEFvvKCOU'); var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Response'); var data = sheet.getDataRange().getValues(); var urlCol = 40; var ColCreateTime = 39; var responses = form.getResponses(); var timestamps = [], urls = [], resultUrls = []; var TimeAsString = []; for (var i = 0; i < responses.length; i++) { timestamps.push(responses[i].getTimestamp().setMilliseconds(0)); var dateT = responses[i].getTimestamp().setMilliseconds(0); //this is my second attempt. formateDate throw error saying no function with such signature TimeAsString.push(Utilities.formatDate(dateT, 'Etc/GMT', 'yyyy-MM-dd\'T\'HH:mm:ss.SSS\'Z\'')); 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); //ths is my first attempt, it throw error saying there is no funtion taking number[] as input //sheet.getRange(2, ColCreateTime, resultUrls.length).setValues(timestamps); sheet.getRange(2, ColCreateTime, resultUrls.length).setValues(TimeAsString); }

[@emilycarroll2941]

Thank you!!!! This was very helpful!

[@PeteVree]

Just saved me from the onslaught of students saying that they couldn't revisit the form. You rock! Thank you. For anyone working on this in 2020. I had to have at least one response occupying a Row to allow the Script to run without errors.

[@ٴٴٴٴۥۥٴٴٴٴۥۥٴٴٴٴۥۥٴٴٴٴۥۥٴٴٴٴٴٴ]

What if the students use this in the quiz?😂😂

[@Stricky31]

THANK YOU SO MUCH FOR THIS!

[@manohariesrikrishnarajah821]

Thanks a lot it worked the first time

[@ilsepbakker]

Thanks so much for this video! Exactly what I was looking for. For me it would be very useful if the edit link would add automatically to the sheet, instead of running the script first. Would anyone have an idea how to realise this?

[@passport-photo]

ME TOO!

[@clivetanner]

It seems like the script editor is no longer available. Any idea if it moved somewhere else or if there is another way of achieving this now?

[@sangeethapanuganti4311]

Hurayyyy... It's admirable.. But For every google form entry we need to go to spreadsheet and have to run the script, is there any alternate way to do it automatically??

[@stacyannhayles]

Very helpful, thank you.

[@XXLRebel]

Why does Google have to make this so complicated... I use Google Forms for client intakes and it's so frustrating to not be able to go back to my previous filled in answers. Come on Google, it's so simple to just add a button that shows you the link to that form... This would make it's usability go up infinitely.

[@AbubakarSalisu]

Thanks a lot. It is really helpful.

[@sntsalom]

Great content! Thanks a lotttt!

[@lazyo4631]

Can you please tell me or make a video about how I can show the submission number on google form???

[@officerjohnavila2360]

I keep getting an error on line 2 "Exception: Invalid ID (line 2, file "Code")" Can you help with this error?

[@DigitalEgghead]

Make sure that you are using the FormKey from the form while in Edit Mode, not from the preview

[@ZahratAlafrah]

Hi, thanks for the explanation 1- How can I run the web link directly after the submit form button? 2- How can I show the sender's mail in the form field without typing it? 3- How do I get a student to check-in and check-out only twice a day ? Thank you ....

[@user-EmYo28]

Very helpful! Thanks!

[@biropengadaaninfrastruktur3198]

Thanks sir , How automatic create link if a new added responses

[@kakigorimochi]

There have been changes with google sheets, script editor has been moved out of tools to extensions and now dubbed as apps script.

[@carlburket9063]

Hi, I'm trying to add the script in Script Editor to so to edit an closed/submitted response. When I run I keep getting this error message saying I don't have permission to access form but I am the owner and have hit a bit of a wall. Be most grateful if u could point me in right direction

[@mohdzamreeabdul3935]

Hi, very useful tips...many thanks. But in my form, I have a file upload field (to upload a pdf or image file) and I noticed that it can't be edited. What could be wrong.. can you help me. Thank you.

[@stevenmarshall4015]

I followed these directions about a year ago, and everything worked fine. However, when I just tried it today, it's not working. I edit the script correctly and it seems to run fine, but the urls do not populate in my form responses sheet. I've tried over and over. Is the script outdated, or has anything else in Google Forms changed such that this no longer works?

[@diegoe033]

Super video!!! Thank you!

[@fhelinlove]

TypeError: data[j][0].setMilliseconds is not a function how to resolve this?

[@storyfirstfilms149]

Fantastic - thank you very very much. Is there a way people can automatically re-enter themselves to edit without having to call on me again?

[@titohero2000]

I have a error with this part (data[j][0].setMilliseconds(0))]:'']) It says it is not a function! Need help

[@mohamedregaya6317]

thank you! you saved my day!

[@MarkBaitinger]

Huge! Thank YOU:) Click on rename in response tab to reveal copy sub command.

[@אירנהמזרחי]

Thanks a lot, could you please explain how to put Excel form back to a normal view.

[@davidsookharry8555]

This is great, what about setting a time limit to stop editing after a couple of hours or days after closing form or even before. thanks

[@greenturkey9082]

i tried thats perfect thanks but for the sheets that i added (inserted) extra columns it didnt work, i need your help to modify the code to fix this problem

[@harshitdesai8522]

Hey Mate, This is good..very helpful. Thanks for that. But what if we want to give a default name to the each new URl which is generated for each row (url does not look good) which is dispalyed in the sheet. Any idea. Thanks

[@apps.projects6050]

THANKS BRO.. WORKING PERFECT..