HOW TO CREATE AN ENTIRE GOOGLE FORM FROM SCRATCH FROM A GOOGLE SPREADSHEET (USES SCRIPT)

[@drfacelook4824]

TEXT,PARAGRAPH,CHOICE,CHECKBOX,LIST,GRID,IMAGE,PAGE,SECTION,TIME TYPE QUESTION HELP IMAGE/VIDEO OPTION 1 OPTION 2 OPTION 3

[@olleryokel]

Many thanks for this Jason, a heads up though - with the new GForms I was getting holes in my form with some blank questions created but no data inserted. They seemed to be at random intervals e.g. Q1-2 are fine, Q3-5 blank, then Q6-9 OK. Happened many times. Then I tried again with the old forms (copied an old one I had) and it worked fine.

[@imansaraei]

That was truly AMAZING. Helped me out big time. THE best script I've ever seen. TNX M8.

[@Ben28282T]

Hi Jason, just found your video and I would have to say great content and easy to follow. I have a question though, what change in the script do you need to make it a quiz? And I followed the instructions but the questions and choices got mixed up and there is a "multiple choice" as part of the choices. I will browse your newer videos if maybe the answer is already posted. subscribed.

[@JasonJurotich]

Please see my newer video on this to make exams. Take care!! kzbin.info/www/bejne/qonbnKyuoryte8k

[@mdhare1515]

hello, need your help to create a *dependent dropdown* in *google form* using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it. P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*. thanks in advance

[@manojpooleery4153]

Thanks a bunch! Worked well for my needs. A minor tweak - when you run the script multiple times, it was duplicating the form fields. So, I added these lines after the var form line - var numberItems = form.getItems().length; for(i=0;i < numberItems;i++){ form.deleteItem(0); }

[@MihirRawal]

Thank You. I was getting same issue. You resolved my issue :)

[@bridgetnoco7732]

Love the code Jason, but like Stephen Bent below I am getting an error when I run the script: "Invalid ID (line 8, file "Code")" I've created another Sheet from scratch and copy/paste the Sheet ID (between d/ .....and .../edit) again but still getting error. Any help would be great. Thanks!

[@FANISITE]

Bro. Can u help me create a form with following rules: 1-Each question appear and disappear within Specific time 2- divide Google form into two sections, section one should be login and section two will be quiz but quiz should keep randomize from questions bank 3- i don't wanna use any add-on as they not fully functional and helpful. So i wanna do it all in script. Plz guide me

[@deltapi7]

Thank you very much, I have been using add ons as formCreator but it doesn't do all that I want, with your video and the code I can adapt it to my needs, regardless I am not an expert. Thanks!

[@pedrogonzalez7053]

If the image file is in your Google Drive you can use this script else if(questionType=='IMAGE'){ var fileId=data[i][3]; var img = DriveApp.getFileById(fileId).getBlob(); form.addImageItem() .setTitle(data[i][1]) .setHelpText(data[i][2]) .setImage(img); } but in column 3 you have to put the id only: 1_5kWR4FAJBVMRwsktNnlNZFG-Bm40tz_ not the entire Google Drive link

[@JasonJurotich]

Yes, the drive files should only be ID only. As well, I have a newer video on this, please take a look. kzbin.info/www/bejne/qonbnKyuoryte8k

[@pleabargain]

thank you Jason! I managed to reproduce your script but with a minor bug. Multiple choice Q comes up even though MC is in use in the sheet. I see that required is defaulted to true. Any plans for adding code for control of boolean via the spreadsheet? Again, many thank for your script. Here's my video kzbin.info/www/bejne/epSrc6WpeZlma9U showing that your work is reproducible like a good computer scientist should! Thanks again!

[@billyuy5254]

If their will be possible to trap the check box once the check box is check by the 1st responded then the 2nd cannot check the checkbox

[@SedoSan]

Do you have a "Go to section depending on answer" option? also a clear all in case of editing?

[@agnieszkawasowska]

Hi! Did you find the answer to your questions about "go to section depending on answer"? I'm struggling with this and can't seem to find any answers.

[@周柏亦-e8f]

Your teaching is very useful! Could you also tell me how to fill the answers (CHOICE) and points from spreadsheet to the form?

[@mrbrigham]

Yeah me too. I would LOVE to know how to do this! I see how you can add the answers in the form manually. How would one incorporate that into the script? Thanks a bunch!

[@marycollins3579]

