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

Jason Jurotich · 124K views · 2015 · 12:44

Open on YouTube

Python, Ruby & scripting languagesSoftware (other)tutorialdated

Why Stack Overflow recommends it

Stack Overflow users link it when answering questions about generating or populating Google Forms from Google Sheets data with Apps Script.

Recommended by 1 people across 1 different months, 2016 to 2017.

What it is

A screencast by Jason Jurotich showing how to build a complete Google Form automatically from data in a Google Spreadsheet using a Google Apps Script. He explains he assembled the script from snippets found online and shares a copyable public version, plus a simpler one without the image item. The description notes it has been superseded by a newer version of the video.

What people said

Recommends ReyAnthonyRenacia · 2017-05 · Stack Overflow · on “Display Data from Google Sheet into Google Forms”

Check the Quickstart: Managing Responses for Google Forms [LINK] as it demonstrates connecting Google Sheets to Google Form, which is the first step in your project. Then there's the HOW TO CREATE AN ENTIRE GOOGLE FORM FROM SCRATCH FROM A GOOGLE SPREADSHEET [this video] video tutorial, which may offer additional insight.

Cites Beau Branson · 2016-07 · Stack Overflow · on “Create a Google Form (or similar) that verifies Student ID before submission”

Based on what @Ed Nelson shared with me, it looks like Formfuse ay allow me to achieve what I was looking for: [this video]

Cites Rockn · 2016-08 · Stack Overflow · on “App Script Array from Named Ranges”

Not sure why I want to reinvent the wheel, but this uses values in rows and I wanted to use the columns for the building of the form. I am assuming it is just a matter of swapping out column length for row length and iterating through the rows in a column. Pretty cool though. [this video]