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.
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!
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.
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
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.
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?
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.
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!
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)
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"
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.
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.
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? 🥰👍🏾
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.
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.
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.
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!
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.
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!
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??
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.
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.
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); }
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.
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.
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?
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.
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
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")"
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?
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! :)
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?
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.
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!
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.
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
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
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
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.
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?
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 ....
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?
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.
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?
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
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.
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!
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.
I wish I could give this a thousand likes. Thank you so much!
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
Thank you.
google forms changed the menu location of tools > script edit to Extensions > app script.
It's working fine (info for recent users)
I`ve been searching everywhere for it. Thank you, you are genious!
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.
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 :)
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?
@@jeremyyong2165 i am having the same problem
@@jeremyyong2165 I'm having a similar issue.
This was so incredibly helpful. Thank you so much!
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
I want to edit google form upload file after submitting, (for the user, not owner).
I need to know about this also
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.
I think that's what he did. Maybe he should have had two tabs for the owner and user for clarity.
Yes
Did u found the way to edit it as a user??
Thanks very much. Answered the "I don't have the link, but want to edit again" requirement perfectly.
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!
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)
Thank you. This method is exactly what I needed.
SO USEFUL. And I added a trigger to run it automatically when a form is submitted. (Edit > Current Project's triggers)
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"
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.
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.
It worked for me after a few hiccups I had. Thanks buddy.
Thank you very much. Just what was needed. perfect!
FANTASTIC! Quick, well explained and you give the script! Perfect video!! All the stars for you!
This worked in 2022! Saved my life
Wow... AMAZING VIDEO. This was so helpful , precise, clear and right. Thank you!!
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? 🥰👍🏾
Thank you SO MUCH! This is an absolute life saver. Checking the course link : )
This was brilliant, and saved me so many hours of work, many thanks.
You just saved my life. Thank you soooo much!
Most needed one. Thanks mate
Very good script!
Thank you so much for sharing this!
It helps me alot of time and brain storm!
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 worked perfectly! Thanks for sharing!
Dude ! You are the best ! You saved my life ! Thank you :)
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?😂😂
Brilliant! Worked perfectly. Thank you so much for giving us access to the script.
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.
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!
thank you so much for this, really appreciate it!
Thank you for the explanation brother, this really helped me and was extraordinary. always success, greetings from Indonesia. God bless. 🙏
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.
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!
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.
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!
Awesome! Amazingly helpful. I really appreciate your help
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??
Great, this helped me a lot! Thank you!
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.
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.
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);
}
Fantastic, so clearly explained and helpful.
👍 Five+ years later... Thanks! ♥️ Wish you'd come back and do some more forms videos with Apps Script. Seriously! 😍
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.
This worked perfectly! well explain! thank you for sharing ;)
You crushed it.. Simple explanation & breakdown. Totally worked on my project and saved a lot of people a lot of time! Thank you 🙏
Thanks a lot! This was useful. Very well explained.
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.
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?
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.
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
Thank you so much!! This saved my life.
How?
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
Thank you, sir. You are brilliant !
Great work, helped me a lot, thanks for sharing such valuable information
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")"
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
thank youuuuu sooo muchhh!!!!! i've been looking for this
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?
ME TOO!
Thank you soo much. Really nicely made and easily explained video. I´m definitly subscribing to your channel.
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! :)
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?
Excellent video thanks.
Very useful. I like this. Thanks for information sharing. I tied it. very useful
Thank you sooo much!! This helped me immensly and worked well for my form.
Thank you so much!!! It worked perfectly
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?
Great content! Thanks a lotttt!
Wow VERY Helpful! Thanks so much!
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.
Thank you!!!! This was very helpful!
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!
Thanks a lot it worked the first time
THANK YOU SO MUCH FOR THIS!
Why it does not tell that after we email the form, how to limit the receivers' access to filling it and not editing it.
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?
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.
Very helpful! Thanks!
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
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
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
Super video!!! Thank you!
There have been changes with google sheets, script editor has been moved out of tools to extensions and now dubbed as apps script.
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.
Can you please tell me or make a video about how I can show the submission number on google form???
Very helpful, thank you.
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?
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 ....
Thanks a lot. It is really helpful.
Thanks a lot, could you please explain how to put Excel form back to a normal view.
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?
Thank you!!! Crazy how this is not easy to do in Google!
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.
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?
THANKS A LOT it WORKED
Thanks its working ---- awesome
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
thank you! you saved my day!
hello sir is it any another way to check that our given response submitted or not without contacting teacher sir plesse reply???