This worked fine twice, but today I got an error: TypeError: Cannot call method "getDataRange" of null. (line 3, file "Code"). Any help you could give me with this error would be much appreciated. Thanks.

[@cgambe]

Hi, I run the script and nothing happens in the form. Can anyone help? I followed the steps in the video and rewatched many times to make sure I wasn't missing something.

[@JasonJurotich]

Please watch the newer video (kzbin.info/www/bejne/qonbnKyuoryte8k) and use the script below. github.com/jasonjurotich/JJ-GAS/blob/master/formFromSheetComplete.gs

[@smazkazz]

Hi there, thanks for this great video and script. Unfortunately when I run the script, the answer key doesn't get filled in the g form. Is there any way of doing this.

[@JasonJurotich]

Please use the new script to see if it works better. Next year this will move to python, and I'll make a new video then. Take care. kzbin.info/www/bejne/qonbnKyuoryte8k

[@esnews-1788]

It is great. Thank so much. I want to create a field of answer for 'choice' in spreadsheet 'sheet1'. Please give solution.

[@DrINTJ]

How can it also set which section to go to next (in a two row method to keep the number of option tied to the number of columns and not complicate things)? For example in " for (var j=0;j

[@mariocalderonramirez8538]

there is the .setImage() in the class MultipleChoiceItem ? because I tried to add images in the multi-options, and it's not possible. Could you help me?

[@annettehickman1725]

Thank you Jason, this is a big time saver. It seems like exactly what I was looking for. I will try it and let you know how it goes. Keep it up!

[@quijadajr]

What if you want to build a drop down list, with the following conditions: If you select option A from the list, it displays A amount of styles; if you select option B from the list it displays styles only for B and so... ? I'm building a form for my job, but I need it to have a drop down with the BRANDS we sell, and with each brand shows the styles of those brands.

[@antonynaude3372]

Hi Jason, do you have a script that can "delete" all the questions if I wanted to change the questions, etc. without having to create a new form / link etc.

[@JasonJurotich]

I don't have one yet, but Google is coming out with a new Forms API in a couple of months and I will be making more videos on this when it's active. I'll let everyone know in about a month or so.

[@antonynaude3372]

@@JasonJurotich I created sections/pages but want I am struggling with is the dropdown "Go to section based on answer" to direct the student to complete a section based on what the choice was

[@epepepe7178]

his content has not been created and approved by Google. Notification of Arbitration - Terms of Service it gets me this when i try to go in a google form and its super annoying can i fix this?

[@snehmanjari2900]

Could you please add a sample spreadsheet for which this query can run ? Sorry, I am new to this and want to try this for a project I have in mind .

[@mohammadadawi]

thanks man

[@freshair574]

That is a very usefull script. But my trial is stuck. Help please: Error message: Cannot read property "length" from undefined (line 101)

[@ayurwisdomayurveda3059]

how to get script for form from sheet

[@tomsheets6399]

when I run the script and it goes to permissions it says "This app hasn't been verified by Google yet. Only proceed if you know and trust the developer" ...and it warns me that it is unsafe to go forward. Ugh, and I spent all this time following the instructions on this video...

[@sajadghanbari3547]

Hello, How I can create a writable table in the google form. writing in row, column, boxes?

[@SolidBuildersInc]

Hi Jason Jurotich, You are on to something very interesting. A question is can you have a "Branch Logic" or "Workflow Multi Page Conditional Logic" built into the solution?

[@juniorgupta7853]

I keep getting this error "Range not found (line 76, file "Code")" previously i got same error in line 36, now it is 76 but no idea what to do as i am a novice in scripts and forms

[@drashtipatel515]

from where i copy this coding.....

[@Coltaa-lr4dp]

If I were you, I would have changed the title of the video and add (Not working anymore)

[@stephenbent7215]

the script doesn't like the ID i'm copying. "Invalid ID (line 8, file "Code")"

[@jansyrinek2913]

