Video instructions and help with filling out and completing Fill Form 2220 Etc

Instructions and Help about Fill Form 2220 Etc

Welcome back today is February 10th 2017 it is Friday and today I'm going to show you a tip in Google Forms that can save you a bunch of time so let's get started so oftentimes you might create a form and let's uh let's do one from scratch here in try so we'll go new and we'll say more and we'll create a new form so we have the form up there and let's just call this test form so I could type and the first question you might ask is what's your name that's fine they're put set a new question and let's say another question you might ask often is what's your district and you don't want them to necessarily type it in you want it to be a multiple-choice question but you don't want to have to go through all 13 districts every time you send out or create a new form so I'm going to show you a quick way that you can populate these choices from a existing list of data so let's get started the first thing you need to do is let's go back to Drive and you'll see I previously created a document called form choices we open that up here so you have two columns right now we're just going to concentrate on the first column here but you can have as many as you want for all of the different choices that you want to create the let's just focus on districts so I just have a column header here called district and all of the districts underneath there we can easily add more at any time and it'll automatically be brought into the form but that's it there's nothing special about this spreadsheet you know just the data the data is here in the sheet for the answer choices that I want to use in the form let's go back to the form so I already typed in district and I have multiple choice if we click on the puzzle piece up here add on I will see form Ranger form Ranger isn't there I'll put a link to it in the show notes for you to add it to your Google Forms and let's go ahead and click on that and then we'll click on the start let me move my picture out of the way so we can see what we're doing over here alright so you can see it says district and what do we want to do we want to populate form values are from a value list so we'll go ahead and click on that and we'll say a new value list so that'll bring up a list of sheets we can pick from I know that my values are in the sheet called Form choices so I'll go ahead and select that and click on the select button by default it selects sheet 1 within my sheet that's where my data is located so that's alright and the column that contains my form choices in this case is district that's where all my districts are located I'll go ahead and click on next so give this value of listening we'll call it district will save and populates that's it so now you can see here that it automatically populated all those multiple choices there so whether that was a multiple choice or whether it was a drop-down all of those not choices aver automatically that's uh that's it you can do some other things like you can update it update the list on every form submit if you wanted to you can update the list every hour if you wanted to but just very basic it's a quick easy way for you to get form choices that you use over and over again in the same in a form without having typing type them each time you create a new form I hope again you found this to tip valuable if there's other things that you'd like to see please don't hesitate to ask I did meet with someone today about using mail merge and creating custom letters so that'll probably be in an upcoming session but again if anyone ever has any questions don't don't hesitate to email me or put some notes in the comments and I'll do whatever I can to help you guys out have a great day or have a great weekend again in his Friday cnx time by