Google Forms Tips - Edit Forms After Submitting
This short video shows you how to set up forms to be edited immediately after they've been submitted, as well as how to get the links for editing forms that have already been closed.
IMPORTANT - I realize that in the video I'm copying the FormKey from the form's preview.
Make sure that you are using the FormKey from the form while in Edit Mode, not from the preview.
IF YOU DON'T - You will see an error that looks something like this,
"TypeError: Cannot read property 'getSheetByName' of null (line 4, file "Code")"
Update If you choose to send response receipts in conjunction with allowing response editing in your form settings, google will now include a button to edit the response directly in the response receipt email. You can see what that looks like in this screenshot: drive.google.com/file/d/1QM_j...
Edit Response Script for Google Sheets:
docs.google.com/document/d/1m...
Check out the full Google Sheets and Forms course on Udemy:
www.udemy.com/google-sheets-f...
Special pricing for KZread viewers!
Пікірлер: 384
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!
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.
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? 🥰👍🏾
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.
This was so incredibly helpful. Thank you so much!
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.
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
FANTASTIC! Quick, well explained and you give the script! Perfect video!! All the stars for you!
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.
Thanks very much. Answered the "I don't have the link, but want to edit again" requirement perfectly.
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
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.
Wow... AMAZING VIDEO. This was so helpful , precise, clear and right. Thank you!!
This was brilliant, and saved me so many hours of work, many thanks.
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.
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
4 жыл бұрын
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.
Brilliant! Worked perfectly. Thank you so much for giving us access to the script.
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!
I`ve been searching everywhere for it. Thank you, you are genious!
Thank you soo much. Really nicely made and easily explained video. I´m definitly subscribing to your channel.
SO USEFUL. And I added a trigger to run it automatically when a form is submitted. (Edit > Current Project's triggers)
@livio41
4 жыл бұрын
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"
Great work, helped me a lot, thanks for sharing such valuable information
Thank you very much. Just what was needed. perfect!
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
6 жыл бұрын
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
5 жыл бұрын
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
2 жыл бұрын
@@jeremyyong2165 i am having the same problem
@edkensalexandre7043
2 жыл бұрын
@@jeremyyong2165 I'm having a similar issue.
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
4 жыл бұрын
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)
This worked perfectly! Thanks for sharing!
Awesome! Amazingly helpful. I really appreciate your help
thank you so much for this, really appreciate it!
Thank you sooo much!! This helped me immensly and worked well for my form.
Thank you. google forms changed the menu location of tools > script edit to Extensions > app script. It's working fine (info for recent users)
Dude ! You are the best ! You saved my life ! Thank you :)
You just saved my life. Thank you soooo much!
It worked for me after a few hiccups I had. Thanks buddy.
Great, this helped me a lot! Thank you!
Fantastic, so clearly explained and helpful.
Thank you SO MUCH! This is an absolute life saver. Checking the course link : )
Very good script! Thank you so much for sharing this! It helps me alot of time and brain storm!
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
Thanks a lot! This was useful. Very well explained.
This worked perfectly! well explain! thank you for sharing ;)
Thank you for this video! Very helpful. Question- if I have made changes to a Google form (added information), and want to resend it to respondents. When I run the scripts and get a URL, will it automatically send the emails to respondents or do I have to send those emails out manually?
thank youuuuu sooo muchhh!!!!! i've been looking for this
Thank you. This method is exactly what I needed.
Most needed one. Thanks mate
Super helpful while we wait for Google to make a "save" button. Thank you!! In the meantime, I'm curious if you know how this works for branched forms? I work with a lot of EAL students and if I'm doing an extensive branched for for differentiated learning, where will the link take them, say, if they have completed 4 out of 7 possible sections? Also, can students submit forms that aren't complete if all questions are set to "required?" Thanks again for this clear and informative workaround tutorial!
Thank you very much for the tutorial. If I want to generate automatically the edit-after-submit link once respondent finished their forms and send it to specific email address, is it possible to do? Please advice.
That was so helpful!!! Thank you!!!
THANK YOU SO MUCH FOR THIS!
This is really useful! Thank you so much!
Worked a treat. Thank you.
Thank you!!!! This was very helpful!
Thank you, sir. You are brilliant !
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
You crushed it.. Simple explanation & breakdown. Totally worked on my project and saved a lot of people a lot of time! Thank you 🙏
Thank you for the explanation brother, this really helped me and was extraordinary. always success, greetings from Indonesia. God bless. 🙏
Thank you so much!! This saved my life.
@hinarajputt
3 жыл бұрын
How?
Huge! Thank YOU:) Click on rename in response tab to reveal copy sub command.
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
2 жыл бұрын
ME TOO!
This worked in 2022! Saved my life
Thanks a lot. It is really helpful.
Hi! Excellent video thank u so much, it works perfect. But i have to run the code with a lot of rows and constantly. So, is there a way to obtain the edit link for just one row or register? Thanks again!!!
Thank you so much!!! It worked perfectly
Wow VERY Helpful! Thanks so much!
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.
Fantastic video bro
Very helpful, thank you.
Excellent video thanks.
thank you! you saved my day!
I wish I could give this a thousand likes. Thank you so much!
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
Very useful. I like this. Thanks for information sharing. I tied it. very useful
Can you please tell me or make a video about how I can show the submission number on google form???
Thank you this is very helpful!
Thanks for creating this video, looks promising! Does anyone who has done this already know if this works even if someone closed their form before clicking submit?
thanks a lot bro... It works
Thanks a lot, could you please explain how to put Excel form back to a normal view.
Super video!!! Thank you!
Great content! Thanks a lotttt!
Very helpful! Thanks!
Thank you. Very helpful. And, can anyone help with the following?: I have multiple people completing (not collaborating on) different sections of the same form(s). The problem is that they do so in no particular order or sequence. That is, one person does not begin the process and then pass the form along to the next and so forth. The result of this is duplication of form(s), as each person essentially starts a new form. If I could generate the editable links to each form prior to sharing them with anyone and then share the editable links, that would be one solution. Perhaps there is a way to duplicate and connect forms initially and get the editable link that way?
Thank you, it was helpful
THANKS A LOT it WORKED
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
THANKS BRO.. WORKING PERFECT..
Thanks its working ---- awesome
Thanks a lot it worked the first time
Thank you so much!
Thank you!!! Crazy how this is not easy to do in Google!
Thank you so much but what if they didn't click submit is there anyway to come back and complete. My form has loads of questions and it may take a while to complete
Your the boss!!!! big thanks
Why it does not tell that after we email the form, how to limit the receivers' access to filling it and not editing it.
It works. Thank you.
This is brialliant and helps me alot. Question though, It doesn't come up with the option to put in a project name and then when I try to run it's called untitled. How can I name the project?
this really help me
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.
Dear Sir, Very Useful Tips, Checked working fine, and i need one more think - Every form I submitted automatically edit link should be comes in edit link column, please guide & reply
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.
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.
Help please with this error exception: "Exception: The number of rows in the range must be at least 1. (line 20, file "Code")
Thank You so much for this tutorial sir. But one of the form where i enter this script it says "Exception: The number of rows in the range must be at least 1. (line 19, file "Code")" and it does not continue, what seems to be the problem sir?