Not working says me: TypeError : Can not call method " getDataRange " of null . ( Line 3 , set the "Code" Can you help? I don't see any mistake :/ Thanks

[@DarkNixilius]

Same of me

[@pgcmrboyce1]

Make sure your 'sheet1' remains 'sheet1' unless you have renamed the sheet (not the workbook). I renamed my workbook the first time I used it and went in and renamed my sheet and it game me the same error.

[@juniorgupta7853]

Its still not working

[@jamesjeaniv5023]

Is it possible to implement heat mapping in Google Forms? That is is to say, click on an image and you can get where they clicked back? I want to map geo locations of fields, by heat mapping user clicks, then transforming that data into geographic coordinates.

[@hamdisultan]

What about a standard template to make a spreadsheet and fill it with questions offline. Then import it to google spreadsheets and run the script> Is that possible?

[@vamsik28]

Is it possible to change the fields layout, like one field coming next to another field in google form?

[@hardimulya]

awesome script :). thanks.. it's help me alot. :) thanks

[@calebparkermusic]

Hi Jason, I've directly copied your script and it seems to be working fine EXCEPT that in some cases when I use this, some of my data doesn't make it over to google forms. For instance, numerous times when I have, say, 20 options in a row, only 10 would make it over. Do you know why this might be happening? Thanks for any insight!

[@kobuszek]

Hello! Is it possible to make a random-question quiz using your script and google tools? What I want to achieve: I have 80 questions and I want to make from it a 20-random-question quiz, which will be diffrent for every participant. I've digged around thousends of sites but I didn't find the solution. Could you answer my question, please?

[@JasonJurotich]

Google came out with new commands for Google forms just a couple of weeks ago. I am redoing various things and hopefully in the summer I will have something new to show everyone. I will try and touch upon this point when I do. Thanks!!

[@alixturley8612]

hello Jason, I was wondering if you have a video on marking the google forms? I am aware there is a way you can manually insert extra columns into the spread sheet and insert the correct answer. Can you please point me in the right direction?? i'm a little stuck.

[@navjotsinghseehra7150]

