Im in South Africa gumroad is refusing to accept my card but its a VISA card and I have made an international payment before so I cant get the code please help
hey I have an excel file of responses and I would like to import it to my google form so I can get the google form descriptive stats off those responses but I am struggling with having the responses loaded onto the form could you please help me
May you help me, Sir? Your code looks great and work for me. But, there is a little problem here. The code doesn't work when there is row (or answer) in Goolge Spreadsheet is blank. Sometimes, I don't need to fill one field. Thanks in advance..
I have 5 fields in my importList. Sometimes I don't need to fill one field . But the code will be error when there is one field still blank. Thanks in advance..
Hmmm.... So you're saying that sometimes the answer for a question is blank and as a result the script breaks during its run? Yeah? Have you tried explicitly setting it as blank by setting it to "" ? -- I can include this bit in a future video (I kinda need to make an updated version of this one anyway)
Yeah, I've had a few folks write in about this - it's almost always that they're running the "getSettings" function instead of the "importFormResponses" function. Make sure to select the right function before you hit the run button in the apps script editor. Lemme know if it works for ya!
is there any way I can do that faster cause I have like more than 20 columns and 500 rows and execution time take like 4m for each row I really want to know if I can do that faster @Bootstrapping Tools
Hmm... tough question. The Google Forms api only takes in one item at a time from what I know. The only other option would be to try and optimize your code a bit. 4 minute per row sounds longer than it should take, even for 20 columns. The other option could be to do it in chunks or something like that.
I have the same issue. The code executes in less than 1 second with no error messages, but nothing happens. I sent an email to support and hoping to update with a solution! It's probably something simple that I'm missing.
@@BootstrappingTools I am running into the same problem. It runs in less than one second, and nothing happens. I will send a sample file to the email you provided. I even renamed my sheet ImportList lol
Thank you for the video. I tried to donate to download the code. The link "I want this" isn't working. I tried 3 different browsers from 2 different computers and the result is the same. I want the "with code comments" option. I tried them all. Any thoughts?
This is outstanding! I made the donation and am working with the code. As a newb to app script, I’m struggling. So I have a couple questions: I put this in the app script for the form, replaced the id codes in the ‘getsettings’ function with the relevant ids from the web addresses (from edit mode for the form), ran each function, and am getting an Error for ‘getType’. It says, “TypeError: Cannot read properties of undefined (reading ‘getType’).” What am I missing? Second question; one of my favorite app scripts is to add edit urls. So far as I can tell it’s a popular one for the layman. Since it’s applied in the app script for the destination spreadsheet instead of the app script for the form, it’ll still work, right? Thanks in advance!
For the getType() error, that sounds like it's b/c the wrong thing is being passed there... send an email to support@bootstrapping.tools with a screenshot of your code and I'll take a deeper look for ya. For the second question... I'm not sure I fully understand what you're saying.. What are you trying to do there?
I am really wanting to apply what you have created in this video. I am a real novice to the code. I am a teacher and I want to be able to past the students grades into the sheet and click the code and have it go directly into the form. This way I do not have to type in over 120 grades by hand each day. Any suggestions where I can get the code you have created. I have paid for the code, put the ids in, but nothing happens
Hi Timothy! There's no direct way to assign the email respondent when importing responses, but you can have a separate Text Field for email and import it into that field. It won't show up in Google Form's report, but you can create a separate dashboard if you need to see the results per email.
Have you been spying on my todo list? Because first it's the dependent drop downs, and now yes, I absolutely was wondering how I was going to transfer a whole tonne of data from one spreadsheet into a new Form-related system and was thinking I'd have to do it record by record through the form. Now - perhaps not.
Haha, glad to hear you're finding everything useful! Feel free to reach out if there's anything you'd like me to cover. I've been a bit slower with making videos lately as I try to figure out a better format, but I'll be starting back up again really soon!
Great question! It would be a scale item, so you'd need to do something like: item.asScaleItem() Using the code from the video, you'd want to add this new case into your switch statement: case FormApp.ItemType.SCALE: result = item.asScaleItem(); break;
Please help! I have a google forms that I change and a sheet with some answers, I want that forms can read that answers that i had before, i have watch your tutorial a lot of times and even payed for the code, but i don´t get it, PLEASE help is for a good cause.
code line 27: newResponse.withItemResponse(responseItem.createResponse(formEntry)) code CheckboxItem: case FormApp.ItemType.CHECKBOX: result = item.asCheckboxItem(); break;
🎉Are you interested in a Bootstrapping Tools Community? Let me know! forms.gle/4tzvffHiRqS7pVZY6 🎉
not going to lie, you are a legend.
Im in South Africa gumroad is refusing to accept my card but its a VISA card and I have made an international payment before so I cant get the code please help
I think it also accepts paypal - but there's a free version of the code if anything.
hey I have an excel file of responses and I would like to import it to my google form so I can get the google form descriptive stats off those responses but I am struggling with having the responses loaded onto the form could you please help me
What kind of error message are you getting?
May you help me, Sir? Your code looks great and work for me. But, there is a little problem here. The code doesn't work when there is row (or answer) in Goolge Spreadsheet is blank. Sometimes, I don't need to fill one field. Thanks in advance..
I have 5 fields in my importList. Sometimes I don't need to fill one field . But the code will be error when there is one field still blank. Thanks in advance..
I'm facing the same difficulty @@LukmanHakim-rf8vv
Hmmm.... So you're saying that sometimes the answer for a question is blank and as a result the script breaks during its run? Yeah?
Have you tried explicitly setting it as blank by setting it to "" ? -- I can include this bit in a future video (I kinda need to make an updated version of this one anyway)
@@BootstrappingTools Yeah. Exactly. Oh, I have to try it..
Hey this seemed to execute without any errors but nothing imported into my form. Is this now a known problem with this code?
Yeah, I've had a few folks write in about this - it's almost always that they're running the "getSettings" function instead of the "importFormResponses" function. Make sure to select the right function before you hit the run button in the apps script editor. Lemme know if it works for ya!
is there any way I can do that faster cause I have like more than 20 columns and 500 rows and execution time take like 4m for each row I really want to know if I can do that faster
@Bootstrapping Tools
Hmm... tough question. The Google Forms api only takes in one item at a time from what I know. The only other option would be to try and optimize your code a bit. 4 minute per row sounds longer than it should take, even for 20 columns.
The other option could be to do it in chunks or something like that.
@@BootstrappingTools it will be a pain anyway so I guess I'll try to optimize ...thanks for such great videos keep it going
The code seems to run ok, but I don´t get any responses imported. I am not a programer, so i don´t understand what´s wrong. Can you please help me?
If you have some sample files, please share them with support@bootstrapping.tools. I'll see if I can lend a hand here.
I have the same issue. The code executes in less than 1 second with no error messages, but nothing happens. I sent an email to support and hoping to update with a solution! It's probably something simple that I'm missing.
@@BootstrappingTools I am running into the same problem. It runs in less than one second, and nothing happens. I will send a sample file to the email you provided. I even renamed my sheet ImportList lol
Thank you for the video. I tried to donate to download the code. The link "I want this" isn't working. I tried 3 different browsers from 2 different computers and the result is the same. I want the "with code comments" option. I tried them all. Any thoughts?
sorry for the late response, the links should be working now!
Thank you, it worked great!
It's a shame that we can't sync Sheet to Form, instead of only Form to Sheet
This is outstanding! I made the donation and am working with the code. As a newb to app script, I’m struggling. So I have a couple questions:
I put this in the app script for the form, replaced the id codes in the ‘getsettings’ function with the relevant ids from the web addresses (from edit mode for the form), ran each function, and am getting an Error for ‘getType’. It says, “TypeError: Cannot read properties of undefined (reading ‘getType’).” What am I missing?
Second question; one of my favorite app scripts is to add edit urls. So far as I can tell it’s a popular one for the layman. Since it’s applied in the app script for the destination spreadsheet instead of the app script for the form, it’ll still work, right?
Thanks in advance!
For the getType() error, that sounds like it's b/c the wrong thing is being passed there... send an email to support@bootstrapping.tools with a screenshot of your code and I'll take a deeper look for ya.
For the second question... I'm not sure I fully understand what you're saying.. What are you trying to do there?
TypeError: Cannot read properties of null (reading 'createResponse')
I am really wanting to apply what you have created in this video. I am a real novice to the code. I am a teacher and I want to be able to past the students grades into the sheet and click the code and have it go directly into the form. This way I do not have to type in over 120 grades by hand each day. Any suggestions where I can get the code you have created. I have paid for the code, put the ids in, but nothing happens
I got it to work, but now it pulls my email address, any way for it to pull the email address in the sheet?
Hi Timothy!
There's no direct way to assign the email respondent when importing responses, but you can have a separate Text Field for email and import it into that field. It won't show up in Google Form's report, but you can create a separate dashboard if you need to see the results per email.
Have you been spying on my todo list? Because first it's the dependent drop downs, and now yes, I absolutely was wondering how I was going to transfer a whole tonne of data from one spreadsheet into a new Form-related system and was thinking I'd have to do it record by record through the form.
Now - perhaps not.
Haha, glad to hear you're finding everything useful!
Feel free to reach out if there's anything you'd like me to cover. I've been a bit slower with making videos lately as I try to figure out a better format, but I'll be starting back up again really soon!
how to send linear scale item type as a response? Man
Great question!
It would be a scale item, so you'd need to do something like:
item.asScaleItem()
Using the code from the video, you'd want to add this new case into your switch statement:
case FormApp.ItemType.SCALE:
result = item.asScaleItem();
break;
Please help! I have a google forms that I change and a sheet with some answers, I want that forms can read that answers that i had before, i have watch your tutorial a lot of times and even payed for the code, but i don´t get it, PLEASE help is for a good cause.
What kind of error message are you getting when you try t run the script?
@@BootstrappingTools I don´t know how to do it, i thought it was more easy, i don´t really know how to code.
You are incredible, thank you so much!
thanks! It's so great.
code line 27: newResponse.withItemResponse(responseItem.createResponse(formEntry))
code CheckboxItem: case FormApp.ItemType.CHECKBOX:
result = item.asCheckboxItem();
break;
Are you receiving an error that you need help with?
@@BootstrappingTools I got this error! 😭
@@BootstrappingTools I hope you can help me
That only looks like part of the error message. can you provide the full message?