Auto Fill Google Doc from Google Form Using Google Apps Script

[lOI]

This was exactly what I was looking for to populate a document with client info, thank you!

[HighGravityHipHop]

Hey Jeff - I am doing a Fill In the Rhyme Workshop for a DEI Class I am launching. This was perfect for saving my students a step by taking their form and completing the document I will give them to rehearse from. You just helped me write my first little script - I am learning solidity as a hobby, so this was neat to incorporate into my education project. Worked like a charm. I got one error -misplaced comma that I quickly noticed and worked perfectly after that. Great job man - great pace, great detail, super job brother!

[palmermiddle]

Thank you, Thank you, Thank you. This is perfect for quickly creating, organizing, and sharing lesson plans.

[justthoughts]

I love how you went over each code line by line

[furiousflower]

To be honest: this was way too complicated for me and I'm still stuck with the problem I am trying to solve 😂 But I am liking and comment for the algo, because I really like your energy in the tutorial. Thanks!

[imperfectbujo]

Jeff, 2 years after you posted, I was able to follow along and increase my paperwork productivity. Amazing. Now I have to research how to use a drop-down menu to print more extensive verbiage.

[annasaysthings]

Thank you so much! I can't believe Google hasn't made a proper function between form and doc yet. I came here to learn this because I was trying to make one-link access to a form on my Role Playing Discord, for people to submit their Original Characters for roleplay, and then THAT response into a reference doc that I could share with all the players on discord about each player. Woo!

[rainohansen]

15 minutes video = 3 lessons anticipated in the class room with rookies. I have 80 this year, so I should branch out for the German speaking students on the part vocational track towards a trainee position. I should be able to use the "title" to demonstrate the possibility of formatting the text for the more casual tone in Switzerland of maskuline and feminine in the text, to deviate from the unisex polite standard German "Sie" .
A completed traineeship is for several topics qualifying for the University acceptance, including ETH Zürich.

[chuck]

Jeff, I'm just getting back into coding and could not stand the online courses. I did your simple example, and it is indirectly related to one of my projects, and I am hooked. The code is simple but it gives me a start. Good job and thanks.

[denisstpierre]

Thank You for this walk through. Clear, organized and Concise! Really helped me see what is possible with Apps scripting. 👌

[davidkrupski]

Great job Jeff. I really appreciate the walk through. I am a school leader and I wanted an easy way to create walk through forms to then populate them and then I could send them to the teachers in my building. Thank you so much!

[verko]

Thank you for this!
I am a middle school teacher and in the course of less then an hour, I was able to make a form, and edit a template for lesson plans. It should save me dozens of hours in the future!

[dabeldasac]

The best, easiest, simplest explanation i'v ever seen!
Thank you so much1

[matthewcashatt]

I'm getting undefined errors for all variables starting with e. What am I doing wrong?

[yeerehneh]

u saved so much time for me and my internship. thank you!

[jessicaseger]

I've used this tutorial before to auto fill a google doc from a form, but I'm wanting to put my doc template in a google sheet. The main purpose is for that sheet to look similar to a doc if I were to print but to also have the ability use the "sum" function available in a sheet to add up info that will be added after the sheet is auto created from the script.

[TheTramos]

Nice video. I took it as a base of a project using a sheet template instead. As several users will be sending responses at the same time, I preferred to use batch processes with triggers.

[katdancer]

Finally. I have been looking for this solution. Thanks for the explanation Jeff.

[ARIFMAULANADANANJAYA]

nice video, question

TypeError: Cannot read properties of undefined (reading 'values')

how to fix that?

[mayonvolcano]

I got an error saying that the e and the other values from e is undefined