Hey I am receiving this error (No item with the given ID could be found, or you do not have permission to access it. (line 8, file "Code") Plz help

[@zeeshanmaniar6239]

Hey Jason. Thank you for the video. I am trying to work on a project where I need questions to show up only one time. So for eg. If I have asked 2+4 = _____ and one someone who has the link to the form already answered that than it shouldn’t pop up for anyone else. Any idea how can I do it?

[@JasonJurotich]

Thanks Isaac Kerson Yes, you can, and I already developed another script to do this. I hope to add this in a video this summer, depending on my workload. If you subscribe, you should get the notification when it comes out. Take care!!

[@adityapappu4963]

Thanks for the video. I am getting the following error: TypeError: Cannot call method "getSheetByName" of null. (line 2, file "Code"). Any suggestions on how I can rectify this?

[@antoniograterol99]

Thanks, that's some pretty cool stuff!! I'm looking for some help and I wonder if you could guide me with a little project with a google form... I'm new to g-suite apps but i've some background on excel vba... My dilemma is that I need a form that checks data within a google sheet (similar as formranger add-on) and forbids the submission of the survey if that registry was already made, so the form has to check a google before submission. If hope I could explain myself. Thanks in advance!

[@paraswahi9488]

bro ur awsome doing great work keep uploading more good videos like ṭhis

[@itsikr987]

Hi, Very useful script thank you! I'm using the Google form as a quiz and therefore I need also to upload from the excel, automatically, the answer key - is there a way to do it ?

[@srinivasbsrichemistry]

How to add answer and points

[@kaushikbiswas9556]

I must say this script is very basic and does not allow sufficient flexibility towards other functionalities within google forms like data validation and section wise referencing against multiple choice responses.... Much of the form still requires manual intervention once it is created. An add-on with a UI to enter customizable choices to build the form and link to various sections would be of great help.

[@JasonJurotich]

Please see the new version, Thanks!!! : kzbin.info/www/bejne/qonbnKyuoryte8k

[@dannykou123]

Thank you!!! It really helps a lot. But I still have a question. Is it possible to store the result in the certain cell of the spreadsheet where I want while filling the form? THX

[@khemrajrana7322]

Sir I have a question I have type in google spreadsheet and he is automate drop down in google form how that

[@kesavakumartammireddi3315]

Hi, Can we shuffle questions or can I ask only few questions?

[@al-aminmollah7650]

It was my dream. Thank u for uploading.....

[@dailosumpierrez7029]

When I link the form with the spreadsheet, I would like to know how I can put a number in a column and that these are not rolled when I enter the form responses. Thank you Dailos Sorry with my English, it's not my native language

[@mahatokysolutions1496]

Hi Jason, great video, really helps. How to do if I want to invert columns and rows. I mean, I want to input the options in the columns not in the rows. Thank you

[@rdnich]

Jason, do you know how to integrate google forms in a mobile GIS app?

[@jawsstech]

are you a teacher. your style is very effective.

[@JasonJurotich]

Yes I am. Cheers!

[@gautamsir]

Thank you Jason great script which we want

[@0dark35]

What does the code look like for a dropdown box if we want to append the script?

[@SolidBuildersInc]

Great Video! Question? For the "Grid" category, is there a way to have multiple choices instead of a single selection per row?

[@Coltaa-lr4dp]

THANKS. I HAVE TRIED IT AND I GOT THIS MESSAGE "Sign in with Google temporarily disabled for this app"

[@Coltaa-lr4dp]

I wish I have read the comments before I watched the video.

[@JasonJurotich]

Please try the new code to see if that changes things, otherwise check your Chrome accounts to see if that is causing the problem. kzbin.info/www/bejne/qonbnKyuoryte8k

[@bonsuadjei-arthur2091]

Great tutorial, have a bit of a challenge with the IMAGE, does any image just work with it

[@Robustlife_multigrains]

But programming whereabouts

[@jsvlad]

spent an hour trying to figure out why the url thing wont work.. gave up :(

[@gilleal9132]

Informative but the audio needs work...too much echo

[@JasonJurotich]

Yes, this video is quite old, the newer one is better, and the most recent videos should sound much better. I hope that newer videos have the sound problem resolved. Thanks. kzbin.info/www/bejne/qonbnKyuoryte8k

[@heromiIes]

You can do whatever you want. It's not going to affect anything.

[@tetrapaktjernobyl]

I only get the script to add the first 15 options. not infinite like you say in the video. any hints to why..?

[@tetrapaktjernobyl]

or 19.. when the only thing ive changed is the name of the form..

[@danieldranove6682]

I pasted form URL name in but when I run the script nothing changes on the form. I triple checked I pasted it in right.

[@abrahamgluck]

I also have the same thing.

[@AFLolowang]

Been looking to this forever. THANK YOU!!! Like and Subscribe.

[@AFLolowang]

Nevermind, script editor on Google Sheet doesn't work in 2020.

[@JasonJurotich]

I am waiting for the forms API to come out and will redo this in Python, but you can still do this with GAS, but it just became a little more complicated.

[@abubakarabbas9945]

Please I need the source code

[@JasonJurotich]

github.com/jasonjurotich/JJ-GAS/blob/master/formFromSheetComplete.gs

you sir, are a genius

[@premajaiswal]

hi Jason , how can we add tables to capture data

[@doctoradomicilioelsalvador]

Thanks a lot! Great!

[@amw99]

Great- 'Scale' is another question type. Can I use it within your script?

[@JasonJurotich]

+Aaron Weisberg Yes, the new script that is under video has the option to use scale. I will try and put up another video on this. Thanks.

[@elorady3894]

what if i need many sheet what i need to do ? thanks

[@karthicknarayanan3497]

tangam da ni. You made my work easy. Thank you.

[@pkganeshbabu]

Wonderful Coding.

[@JasonJurotich]

Thanks

[@abrahamgluck]

pasted form URL name in but when I run the script nothing changes on the form.

[@abrahamgluck]

Caps necessary to be in caps

[@IAMBRIANFORD]

It keeps giving me an error at line 2 "getsheetbyname"

[@andresgonzalezsanta-cruz8979]

how is it posible to upload ???

[@calistawoon8239]

Many thanks to you!

[@hamdisultan]

This is great solution. Thanks

[@fransizcocuk]

hello this is jesus speaking

[@Wu11er]

Thanks for the tips bro!

[@jalalbusri7294]

Hi, thank you for the sharing. Does it work with Flubaroo? Regards

[@JasonJurotich]

+Jalal Busri I don't use Flubaroo so I would not know. I use another system which I will be making a video of very soon. Take care.

[@jalalbusri7294]

Thank you Jason. Waiting for your new video.

[@alexdeguzman4273]

ru in space?

[@DrINTJ]

You are awesome!

[@glaucyaboechat]

Thanks :)

[@RandolphAbelardo]

awesome !

[@captainjacksparrow1143]

nic bro

[@tracylu1783]

where do the responses go?

[@JasonJurotich]

+Tracy Lu More than one person has asked me this so I will make a video very soon about how to set them up. Thanks for asking.

[@VieuxShef]

Epic!