I've been looking for resources that cover using data from Google Sheets to generate Google Forms, and you're right. There just aren't a lot out there even though it seems like a very natural thing. This video is perfect for one of the tasks I'm trying to accomplish and huge thanks to Jordan for that. The other resource I've found that's pretty good is a course covering Apps Script by Ben L. Collins. It's more starter material, but it does cover using Apps Scripts to make Forms using data in Sheets.
I subscribed, thanks Jordan. Very useful script, inspires me a lot to develop your script to do more automatic things with google form that suits our needs. Thanks again, you are my teacher!
I am a new learner on google sheets and apps script, I try to documenting my simple learning result in this channel ua-cam.com/channels/uCFRM4818jYd2WdqX4QXDQ.html
Can I add custom menus to Google Forms making it available for end user? Need to have different sections available to end user as menus while responding to the form
is this possible let's say you completed G forms then you submit it but after you submitted it it's close the current G forms then open up this other G forms instead of a next section with the same question as the previous G form had with little bit of new question but also carry's some answer from the previous G form to this newly opened up G form?
Does anyone know if it’s possible to add a textbox in a google form using app script where I have two columns The first one where the user writes names and the other one enters numbers.? Is there any solution where you can send me to? I’m a rookie appscript user. Thanks in advance.
please define how to make your roaster into searchable i want search from sheet and assign value of input where i searching please response soon as you possible
Do you mean searchable in the form? Unfortunately you can't build that functionality into a Google Form. You will have to write a custom HTML form for something like that. Sorry to disappoint!
Thanks for the great video. I attempted to recreate your work using the code available on Git Hub. The code in your video is different to the code in GitHub. When attempting to run your code to better understand it fails on all sorts of levels. Very disappointing. For that you get a down vote. :(
+Dane Ryan Bummer :( I will take a look at this one later. Not sure what has changed since creating this but it will be fixed. Thanks for keeping me on my toes!
+Jordan Rhea Thanks for replying. I was able to get it to work somewhat by adding the following to the getClasses function: var classSelect = form.addMultipleChoiceItem().setTitle('Choose a class'); and var form = FormApp.getActiveForm(); - Still messing around with it.
Finally! The first tutorial I have seen that even talks about pulling data from the google sheet and using it in the Google Form!!!!! THANK YOU!
I've been looking for resources that cover using data from Google Sheets to generate Google Forms, and you're right. There just aren't a lot out there even though it seems like a very natural thing. This video is perfect for one of the tasks I'm trying to accomplish and huge thanks to Jordan for that. The other resource I've found that's pretty good is a course covering Apps Script by Ben L. Collins. It's more starter material, but it does cover using Apps Scripts to make Forms using data in Sheets.
❤️
I subscribed, thanks Jordan. Very useful script, inspires me a lot to develop your script to do more automatic things with google form that suits our needs. Thanks again, you are my teacher!
I am a new learner on google sheets and apps script, I try to documenting my simple learning result in this channel
ua-cam.com/channels/uCFRM4818jYd2WdqX4QXDQ.html
I will be watching this again. I would parse multiple grades and multiple teachers at each grade from one roster sheet. Great stuff!
+Chris Wherley thanks a ton for the support! Let me know if you have ideas for 2018 that can help teachers be their best!
Nice video!
Very clear explanation. Similar to what I'm trying to do!! Thanks for the info!
So nice to hear it was helpful!
Hi, where I can find the code ?
Please how can you identify Google users without having them input data in the form?
Thanks a lot!! I've been looking for this kind of tutorial to make a form just like this!!!
very useful..simple clear explanation. can do with a link to the code though!!Thank you in advance.
*How to insert an image(which is present in my google drive) to a google form(while creating a google form) using App script??*
Can I add custom menus to Google Forms making it available for end user?
Need to have different sections available to end user as menus while responding to the form
Hey Jordan!! nice expanation
where i can get your code?
Hi Jordan, nice tutorial! I am trying to do exactly the same, can you please share the code.
is this possible let's say you completed G forms then you submit it but after you submitted it it's close the current G forms then open up this other G forms instead of a next section with the same question as the previous G form had with little bit of new question but also carry's some answer from the previous G form to this newly opened up G form?
Does anyone know if it’s possible to add a textbox in a google form using app script where I have two columns The first one where the user writes names and the other one enters numbers.? Is there any solution where you can send me to? I’m a rookie appscript user. Thanks in advance.
kindly post the code in the description so that we can use it easily.
HI SIR CAN YOU TEACH US. HOW TO RESTRICT DUPLICATION IN GOOGLE FORMS. ACCESS CODE ALREADY ENTERED THATS I MEAN.
THANKS.
Você explicou no vídeo um script e fez referencia a outro script diferente que não funciona.
Can you share the link for the form?
how to disable copy paste in google form
Excelete información, agradecere puedas conpartir el codigo saludos
is this to get the answers?
never mind
please define how to make your roaster into searchable
i want search from sheet and assign value of input where i searching
please response soon as you possible
Do you mean searchable in the form? Unfortunately you can't build that functionality into a Google Form. You will have to write a custom HTML form for something like that. Sorry to disappoint!
Thanks for the great video.
I attempted to recreate your work using the code available on Git Hub.
The code in your video is different to the code in GitHub.
When attempting to run your code to better understand it fails on all sorts of levels.
Very disappointing.
For that you get a down vote. :(
+Dane Ryan Bummer :( I will take a look at this one later. Not sure what has changed since creating this but it will be fixed. Thanks for keeping me on my toes!
+Jordan Rhea Thanks for replying. I was able to get it to work somewhat by adding the following to the getClasses function:
var classSelect = form.addMultipleChoiceItem().setTitle('Choose a class');
and
var form = FormApp.getActiveForm();
-
Still messing around with it.
@@shoelase1015 were you able to get this form to work?
Você ainda não corrigiu no Git Hub
@Dane Ryan poderia postar o script completo?